A_SlsOrderItemBillingPlanItem

DDL: A_SLSORDERITEMBILLINGPLANITEM Type: view_entity COMPOSITE
30 Fields 1 Data Sources 3 Associations

Item Billing Plan Item

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

Data Sources (1)

SourceAliasJoin Type
I_SlsOrderItemBillingPlanItem SlsOrderItemBillingPlanItem from

Associations (3)

CardinalityTargetAliasCondition
[1..1] A_SalesOrder _SalesOrder _SalesOrder.SalesOrder = $projection.SalesOrder
[1..1] A_SalesOrderItem _SalesOrderItem _SalesOrderItem.SalesOrder = $projection.SalesOrder and _SalesOrderItem.SalesOrderItem = $projection.SalesOrderItem
[1..1] A_SalesOrderItemBillingPlan _BillingPlan _BillingPlan.SalesOrder = $projection.SalesOrder and _BillingPlan.SalesOrderItem = $projection.SalesOrderItem and _BillingPlan.BillingPlan = $projection.BillingPlan

Annotations (12)

NameValueLevelField
EndUserText.label Item Billing Plan Item view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
AccessControl.authorizationCheck #CHECK view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
Metadata.ignorePropagatedAnnotations true view
OData.entitySet.name A_SlsOrderItemBillingPlanItem view

Fields (30)

KeyFieldSource TableSource FieldDescription
KEY SalesOrder I_SlsOrderItemBillingPlanItem SalesOrder SD Document
KEY SalesOrderItem I_SlsOrderItemBillingPlanItem SalesOrderItem Sales Order Item
KEY BillingPlan I_SlsOrderItemBillingPlanItem BillingPlan Bill. Plan No.
KEY BillingPlanItem I_SlsOrderItemBillingPlanItem BillingPlanItem Item
BillingPlanDateCategory I_SlsOrderItemBillingPlanItem BillingPlanDateCategory
BillingPlanBillingDate I_SlsOrderItemBillingPlanItem BillingPlanBillingDate
BillingPlanAmount I_SlsOrderItemBillingPlanItem BillingPlanAmount
TransactionCurrency I_SlsOrderItemBillingPlanItem TransactionCurrency Transaction Currency
BillingPlanAmountPercent I_SlsOrderItemBillingPlanItem BillingPlanAmountPercent
CustomerPaymentTerms I_SlsOrderItemBillingPlanItem CustomerPaymentTerms Pyt Terms
ProposedBillingDocumentType I_SlsOrderItemBillingPlanItem ProposedBillingDocumentType
BillingPlanDateDescriptionCode I_SlsOrderItemBillingPlanItem BillingPlanDateDescriptionCode
BillingBlockReason I_SlsOrderItemBillingPlanItem BillingBlockReason
BillingPlanServiceStartDate I_SlsOrderItemBillingPlanItem BillingPlanServiceStartDate
BillingPlanServiceEndDate I_SlsOrderItemBillingPlanItem BillingPlanServiceEndDate
BillingPlanRelatedBillgStatus I_SlsOrderItemBillingPlanItem BillingPlanRelatedBillgStatus
BillingPlanType I_SlsOrderItemBillingPlanItem BillingPlanType
AdoptingBillingDateID I_SlsOrderItemBillingPlanItem AdoptingBillingDateID
BillingPlanBillingRule I_SlsOrderItemBillingPlanItem BillingPlanBillingRule
BillingPlanMilestoneUsage I_SlsOrderItemBillingPlanItem BillingPlanMilestoneUsage
BillgPlnDteCorrectionRfndType I_SlsOrderItemBillingPlanItem BillgPlnDteCorrectionRfndType
AccountingExchangeRate I_SlsOrderItemBillingPlanItem AccountingExchangeRate Exch.Rate Acct.
PostponementReason I_SlsOrderItemBillingPlanItem PostponementReason
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
_BillingPlan _BillingPlan

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 A_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 A_SlsOrderItemBillingPlanItem AS
SELECT
  SlsOrderItemBillingPlanItem.SalesOrder AS SalesOrder,
  SlsOrderItemBillingPlanItem.SalesOrderItem AS SalesOrderItem,
  SlsOrderItemBillingPlanItem.BillingPlan AS BillingPlan,
  SlsOrderItemBillingPlanItem.BillingPlanItem AS BillingPlanItem,
  SlsOrderItemBillingPlanItem.BillingPlanDateCategory AS BillingPlanDateCategory,
  SlsOrderItemBillingPlanItem.BillingPlanBillingDate AS BillingPlanBillingDate,
  SlsOrderItemBillingPlanItem.BillingPlanAmount AS BillingPlanAmount,
  SlsOrderItemBillingPlanItem.TransactionCurrency AS TransactionCurrency,
  SlsOrderItemBillingPlanItem.BillingPlanAmountPercent AS BillingPlanAmountPercent,
  SlsOrderItemBillingPlanItem.CustomerPaymentTerms AS CustomerPaymentTerms,
  SlsOrderItemBillingPlanItem.ProposedBillingDocumentType AS ProposedBillingDocumentType,
  SlsOrderItemBillingPlanItem.BillingPlanDateDescriptionCode AS BillingPlanDateDescriptionCode,
  SlsOrderItemBillingPlanItem.BillingBlockReason AS BillingBlockReason,
  SlsOrderItemBillingPlanItem.BillingPlanServiceStartDate AS BillingPlanServiceStartDate,
  SlsOrderItemBillingPlanItem.BillingPlanServiceEndDate AS BillingPlanServiceEndDate,
  SlsOrderItemBillingPlanItem.BillingPlanRelatedBillgStatus AS BillingPlanRelatedBillgStatus,
  SlsOrderItemBillingPlanItem.BillingPlanType AS BillingPlanType,
  SlsOrderItemBillingPlanItem.AdoptingBillingDateID AS AdoptingBillingDateID,
  SlsOrderItemBillingPlanItem.BillingPlanBillingRule AS BillingPlanBillingRule,
  SlsOrderItemBillingPlanItem.BillingPlanMilestoneUsage AS BillingPlanMilestoneUsage,
  SlsOrderItemBillingPlanItem.BillgPlnDteCorrectionRfndType AS BillgPlnDteCorrectionRfndType,
  SlsOrderItemBillingPlanItem.AccountingExchangeRate AS AccountingExchangeRate,
  SlsOrderItemBillingPlanItem.PostponementReason AS PostponementReason,
  _SalesOrder.SalesOrderType AS SalesOrderType,
  _SalesOrder.SalesOrganization AS SalesOrganization,
  _SalesOrder.DistributionChannel AS DistributionChannel,
  _SalesOrder.OrganizationDivision AS OrganizationDivision
FROM I_SlsOrderItemBillingPlanItem AS SlsOrderItemBillingPlanItem
LEFT OUTER JOIN A_SalesOrder AS _SalesOrder ON _SalesOrder.SalesOrder = SalesOrder  -- association [1..1]
LEFT OUTER JOIN A_SalesOrderItem AS _SalesOrderItem ON _SalesOrderItem.SalesOrder = SalesOrder AND _SalesOrderItem.SalesOrderItem = SalesOrderItem  -- association [1..1]
LEFT OUTER JOIN A_SalesOrderItemBillingPlan AS _BillingPlan ON _BillingPlan.SalesOrder = SalesOrder AND _BillingPlan.SalesOrderItem = SalesOrderItem AND _BillingPlan.BillingPlan = BillingPlan  -- association [1..1]
;

Learn More