I_SlsContrItemBillingPlanItem

DDL: I_SLSCONTRITEMBILLINGPLANITEM Type: view_entity COMPOSITE
42 Fields 1 Data Sources 3 Associations

Billing Plan Item of Sales Contract Item

I_SlsContrItemBillingPlanItem is a Composite CDS View that provides data about "Billing Plan Item of Sales Contract Item" in SAP S/4HANA. It reads from 1 data source (I_SalesDocItemBillingPlanItem) and exposes 42 fields with key fields SalesContract, SalesContractItem, BillingPlan, BillingPlanItem. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_SalesDocItemBillingPlanItem SalesDocItemBillingPlanItem from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_SalesContract _SalesContract _SalesContract.SalesContract = $projection.SalesContract
[1..1] I_SalesContractItem _SalesContractItem _SalesContractItem.SalesContract = $projection.SalesContract and _SalesContractItem.SalesContractItem = $projection.SalesContractItem
[1..1] I_SalesContractItemBillingPlan _SalesContractItemBillingPlan _SalesContractItemBillingPlan.SalesContract = $projection.SalesContract and _SalesContractItemBillingPlan.SalesContractItem = $projection.SalesContractItem and _SalesContractItemBillingPlan.BillingPlan = $projection.BillingPlan

Annotations (8)

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

Fields (42)

KeyFieldSource TableSource FieldDescription
KEY SalesContract SD Document
KEY SalesContractItem Sales Document Item
KEY BillingPlan I_SalesDocItemBillingPlanItem BillingPlan Bill. Plan No.
KEY BillingPlanItem I_SalesDocItemBillingPlanItem BillingPlanItem Item
BillingPlanBillingDate I_SalesDocItemBillingPlanItem BillingPlanBillingDate
BillingPlanServiceStartDate I_SalesDocItemBillingPlanItem BillingPlanServiceStartDate
BillingPlanServiceEndDate I_SalesDocItemBillingPlanItem BillingPlanServiceEndDate
BillingPlanAmount I_SalesDocItemBillingPlanItem BillingPlanAmount
TransactionCurrency I_SalesDocItemBillingPlanItem TransactionCurrency Transaction Currency
BillingBlockReason I_SalesDocItemBillingPlanItem BillingBlockReason
BillingPlanRelatedBillgStatus I_SalesDocItemBillingPlanItem BillingPlanRelatedBillgStatus
BillingPlanType I_SalesDocItemBillingPlanItem BillingPlanType
BillingPlanDateCategory I_SalesDocItemBillingPlanItem BillingPlanDateCategory
CustomerPaymentTerms I_SalesDocItemBillingPlanItem CustomerPaymentTerms Pyt Terms
ProposedBillingDocumentType I_SalesDocItemBillingPlanItem ProposedBillingDocumentType
AdoptingBillingDateID I_SalesDocItemBillingPlanItem AdoptingBillingDateID
BillingPlanBillingRule I_SalesDocItemBillingPlanItem BillingPlanBillingRule
BillingPlanDateDescriptionCode I_SalesDocItemBillingPlanItem BillingPlanDateDescriptionCode
BillingPlanMilestoneUsage I_SalesDocItemBillingPlanItem BillingPlanMilestoneUsage
BillingPlanAmountPercent I_SalesDocItemBillingPlanItem BillingPlanAmountPercent
BillgPlnDteCorrectionRfndType I_SalesDocItemBillingPlanItem BillgPlnDteCorrectionRfndType
AccountingExchangeRate I_SalesDocItemBillingPlanItem AccountingExchangeRate Exch.Rate Acct.
PostponementReason I_SalesDocItemBillingPlanItem PostponementReason
SalesContractType _SalesContract SalesContractType
SalesOrganization _SalesContract SalesOrganization Sales Organization
DistributionChannel _SalesContract DistributionChannel RefDistCh-Cust/Mat.
OrganizationDivision _SalesContract OrganizationDivision Org. Division
_SalesContract _SalesContract
_SalesContractItem _SalesContractItem
_SalesContractItemBillingPlan _SalesContractItemBillingPlan
_TransactionCurrency I_SalesDocItemBillingPlanItem _TransactionCurrency
_BillingBlockReason I_SalesDocItemBillingPlanItem _BillingBlockReason
_BillingPlanRelatedBillgSts I_SalesDocItemBillingPlanItem _BillingPlanRelatedBillgSts
_BillingPlanType I_SalesDocItemBillingPlanItem _BillingPlanType
_BillingPlanDateCategory I_SalesDocItemBillingPlanItem _BillingPlanDateCategory
_CustomerPaymentTerms I_SalesDocItemBillingPlanItem _CustomerPaymentTerms
_BillingDocumentType I_SalesDocItemBillingPlanItem _BillingDocumentType
_AdoptingBillingDateID I_SalesDocItemBillingPlanItem _AdoptingBillingDateID
_BillingPlanBillingRule I_SalesDocItemBillingPlanItem _BillingPlanBillingRule
_BillgPlnDteDescCode I_SalesDocItemBillingPlanItem _BillgPlnDteDescCode
_BillingPlanMilestoneUsage I_SalesDocItemBillingPlanItem _BillingPlanMilestoneUsage
_BillgPlnDteCrrtnRfndType I_SalesDocItemBillingPlanItem _BillgPlnDteCrrtnRfndType

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_SlsContrItemBillingPlanItem.
-- 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_SlsContrItemBillingPlanItem AS
SELECT
  cast(SalesDocument as sales_contract preserving type) AS SalesContract,
  cast(SalesDocumentItem as sales_contract_item preserving type) AS SalesContractItem,
  SalesDocItemBillingPlanItem.BillingPlan AS BillingPlan,
  SalesDocItemBillingPlanItem.BillingPlanItem AS BillingPlanItem,
  SalesDocItemBillingPlanItem.BillingPlanBillingDate AS BillingPlanBillingDate,
  SalesDocItemBillingPlanItem.BillingPlanServiceStartDate AS BillingPlanServiceStartDate,
  SalesDocItemBillingPlanItem.BillingPlanServiceEndDate AS BillingPlanServiceEndDate,
  SalesDocItemBillingPlanItem.BillingPlanAmount AS BillingPlanAmount,
  SalesDocItemBillingPlanItem.TransactionCurrency AS TransactionCurrency,
  SalesDocItemBillingPlanItem.BillingBlockReason AS BillingBlockReason,
  SalesDocItemBillingPlanItem.BillingPlanRelatedBillgStatus AS BillingPlanRelatedBillgStatus,
  SalesDocItemBillingPlanItem.BillingPlanType AS BillingPlanType,
  SalesDocItemBillingPlanItem.BillingPlanDateCategory AS BillingPlanDateCategory,
  SalesDocItemBillingPlanItem.CustomerPaymentTerms AS CustomerPaymentTerms,
  SalesDocItemBillingPlanItem.ProposedBillingDocumentType AS ProposedBillingDocumentType,
  SalesDocItemBillingPlanItem.AdoptingBillingDateID AS AdoptingBillingDateID,
  SalesDocItemBillingPlanItem.BillingPlanBillingRule AS BillingPlanBillingRule,
  SalesDocItemBillingPlanItem.BillingPlanDateDescriptionCode AS BillingPlanDateDescriptionCode,
  SalesDocItemBillingPlanItem.BillingPlanMilestoneUsage AS BillingPlanMilestoneUsage,
  SalesDocItemBillingPlanItem.BillingPlanAmountPercent AS BillingPlanAmountPercent,
  SalesDocItemBillingPlanItem.BillgPlnDteCorrectionRfndType AS BillgPlnDteCorrectionRfndType,
  SalesDocItemBillingPlanItem.AccountingExchangeRate AS AccountingExchangeRate,
  SalesDocItemBillingPlanItem.PostponementReason AS PostponementReason,
  _SalesContract.SalesContractType AS SalesContractType,
  _SalesContract.SalesOrganization AS SalesOrganization,
  _SalesContract.DistributionChannel AS DistributionChannel,
  _SalesContract.OrganizationDivision AS OrganizationDivision,
  SalesDocItemBillingPlanItem._TransactionCurrency AS _TransactionCurrency,
  SalesDocItemBillingPlanItem._BillingBlockReason AS _BillingBlockReason,
  SalesDocItemBillingPlanItem._BillingPlanRelatedBillgSts AS _BillingPlanRelatedBillgSts,
  SalesDocItemBillingPlanItem._BillingPlanType AS _BillingPlanType,
  SalesDocItemBillingPlanItem._BillingPlanDateCategory AS _BillingPlanDateCategory,
  SalesDocItemBillingPlanItem._CustomerPaymentTerms AS _CustomerPaymentTerms,
  SalesDocItemBillingPlanItem._BillingDocumentType AS _BillingDocumentType,
  SalesDocItemBillingPlanItem._AdoptingBillingDateID AS _AdoptingBillingDateID,
  SalesDocItemBillingPlanItem._BillingPlanBillingRule AS _BillingPlanBillingRule,
  SalesDocItemBillingPlanItem._BillgPlnDteDescCode AS _BillgPlnDteDescCode,
  SalesDocItemBillingPlanItem._BillingPlanMilestoneUsage AS _BillingPlanMilestoneUsage,
  SalesDocItemBillingPlanItem._BillgPlnDteCrrtnRfndType AS _BillgPlnDteCrrtnRfndType
FROM I_SalesDocItemBillingPlanItem AS SalesDocItemBillingPlanItem
LEFT OUTER JOIN I_SalesContract AS _SalesContract ON _SalesContract.SalesContract = SalesContract  -- association [1..1]
LEFT OUTER JOIN I_SalesContractItem AS _SalesContractItem ON _SalesContractItem.SalesContract = SalesContract AND _SalesContractItem.SalesContractItem = SalesContractItem  -- association [1..1]
LEFT OUTER JOIN I_SalesContractItemBillingPlan AS _SalesContractItemBillingPlan ON _SalesContractItemBillingPlan.SalesContract = SalesContract AND _SalesContractItemBillingPlan.SalesContractItem = SalesContractItem AND _SalesContractItemBillingPlan.BillingPlan = BillingPlan  -- association [1..1]
;

Learn More