P_BillingDocProcFlowC10

DDL: P_BILLINGDOCPROCFLOWC10 SQL: PBILLGDOPROCFC10 Type: view CONSUMPTION
9 Fields 2 Data Sources

P_BillingDocProcFlowC10 is a Consumption CDS View in SAP S/4HANA. It reads from 2 data sources (P_BillingDocProcFlowC0, I_SDDocumentProcessFlow) and exposes 9 fields with key fields LevelC0Document, LevelC0DocumentItem, LevelC0DocumentCategory, Level1Document, Level1DocumentItem.

Data Sources (2)

SourceAliasJoin Type
P_BillingDocProcFlowC0 Level0 from
I_SDDocumentProcessFlow Level1 inner

Annotations (9)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
AbapCatalog.sqlViewName PBILLGDOPROCFC10 view
AbapCatalog.preserveKey true view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY LevelC0Document P_BillingDocProcFlowC0 LevelC0Document
KEY LevelC0DocumentItem P_BillingDocProcFlowC0 LevelC0DocumentItem
KEY LevelC0DocumentCategory P_BillingDocProcFlowC0 LevelC0DocumentCategory
KEY Level1Document I_SDDocumentProcessFlow SubsequentDocument
KEY Level1DocumentItem I_SDDocumentProcessFlow SubsequentDocumentItem
KEY BillingDocument P_BillingDocProcFlowC0 BillingDocument SD Document
BillingDocumentType P_BillingDocProcFlowC0 BillingDocumentType Billing Type
SDDocumentCategory P_BillingDocProcFlowC0 SDDocumentCategory Document Cat.
SalesOrganization P_BillingDocProcFlowC0 SalesOrganization Sales Organization

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_BillingDocProcFlowC10.
-- 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: PBILLGDOPROCFC10

CREATE VIEW P_BillingDocProcFlowC10 AS
SELECT
  Level0.LevelC0Document AS LevelC0Document,
  Level0.LevelC0DocumentItem AS LevelC0DocumentItem,
  Level0.LevelC0DocumentCategory AS LevelC0DocumentCategory,
  Level1.SubsequentDocument AS Level1Document,
  Level1.SubsequentDocumentItem AS Level1DocumentItem,
  Level0.BillingDocument AS BillingDocument,
  Level0.BillingDocumentType AS BillingDocumentType,
  Level0.SDDocumentCategory AS SDDocumentCategory,
  Level0.SalesOrganization AS SalesOrganization
FROM P_BillingDocProcFlowC0 AS Level0
INNER JOIN I_SDDocumentProcessFlow AS Level1 ON /* join condition not captured in parsed metadata */
;

Learn More