P_RU_RecnclnDocDet000

DDL: P_RU_RECNCLNDOCDET000 SQL: PRURECDOCDET000 Type: view CONSUMPTION
18 Fields 2 Data Sources

Document Dtermination - Helper base view

P_RU_RecnclnDocDet000 is a Consumption CDS View that provides data about "Document Dtermination - Helper base view" in SAP S/4HANA. It reads from 2 data sources (I_RU_Contract, I_OperationalAcctgDocItem) and exposes 18 fields.

Data Sources (2)

SourceAliasJoin Type
I_RU_Contract _Contract left_outer
I_OperationalAcctgDocItem _FinancialDocument from

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName PRURECDOCDET000 view
EndUserText.label Document Dtermination - Helper base view view
VDM.private true view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view

Fields (18)

KeyFieldSource TableSource FieldDescription
CompanyCode I_OperationalAcctgDocItem CompanyCode Receiver Company Code
FiscalYear I_OperationalAcctgDocItem FiscalYear G/L Fiscal Year
AccountingDocument I_OperationalAcctgDocItem AccountingDocument Journal Entry
PostingDate I_OperationalAcctgDocItem PostingDate Posting Date for GR
DocumentDate I_OperationalAcctgDocItem DocumentDate Journal Entry Date
FinancialAccountType I_OperationalAcctgDocItem FinancialAccountType Fin. Account Type
AssignmentReference
Customer I_OperationalAcctgDocItem Customer Sold-to Party
Supplier I_OperationalAcctgDocItem Supplier Supplier
PostingKey I_OperationalAcctgDocItem PostingKey Posting Key
GLAccount I_OperationalAcctgDocItem GLAccount General Ledger
IsSalesRelated I_OperationalAcctgDocItem IsSalesRelated Is Sales Related
IsUsedInPaymentTransaction I_OperationalAcctgDocItem IsUsedInPaymentTransaction Is Used In Payment Transaction
CompanyCodeCurrency I_OperationalAcctgDocItem CompanyCodeCurrency Local Currency
AmountInCompanyCodeCurrency
TransactionCurrency I_OperationalAcctgDocItem TransactionCurrency Transaction Currency
AmountInTransactionCurrency
_GLAccount _GLAccount

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view P_RU_RecnclnDocDet000.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: PRURECDOCDET000

CREATE VIEW P_RU_RecnclnDocDet000 AS
SELECT
  _FinancialDocument.CompanyCode AS CompanyCode,
  _FinancialDocument.FiscalYear AS FiscalYear,
  _FinancialDocument.AccountingDocument AS AccountingDocument,
  _FinancialDocument.PostingDate AS PostingDate,
  _FinancialDocument.DocumentDate AS DocumentDate,
  _FinancialDocument.FinancialAccountType AS FinancialAccountType,
  coalesce(_Contract.AssignmentReference,'') AS AssignmentReference,
  _FinancialDocument.Customer AS Customer,
  _FinancialDocument.Supplier AS Supplier,
  _FinancialDocument.PostingKey AS PostingKey,
  _FinancialDocument.GLAccount AS GLAccount,
  _FinancialDocument.IsSalesRelated AS IsSalesRelated,
  _FinancialDocument.IsUsedInPaymentTransaction AS IsUsedInPaymentTransaction,
  _FinancialDocument.CompanyCodeCurrency AS CompanyCodeCurrency,
  sum( _FinancialDocument.AmountInCompanyCodeCurrency) AS AmountInCompanyCodeCurrency,
  _FinancialDocument.TransactionCurrency AS TransactionCurrency,
  sum(_FinancialDocument.AmountInTransactionCurrency) AS AmountInTransactionCurrency
FROM I_OperationalAcctgDocItem AS _FinancialDocument
LEFT OUTER JOIN I_RU_Contract AS _Contract ON /* join condition not captured in parsed metadata */
;

Learn More