I_SlsOrderItemBillingPlanItem

DDL: I_SLSORDERITEMBILLINGPLANITEM Type: view_entity COMPOSITE
45 Fields 1 Data Sources 3 Associations

Billing Plan Item of Sales Order Item

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

SAP Help Documentation

CategorySales Orders
Purpose
This CDS view provides the prerequisites for answering questions about the billing plan item of a sales order billing plan at item level. Example business questions could include: Which amount is billed when? Is the item blocked for billing? Which billing rule is applied to this item? To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Prerequisites
Authorizations You have authorizations to access the relevant sales order types. You have authorizations to access the relevant sales areas.

Structure
Further important fields Important fields in this view include the following: Field Name Description BillingPlanBillingRule Specifies for each billing plan date how the value to be billed is determined BillingPlanAmount Specifies the value to be billed which the system determines for the billing date on the basis of the billing rule assigned to it BillingPlanType Controls which fields are offered for processing. It also specifies how billing is performed for the billing dates in a billing plan of this type.

View on SAP Help Portal →

Data Sources (1)

SourceAliasJoin Type
I_SalesDocItemBillingPlanItem SalesDocItemBillingPlanItem from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_SalesOrder _SalesOrder _SalesOrder.SalesOrder = $projection.SalesOrder
[1..1] I_SalesOrderItem _SalesOrderItem _SalesOrderItem.SalesOrder = $projection.SalesOrder and _SalesOrderItem.SalesOrderItem = $projection.SalesOrderItem
[1..1] I_SalesOrderItemBillingPlan _SalesOrderItemBillingPlan _SalesOrderItemBillingPlan.SalesOrder = $projection.SalesOrder and _SalesOrderItemBillingPlan.SalesOrderItem = $projection.SalesOrderItem and _SalesOrderItemBillingPlan.BillingPlan = $projection.BillingPlan

Annotations (8)

NameValueLevelField
EndUserText.label Billing Plan Item of Sales Order Item 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 (45)

KeyFieldSource TableSource FieldDescription
KEY SalesOrder SD Document
KEY SalesOrderItem 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
BillingPlanItemUsage I_SalesDocItemBillingPlanItem BillingPlanItemUsage Usage
BillingPlanItemDescription I_SalesDocItemBillingPlanItem BillingPlanItemDescription
SalesOrderType _SalesOrder SalesOrderType Sales Order Type
SalesOrganization _SalesOrder SalesOrganization Sales Organization
DistributionChannel _SalesOrder DistributionChannel RefDistCh-Cust/Mat.
OrganizationDivision _SalesOrder OrganizationDivision Org. Division
_SalesOrder _SalesOrder
_SalesOrderItem _SalesOrderItem
_SalesOrderItemBillingPlan _SalesOrderItemBillingPlan
_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
_BillgPlanItemUsage I_SalesDocItemBillingPlanItem _BillgPlanItemUsage
_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_SlsOrderItemBillingPlanItem.
-- 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_SlsOrderItemBillingPlanItem AS
SELECT
  cast(SalesDocument as vdm_sales_order preserving type) AS SalesOrder,
  cast(SalesDocumentItem as sales_order_item preserving type) AS SalesOrderItem,
  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,
  SalesDocItemBillingPlanItem.BillingPlanItemUsage AS BillingPlanItemUsage,
  SalesDocItemBillingPlanItem.BillingPlanItemDescription AS BillingPlanItemDescription,
  _SalesOrder.SalesOrderType AS SalesOrderType,
  _SalesOrder.SalesOrganization AS SalesOrganization,
  _SalesOrder.DistributionChannel AS DistributionChannel,
  _SalesOrder.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._BillgPlanItemUsage AS _BillgPlanItemUsage,
  SalesDocItemBillingPlanItem._BillgPlnDteCrrtnRfndType AS _BillgPlnDteCrrtnRfndType
FROM I_SalesDocItemBillingPlanItem AS SalesDocItemBillingPlanItem
LEFT OUTER JOIN I_SalesOrder AS _SalesOrder ON _SalesOrder.SalesOrder = SalesOrder  -- association [1..1]
LEFT OUTER JOIN I_SalesOrderItem AS _SalesOrderItem ON _SalesOrderItem.SalesOrder = SalesOrder AND _SalesOrderItem.SalesOrderItem = SalesOrderItem  -- association [1..1]
LEFT OUTER JOIN I_SalesOrderItemBillingPlan AS _SalesOrderItemBillingPlan ON _SalesOrderItemBillingPlan.SalesOrder = SalesOrder AND _SalesOrderItemBillingPlan.SalesOrderItem = SalesOrderItem AND _SalesOrderItemBillingPlan.BillingPlan = BillingPlan  -- association [1..1]
;

Learn More