P_SlsOrdItmDelivdDueDte

DDL: P_SLSORDITMDELIVDDUEDTE SQL: PSODUEDATEREUS4 Type: view COMPOSITE
16 Fields 3 Data Sources

P_SlsOrdItmDelivdDueDte is a Composite CDS View in SAP S/4HANA. It reads from 3 data sources (I_DeliveryDocument, I_DeliveryDocumentItem, I_SalesDocumentItemBasic) and exposes 16 fields with key fields SalesDocument, SalesDocumentItem.

Data Sources (3)

SourceAliasJoin Type
I_DeliveryDocument DDH inner
I_DeliveryDocumentItem DDI inner
I_SalesDocumentItemBasic SOI from

Annotations (8)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #S view
VDM.private true view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName PSODUEDATEREUS4 view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY SalesDocument I_SalesDocumentItemBasic SalesDocument SD Document
KEY SalesDocumentItem I_SalesDocumentItemBasic SalesDocumentItem Sales Document Item
SalesOrganization
DistributionChannel
OrganizationDivision
SalesDocumentType
DueDate
ItemBillingBlockReason I_SalesDocumentItemBasic ItemBillingBlockReason Billing Block
TotalDeliveryStatus
OverallOrdReltdBillgStatus
neededforBillingBlock
ItemGeneralIncompletionStatus
ItemBillingIncompletionStatus
PricingIncompletionStatus
ItemDeliveryIncompletionStatus
BusinessTransactionType

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_SlsOrdItmDelivdDueDte.
-- 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: PSODUEDATEREUS4

CREATE VIEW P_SlsOrdItmDelivdDueDte AS
SELECT
  SOI.SalesDocument AS SalesDocument,
  SOI.SalesDocumentItem AS SalesDocumentItem,
  SOI._SalesDocumentBasic.SalesOrganization AS SalesOrganization,
  SOI._SalesDocumentBasic.DistributionChannel AS DistributionChannel,
  SOI._SalesDocumentBasic.OrganizationDivision AS OrganizationDivision,
  SOI._SalesDocumentBasic.SalesDocumentType AS SalesDocumentType,
  min( DDH.BillingDocumentDate) AS DueDate,
  SOI.ItemBillingBlockReason AS ItemBillingBlockReason,
  Incompletion SOI.ItemGeneralIncompletionStatus AS ItemGeneralIncompletionStatus
FROM I_SalesDocumentItemBasic AS SOI
INNER JOIN I_DeliveryDocumentItem AS DDI ON /* join condition not captured in parsed metadata */
INNER JOIN I_DeliveryDocument AS DDH ON /* join condition not captured in parsed metadata */
;

Learn More