A_SalesOrderBillingPlanItem

DDL: A_SALESORDERBILLINGPLANITEM Type: view_entity COMPOSITE
28 Fields 1 Data Sources 2 Associations

Header Billing Plan Item

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

Data Sources (1)

SourceAliasJoin Type
I_SalesOrderBillingPlanItem SalesOrderBillingPlanItem from

Associations (2)

CardinalityTargetAliasCondition
[1..1] A_SalesOrder _SalesOrder _SalesOrder.SalesOrder = $projection.SalesOrder
[1..1] A_SalesOrderBillingPlan _BillingPlan _BillingPlan.SalesOrder = $projection.SalesOrder and _BillingPlan.BillingPlan = $projection.BillingPlan

Annotations (12)

NameValueLevelField
EndUserText.label Header 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_SalesOrderBillingPlanItem view

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY SalesOrder I_SalesOrderBillingPlanItem SalesOrder SD Document
KEY BillingPlan I_SalesOrderBillingPlanItem BillingPlan Bill. Plan No.
KEY BillingPlanItem I_SalesOrderBillingPlanItem BillingPlanItem Item
BillingPlanDateCategory I_SalesOrderBillingPlanItem BillingPlanDateCategory
BillingPlanBillingDate I_SalesOrderBillingPlanItem BillingPlanBillingDate
BillingPlanAmount I_SalesOrderBillingPlanItem BillingPlanAmount
TransactionCurrency I_SalesOrderBillingPlanItem TransactionCurrency Transaction Currency
BillingPlanAmountPercent I_SalesOrderBillingPlanItem BillingPlanAmountPercent
CustomerPaymentTerms I_SalesOrderBillingPlanItem CustomerPaymentTerms Pyt Terms
ProposedBillingDocumentType I_SalesOrderBillingPlanItem ProposedBillingDocumentType
BillingPlanDateDescriptionCode I_SalesOrderBillingPlanItem BillingPlanDateDescriptionCode
BillingBlockReason I_SalesOrderBillingPlanItem BillingBlockReason
BillingPlanServiceStartDate I_SalesOrderBillingPlanItem BillingPlanServiceStartDate
BillingPlanServiceEndDate I_SalesOrderBillingPlanItem BillingPlanServiceEndDate
BillingPlanRelatedBillgStatus I_SalesOrderBillingPlanItem BillingPlanRelatedBillgStatus
BillingPlanType I_SalesOrderBillingPlanItem BillingPlanType
AdoptingBillingDateID I_SalesOrderBillingPlanItem AdoptingBillingDateID
BillingPlanBillingRule I_SalesOrderBillingPlanItem BillingPlanBillingRule
BillingPlanMilestoneUsage I_SalesOrderBillingPlanItem BillingPlanMilestoneUsage
BillgPlnDteCorrectionRfndType I_SalesOrderBillingPlanItem BillgPlnDteCorrectionRfndType
AccountingExchangeRate I_SalesOrderBillingPlanItem AccountingExchangeRate Exch.Rate Acct.
PostponementReason I_SalesOrderBillingPlanItem 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
_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_SalesOrderBillingPlanItem.
-- 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_SalesOrderBillingPlanItem AS
SELECT
  SalesOrderBillingPlanItem.SalesOrder AS SalesOrder,
  SalesOrderBillingPlanItem.BillingPlan AS BillingPlan,
  SalesOrderBillingPlanItem.BillingPlanItem AS BillingPlanItem,
  SalesOrderBillingPlanItem.BillingPlanDateCategory AS BillingPlanDateCategory,
  SalesOrderBillingPlanItem.BillingPlanBillingDate AS BillingPlanBillingDate,
  SalesOrderBillingPlanItem.BillingPlanAmount AS BillingPlanAmount,
  SalesOrderBillingPlanItem.TransactionCurrency AS TransactionCurrency,
  SalesOrderBillingPlanItem.BillingPlanAmountPercent AS BillingPlanAmountPercent,
  SalesOrderBillingPlanItem.CustomerPaymentTerms AS CustomerPaymentTerms,
  SalesOrderBillingPlanItem.ProposedBillingDocumentType AS ProposedBillingDocumentType,
  SalesOrderBillingPlanItem.BillingPlanDateDescriptionCode AS BillingPlanDateDescriptionCode,
  SalesOrderBillingPlanItem.BillingBlockReason AS BillingBlockReason,
  SalesOrderBillingPlanItem.BillingPlanServiceStartDate AS BillingPlanServiceStartDate,
  SalesOrderBillingPlanItem.BillingPlanServiceEndDate AS BillingPlanServiceEndDate,
  SalesOrderBillingPlanItem.BillingPlanRelatedBillgStatus AS BillingPlanRelatedBillgStatus,
  SalesOrderBillingPlanItem.BillingPlanType AS BillingPlanType,
  SalesOrderBillingPlanItem.AdoptingBillingDateID AS AdoptingBillingDateID,
  SalesOrderBillingPlanItem.BillingPlanBillingRule AS BillingPlanBillingRule,
  SalesOrderBillingPlanItem.BillingPlanMilestoneUsage AS BillingPlanMilestoneUsage,
  SalesOrderBillingPlanItem.BillgPlnDteCorrectionRfndType AS BillgPlnDteCorrectionRfndType,
  SalesOrderBillingPlanItem.AccountingExchangeRate AS AccountingExchangeRate,
  SalesOrderBillingPlanItem.PostponementReason AS PostponementReason,
  _SalesOrder.SalesOrderType AS SalesOrderType,
  _SalesOrder.SalesOrganization AS SalesOrganization,
  _SalesOrder.DistributionChannel AS DistributionChannel,
  _SalesOrder.OrganizationDivision AS OrganizationDivision
FROM I_SalesOrderBillingPlanItem AS SalesOrderBillingPlanItem
LEFT OUTER JOIN A_SalesOrder AS _SalesOrder ON _SalesOrder.SalesOrder = SalesOrder  -- association [1..1]
LEFT OUTER JOIN A_SalesOrderBillingPlan AS _BillingPlan ON _BillingPlan.SalesOrder = SalesOrder AND _BillingPlan.BillingPlan = BillingPlan  -- association [1..1]
;

Learn More