P_SlsOrdBillingPlanDueDate

DDL: P_SLSORDBILLINGPLANDUEDATE SQL: PSODUEDATEREUS10 Type: view COMPOSITE Package: VDM_SD_SOF_OLD
18 Fields 3 Data Sources

SOFM Due Date Calc. For Sales Orders With Billing Plan

P_SlsOrdBillingPlanDueDate is a Composite CDS View that provides data about "SOFM Due Date Calc. For Sales Orders With Billing Plan" in SAP S/4HANA. It reads from 3 data sources (I_SalesDocItemBillingPlanItem, I_SalesDocumentBasic, I_SalesDocumentItem) and exposes 18 fields with key field SalesDocument. Part of development package VDM_SD_SOF_OLD.

Data Sources (3)

SourceAliasJoin Type
I_SalesDocItemBillingPlanItem fplt inner
I_SalesDocumentBasic SOH from
I_SalesDocumentItem SOI inner

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 PSODUEDATEREUS10 view

Fields (18)

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
DueDate
HeaderBillingBlockReason I_SalesDocumentBasic HeaderBillingBlockReason Billing Block
OverallTotalDeliveryStatus
OverallSDProcessStatus
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_SlsOrdBillingPlanDueDate.
-- 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: PSODUEDATEREUS10

CREATE VIEW P_SlsOrdBillingPlanDueDate AS
SELECT
  SOH.SalesDocument AS SalesDocument,
  SOH.SalesOrganization AS SalesOrganization,
  SOH.DistributionChannel AS DistributionChannel,
  SOH.OrganizationDivision AS OrganizationDivision,
  SOH.SalesDocumentType AS SalesDocumentType,
  min( fplt.BillingPlanBillingDate ) AS DueDate,
  SOH.HeaderBillingBlockReason AS HeaderBillingBlockReason,
  BillingBlock SOH.OverallOrdReltdBillgStatus AS OverallOrdReltdBillgStatus,
  Incompletion SOH.HdrGeneralIncompletionStatus AS HdrGeneralIncompletionStatus,
  COS.BusinessTransactionType AS BusinessTransactionType
FROM I_SalesDocumentBasic AS SOH
INNER JOIN I_SalesDocumentItem AS SOI ON /* join condition not captured in parsed metadata */
INNER JOIN I_SalesDocItemBillingPlanItem AS fplt ON /* join condition not captured in parsed metadata */
;

Learn More