P_GteeMBillingElmntEntrFlwDoc

DDL: P_GTEEMBILLINGELMNTENTRFLWDOC SQL: PGMBLGBEEFDOC Type: view COMPOSITE
14 Fields 3 Data Sources

P_GteeMBillingElmntEntrFlwDoc is a Composite CDS View in SAP S/4HANA. It reads from 3 data sources (I_GLAccountLineItem, I_BillingDocumentBasic, I_BillingDocumentItemBasic) and exposes 14 fields with key fields BillingDocument, BillingDocumentItem.

Data Sources (3)

SourceAliasJoin Type
I_GLAccountLineItem FinArDoc inner
I_BillingDocumentBasic SDBillDocHead inner
I_BillingDocumentItemBasic SDBillDocItem from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PGMBLGBEEFDOC view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.buffering.status #NOT_ALLOWED view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
VDM.viewType #COMPOSITE view
VDM.private true view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #P view
ObjectModel.usageType.sizeCategory #XL view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY BillingDocument I_BillingDocumentItemBasic BillingDocument SD Document
KEY BillingDocumentItem I_BillingDocumentItemBasic BillingDocumentItem Item
ReferenceSDDocument I_BillingDocumentItemBasic ReferenceSDDocument Reference Doc.
ReferenceSDDocumentItem I_BillingDocumentItemBasic ReferenceSDDocumentItem Reference Item
ReturnItemProcessingType I_BillingDocumentItemBasic ReturnItemProcessingType Returns
OverallBillingStatus I_BillingDocumentItemBasic OverallBillingStatus Status
CompanyCode I_GLAccountLineItem CompanyCode Receiver Company Code
FiscalYear I_GLAccountLineItem FiscalYear G/L Fiscal Year
AccountingDocument I_GLAccountLineItem AccountingDocument Journal Entry
_BillingDocumentBasic I_BillingDocumentItemBasic _BillingDocumentBasic
_OverallBillingStatus I_BillingDocumentItemBasic _OverallBillingStatus
_JournalEntry I_GLAccountLineItem _JournalEntry
_CompanyCode I_GLAccountLineItem _CompanyCode
_FiscalYear I_GLAccountLineItem _FiscalYear

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_GteeMBillingElmntEntrFlwDoc.
-- 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: PGMBLGBEEFDOC

CREATE VIEW P_GteeMBillingElmntEntrFlwDoc AS
SELECT
  SDBillDocItem.BillingDocument AS BillingDocument,
  SDBillDocItem.BillingDocumentItem AS BillingDocumentItem,
  SDBillDocItem.ReferenceSDDocument AS ReferenceSDDocument,
  SDBillDocItem.ReferenceSDDocumentItem AS ReferenceSDDocumentItem,
  SDBillDocItem.ReturnItemProcessingType AS ReturnItemProcessingType,
  SDBillDocItem.OverallBillingStatus AS OverallBillingStatus,
  FinArDoc.CompanyCode AS CompanyCode,
  FinArDoc.FiscalYear AS FiscalYear,
  FinArDoc.AccountingDocument AS AccountingDocument,
  SDBillDocItem._BillingDocumentBasic AS _BillingDocumentBasic,
  SDBillDocItem._OverallBillingStatus AS _OverallBillingStatus,
  FinArDoc._JournalEntry AS _JournalEntry,
  FinArDoc._CompanyCode AS _CompanyCode,
  FinArDoc._FiscalYear AS _FiscalYear
FROM I_BillingDocumentItemBasic AS SDBillDocItem
INNER JOIN I_BillingDocumentBasic AS SDBillDocHead ON /* join condition not captured in parsed metadata */
INNER JOIN I_GLAccountLineItem AS FinArDoc ON /* join condition not captured in parsed metadata */
;

Learn More