P_SlsOrdNotDelivdDueDte

DDL: P_SLSORDNOTDELIVDDUEDTE SQL: PSODUEDATEREUSE1 Type: view COMPOSITE
19 Fields 1 Data Sources

P_SlsOrdNotDelivdDueDte is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_SalesDocumentBasic) and exposes 19 fields with key field SalesDocument.

Data Sources (1)

SourceAliasJoin Type
I_SalesDocumentBasic SOH 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 PSODUEDATEREUSE1 view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY SalesDocument I_SalesDocumentBasic SalesDocument SD Document
SalesOrganization I_SalesDocumentBasic SalesOrganization Sales Organization
DistributionChannel I_SalesDocumentBasic DistributionChannel RefDistCh-Cust/Mat.
OrganizationDivision I_SalesDocumentBasic OrganizationDivision Org. Division
SalesDocumentType I_SalesDocumentBasic SalesDocumentType Sales Doc. Type
RequestedDeliveryDateendendasDueDate
OverallBillingBlockStatus I_SalesDocumentBasic OverallBillingBlockStatus
DeliveryBlockReason
HeaderBillingBlockReason
OverallTotalDeliveryStatus
neededforDeliveryBlock
OverallOrdReltdBillgStatus
neededforBillingBlock
HdrGeneralIncompletionStatus
OverallPricingIncompletionSts
HeaderDelivIncompletionStatus
HeaderBillgIncompletionStatus
TotalCreditCheckStatus
BusinessTransactionType COS BusinessTransactionType Bus.transaction

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_SlsOrdNotDelivdDueDte.
-- 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: PSODUEDATEREUSE1

CREATE VIEW P_SlsOrdNotDelivdDueDte AS
SELECT
  SOH.SalesDocument AS SalesDocument,
  SOH.SalesOrganization AS SalesOrganization,
  SOH.DistributionChannel AS DistributionChannel,
  SOH.OrganizationDivision AS OrganizationDivision,
  SOH.SalesDocumentType AS SalesDocumentType,
  min( case when ConfirmedSL.DeliveryCreationDate > '00000000' then ConfirmedSL.DeliveryCreationDate else case when RequestedSL.DeliveryCreationDate > '00000000' then RequestedSL.DeliveryCreationDate else SOH.RequestedDeliveryDate end end ) as DueDate AS RequestedDeliveryDateendendasDueDate,
  SOH.OverallBillingBlockStatus AS OverallBillingBlockStatus,
  BillingBlock SOH.OverallOrdReltdBillgStatus AS OverallOrdReltdBillgStatus,
  Incompletion SOH.HdrGeneralIncompletionStatus AS HdrGeneralIncompletionStatus,
  COS.BusinessTransactionType AS BusinessTransactionType
FROM I_SalesDocumentBasic AS SOH
;

Learn More