I_SalesDocumentBillingPlanItem

DDL: I_SALESDOCUMENTBILLINGPLANITEM Type: view_entity COMPOSITE
43 Fields 2 Data Sources 2 Associations

Billing Plan Item of Sales Document

I_SalesDocumentBillingPlanItem is a Composite CDS View that provides data about "Billing Plan Item of Sales Document" in SAP S/4HANA. It reads from 2 data sources (I_SalesDocument, I_SDBillingPlanItem) and exposes 43 fields with key fields SalesDocument, BillingPlanItem. It has 2 associations to related views.

Data Sources (2)

SourceAliasJoin Type
I_SalesDocument SalesDocument inner
I_SDBillingPlanItem SDBillingPlanItem from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_SalesDocument _SalesDocument _SalesDocument.SalesDocument = $projection.SalesDocument
[1..1] I_SalesDocumentBillingPlan _SalesDocumentBillingPlan _SalesDocumentBillingPlan.SalesDocument = $projection.SalesDocument

Annotations (8)

NameValueLevelField
EndUserText.label Billing Plan Item of Sales Document view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
Metadata.ignorePropagatedAnnotations true view

Fields (43)

KeyFieldSource TableSource FieldDescription
KEY SalesDocument I_SalesDocument SalesDocument SD Document
KEY BillingPlanItem I_SDBillingPlanItem BillingPlanItem Item
BillingPlan I_SDBillingPlanItem BillingPlan Bill. Plan No.
BillingPlanBillingDate I_SDBillingPlanItem BillingPlanBillingDate
BillingPlanServiceStartDate I_SDBillingPlanItem BillingPlanServiceStartDate
BillingPlanServiceEndDate I_SDBillingPlanItem BillingPlanServiceEndDate
BillingPlanAmount I_SDBillingPlanItem BillingPlanAmount
TransactionCurrency I_SDBillingPlanItem TransactionCurrency Transaction Currency
BillingBlockReason I_SDBillingPlanItem BillingBlockReason
BillingPlanRelatedBillgStatus I_SDBillingPlanItem BillingPlanRelatedBillgStatus
BillingPlanType I_SDBillingPlanItem BillingPlanType
BillingPlanDateCategory I_SDBillingPlanItem BillingPlanDateCategory
CustomerPaymentTerms I_SDBillingPlanItem CustomerPaymentTerms Pyt Terms
ProposedBillingDocumentType I_SDBillingPlanItem ProposedBillingDocumentType
AdoptingBillingDateID I_SDBillingPlanItem AdoptingBillingDateID
BillingPlanBillingRule I_SDBillingPlanItem BillingPlanBillingRule
BillingPlanDateDescriptionCode I_SDBillingPlanItem BillingPlanDateDescriptionCode
BillingPlanMilestoneUsage I_SDBillingPlanItem BillingPlanMilestoneUsage
BillingPlanAmountPercent I_SDBillingPlanItem BillingPlanAmountPercent
BillgPlnDteCorrectionRfndType I_SDBillingPlanItem BillgPlnDteCorrectionRfndType
AccountingExchangeRate I_SDBillingPlanItem AccountingExchangeRate Exch.Rate Acct.
PostponementReason I_SDBillingPlanItem PostponementReason
BillingPlanItemUsage I_SDBillingPlanItem BillingPlanItemUsage Usage
BillingPlanItemDescription I_SDBillingPlanItem BillingPlanItemDescription
SalesDocumentType _SalesDocument SalesDocumentType Sales Doc. Type
SalesOrganization _SalesDocument SalesOrganization Sales Organization
DistributionChannel _SalesDocument DistributionChannel RefDistCh-Cust/Mat.
OrganizationDivision _SalesDocument OrganizationDivision Org. Division
_SalesDocument _SalesDocument
_SalesDocumentBillingPlan _SalesDocumentBillingPlan
_TransactionCurrency I_SDBillingPlanItem _TransactionCurrency
_BillingBlockReason I_SDBillingPlanItem _BillingBlockReason
_BillingPlanRelatedBillgSts I_SDBillingPlanItem _BillingPlanRelatedBillgSts
_BillingPlanType I_SDBillingPlanItem _BillingPlanType
_BillingPlanDateCategory I_SDBillingPlanItem _BillingPlanDateCategory
_CustomerPaymentTerms I_SDBillingPlanItem _CustomerPaymentTerms
_BillingDocumentType I_SDBillingPlanItem _BillingDocumentType
_AdoptingBillingDateID I_SDBillingPlanItem _AdoptingBillingDateID
_BillingPlanBillingRule I_SDBillingPlanItem _BillingPlanBillingRule
_BillgPlnDteDescCode I_SDBillingPlanItem _BillgPlnDteDescCode
_BillingPlanMilestoneUsage I_SDBillingPlanItem _BillingPlanMilestoneUsage
_BillgPlnDteCrrtnRfndType I_SDBillingPlanItem _BillgPlnDteCrrtnRfndType
_BillgPlanItemUsage I_SDBillingPlanItem _BillgPlanItemUsage

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 I_SalesDocumentBillingPlanItem.
-- 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.

CREATE VIEW I_SalesDocumentBillingPlanItem AS
SELECT
  SalesDocument.SalesDocument AS SalesDocument,
  SDBillingPlanItem.BillingPlanItem AS BillingPlanItem,
  SDBillingPlanItem.BillingPlan AS BillingPlan,
  SDBillingPlanItem.BillingPlanBillingDate AS BillingPlanBillingDate,
  SDBillingPlanItem.BillingPlanServiceStartDate AS BillingPlanServiceStartDate,
  SDBillingPlanItem.BillingPlanServiceEndDate AS BillingPlanServiceEndDate,
  SDBillingPlanItem.BillingPlanAmount AS BillingPlanAmount,
  SDBillingPlanItem.TransactionCurrency AS TransactionCurrency,
  SDBillingPlanItem.BillingBlockReason AS BillingBlockReason,
  SDBillingPlanItem.BillingPlanRelatedBillgStatus AS BillingPlanRelatedBillgStatus,
  SDBillingPlanItem.BillingPlanType AS BillingPlanType,
  SDBillingPlanItem.BillingPlanDateCategory AS BillingPlanDateCategory,
  SDBillingPlanItem.CustomerPaymentTerms AS CustomerPaymentTerms,
  SDBillingPlanItem.ProposedBillingDocumentType AS ProposedBillingDocumentType,
  SDBillingPlanItem.AdoptingBillingDateID AS AdoptingBillingDateID,
  SDBillingPlanItem.BillingPlanBillingRule AS BillingPlanBillingRule,
  SDBillingPlanItem.BillingPlanDateDescriptionCode AS BillingPlanDateDescriptionCode,
  SDBillingPlanItem.BillingPlanMilestoneUsage AS BillingPlanMilestoneUsage,
  SDBillingPlanItem.BillingPlanAmountPercent AS BillingPlanAmountPercent,
  SDBillingPlanItem.BillgPlnDteCorrectionRfndType AS BillgPlnDteCorrectionRfndType,
  SDBillingPlanItem.AccountingExchangeRate AS AccountingExchangeRate,
  SDBillingPlanItem.PostponementReason AS PostponementReason,
  SDBillingPlanItem.BillingPlanItemUsage AS BillingPlanItemUsage,
  SDBillingPlanItem.BillingPlanItemDescription AS BillingPlanItemDescription,
  _SalesDocument.SalesDocumentType AS SalesDocumentType,
  _SalesDocument.SalesOrganization AS SalesOrganization,
  _SalesDocument.DistributionChannel AS DistributionChannel,
  _SalesDocument.OrganizationDivision AS OrganizationDivision,
  SDBillingPlanItem._TransactionCurrency AS _TransactionCurrency,
  SDBillingPlanItem._BillingBlockReason AS _BillingBlockReason,
  SDBillingPlanItem._BillingPlanRelatedBillgSts AS _BillingPlanRelatedBillgSts,
  SDBillingPlanItem._BillingPlanType AS _BillingPlanType,
  SDBillingPlanItem._BillingPlanDateCategory AS _BillingPlanDateCategory,
  SDBillingPlanItem._CustomerPaymentTerms AS _CustomerPaymentTerms,
  SDBillingPlanItem._BillingDocumentType AS _BillingDocumentType,
  SDBillingPlanItem._AdoptingBillingDateID AS _AdoptingBillingDateID,
  SDBillingPlanItem._BillingPlanBillingRule AS _BillingPlanBillingRule,
  SDBillingPlanItem._BillgPlnDteDescCode AS _BillgPlnDteDescCode,
  SDBillingPlanItem._BillingPlanMilestoneUsage AS _BillingPlanMilestoneUsage,
  SDBillingPlanItem._BillgPlnDteCrrtnRfndType AS _BillgPlnDteCrrtnRfndType,
  SDBillingPlanItem._BillgPlanItemUsage AS _BillgPlanItemUsage
FROM I_SDBillingPlanItem AS SDBillingPlanItem
INNER JOIN I_SalesDocument AS SalesDocument ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_SalesDocument AS _SalesDocument ON _SalesDocument.SalesDocument = SalesDocument  -- association [1..1]
LEFT OUTER JOIN I_SalesDocumentBillingPlan AS _SalesDocumentBillingPlan ON _SalesDocumentBillingPlan.SalesDocument = SalesDocument  -- association [1..1]
;

Learn More