P_SlsDocFlfmtProcHierarchyD31

DDL: P_SLSDOCFLFMTPROCHIERARCHYD31 SQL: PSOFTREED31 Type: view CONSUMPTION
21 Fields 4 Data Sources

P_SlsDocFlfmtProcHierarchyD31 is a Consumption CDS View in SAP S/4HANA. It reads from 4 data sources (P_SDDocumentPurchOrdProcFlow, I_PurOrdAccountAssignment, I_PurchaseOrderItem, R_PurchaseOrderItem) and exposes 21 fields with key fields PurchaseOrder, PurchaseOrderItem, SalesOrder, PurchaseOrderItem, SalesOrder.

Data Sources (4)

SourceAliasJoin Type
P_SDDocumentPurchOrdProcFlow PO_Link union_all
I_PurOrdAccountAssignment POAccountAss from
I_PurchaseOrderItem POI inner
R_PurchaseOrderItem PurchaseOrderItem inner

Annotations (8)

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

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder I_PurOrdAccountAssignment PurchaseOrder Purchasing Document
KEY PurchaseOrderItem I_PurOrdAccountAssignment PurchaseOrderItem Purchasing Document Item
KEY SalesOrder I_PurOrdAccountAssignment SalesOrder SD Document
SalesOrderItem I_PurOrdAccountAssignment SalesOrderItem Sales Order Item
PurchaseOrderType
GoodsReceiptIsExpected Goods Receipt
IsCompletelyDelivered Is completely delivered
InvoiceIsExpected Invoice Receipt
IsFinallyInvoiced Final Invoice
DocumentCurrency Document Currency
NetAmount Stated Amount
KEY PurchaseOrderItem Purchasing Document Item
KEY SalesOrder SD Document
SalesOrderItem Sales Order Item
PurchaseOrderType
GoodsReceiptIsExpected I_PurchaseOrderItem GoodsReceiptIsExpected Goods Receipt
IsCompletelyDelivered I_PurchaseOrderItem IsCompletelyDelivered Is completely delivered
InvoiceIsExpected I_PurchaseOrderItem InvoiceIsExpected Invoice Receipt
IsFinallyInvoiced I_PurchaseOrderItem IsFinallyInvoiced Final Invoice
DocumentCurrency I_PurchaseOrderItem DocumentCurrency Document Currency
NetAmount I_PurchaseOrderItem NetAmount Stated Amount

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_SlsDocFlfmtProcHierarchyD31.
-- 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: PSOFTREED31

CREATE VIEW P_SlsDocFlfmtProcHierarchyD31 AS
SELECT
  POAccountAss.PurchaseOrder AS PurchaseOrder,
  POAccountAss.PurchaseOrderItem AS PurchaseOrderItem,
  POAccountAss.SalesOrder AS SalesOrder,
  POAccountAss.SalesOrderItem AS SalesOrderItem,
  POAccountAss._PurchaseOrder.PurchaseOrderType AS PurchaseOrderType,
  POAccountAss._PurchaseOrderItem.GoodsReceiptIsExpected AS GoodsReceiptIsExpected,
  POAccountAss._PurchaseOrderItem.IsCompletelyDelivered AS IsCompletelyDelivered,
  POAccountAss._PurchaseOrderItem.InvoiceIsExpected AS InvoiceIsExpected,
  POAccountAss._PurchaseOrderItem.IsFinallyInvoiced AS IsFinallyInvoiced,
  POAccountAss._PurchaseOrderItem.DocumentCurrency AS DocumentCurrency,
  POAccountAss._PurchaseOrderItem.NetAmount AS NetAmount
FROM I_PurOrdAccountAssignment AS POAccountAss
INNER JOIN R_PurchaseOrderItem AS PurchaseOrderItem ON /* join condition not captured in parsed metadata */
INNER JOIN I_PurchaseOrderItem AS POI ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): P_SDDocumentPurchOrdProcFlow
;

Learn More