R_SalesOrderBillingPlanItemTP

DDL: R_SALESORDERBILLINGPLANITEMTP Type: view_entity TRANSACTIONAL
38 Fields 1 Data Sources 1 Associations

Billing Plan Item for Sales Order - TP

R_SalesOrderBillingPlanItemTP is a Transactional CDS View that provides data about "Billing Plan Item for Sales Order - TP" in SAP S/4HANA. It reads from 1 data source (I_SalesOrderBillingPlanItem) and exposes 38 fields with key fields SalesOrder, BillingPlan, BillingPlanItem. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_SalesOrderBillingPlanItem SalesOrderBillingPlanItem from

Associations (1)

CardinalityTargetAliasCondition
[1..1] R_SalesOrderTP _SalesOrder $projection.SalesOrder = _SalesOrder.SalesOrder

Annotations (8)

NameValueLevelField
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Billing Plan Item for Sales Order - TP view

Fields (38)

KeyFieldSource TableSource FieldDescription
KEY SalesOrder I_SalesOrderBillingPlanItem SalesOrder SD Document
KEY BillingPlan I_SalesOrderBillingPlanItem BillingPlan Bill. Plan No.
KEY BillingPlanItem I_SalesOrderBillingPlanItem BillingPlanItem Item
BillingPlanItemForEdit I_SalesOrderBillingPlanItem BillingPlanItem Item
BillingPlanBillingDate I_SalesOrderBillingPlanItem BillingPlanBillingDate
BillingPlanServiceStartDate I_SalesOrderBillingPlanItem BillingPlanServiceStartDate
BillingPlanServiceEndDate I_SalesOrderBillingPlanItem BillingPlanServiceEndDate
BillingPlanAmount I_SalesOrderBillingPlanItem BillingPlanAmount
TransactionCurrency I_SalesOrderBillingPlanItem TransactionCurrency Transaction Currency
BillingBlockReason I_SalesOrderBillingPlanItem BillingBlockReason
BillingPlanRelatedBillgStatus I_SalesOrderBillingPlanItem BillingPlanRelatedBillgStatus
BillingPlanType I_SalesOrderBillingPlanItem BillingPlanType
BillingPlanDateCategory I_SalesOrderBillingPlanItem BillingPlanDateCategory
CustomerPaymentTerms I_SalesOrderBillingPlanItem CustomerPaymentTerms Pyt Terms
ProposedBillingDocumentType I_SalesOrderBillingPlanItem ProposedBillingDocumentType
AdoptingBillingDateID I_SalesOrderBillingPlanItem AdoptingBillingDateID
BillingPlanBillingRule I_SalesOrderBillingPlanItem BillingPlanBillingRule
BillingPlanDateDescriptionCode I_SalesOrderBillingPlanItem BillingPlanDateDescriptionCode
BillingPlanAmountPercent I_SalesOrderBillingPlanItem BillingPlanAmountPercent
BillgPlnDteCorrectionRfndType I_SalesOrderBillingPlanItem BillgPlnDteCorrectionRfndType
AccountingExchangeRate I_SalesOrderBillingPlanItem AccountingExchangeRate Exch.Rate Acct.
SalesOrderType I_SalesOrderBillingPlanItem SalesOrderType Sales Order Type
SalesOrganization I_SalesOrderBillingPlanItem SalesOrganization Sales Organization
DistributionChannel I_SalesOrderBillingPlanItem DistributionChannel RefDistCh-Cust/Mat.
OrganizationDivision I_SalesOrderBillingPlanItem OrganizationDivision Org. Division
_BillingPlan _BillingPlan
_SalesOrder _SalesOrder
_AdoptingBillingDateID I_SalesOrderBillingPlanItem _AdoptingBillingDateID
_BillgPlnDteDescCode I_SalesOrderBillingPlanItem _BillgPlnDteDescCode
_BillingBlockReason I_SalesOrderBillingPlanItem _BillingBlockReason
_BillingDocumentType I_SalesOrderBillingPlanItem _BillingDocumentType
_BillingPlanBillingRule I_SalesOrderBillingPlanItem _BillingPlanBillingRule
_BillingPlanDateCategory I_SalesOrderBillingPlanItem _BillingPlanDateCategory
_BillingPlanRelatedBillgSts I_SalesOrderBillingPlanItem _BillingPlanRelatedBillgSts
_BillingPlanType I_SalesOrderBillingPlanItem _BillingPlanType
_CustomerPaymentTerms I_SalesOrderBillingPlanItem _CustomerPaymentTerms
_TransactionCurrency I_SalesOrderBillingPlanItem _TransactionCurrency
_BillgPlnDteCrrtnRfndType I_SalesOrderBillingPlanItem _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 R_SalesOrderBillingPlanItemTP.
-- 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 R_SalesOrderBillingPlanItemTP AS
SELECT
  SalesOrderBillingPlanItem.SalesOrder AS SalesOrder,
  SalesOrderBillingPlanItem.BillingPlan AS BillingPlan,
  SalesOrderBillingPlanItem.BillingPlanItem AS BillingPlanItem,
  SalesOrderBillingPlanItem.BillingPlanItem AS BillingPlanItemForEdit,
  SalesOrderBillingPlanItem.BillingPlanBillingDate AS BillingPlanBillingDate,
  SalesOrderBillingPlanItem.BillingPlanServiceStartDate AS BillingPlanServiceStartDate,
  SalesOrderBillingPlanItem.BillingPlanServiceEndDate AS BillingPlanServiceEndDate,
  SalesOrderBillingPlanItem.BillingPlanAmount AS BillingPlanAmount,
  SalesOrderBillingPlanItem.TransactionCurrency AS TransactionCurrency,
  SalesOrderBillingPlanItem.BillingBlockReason AS BillingBlockReason,
  SalesOrderBillingPlanItem.BillingPlanRelatedBillgStatus AS BillingPlanRelatedBillgStatus,
  SalesOrderBillingPlanItem.BillingPlanType AS BillingPlanType,
  SalesOrderBillingPlanItem.BillingPlanDateCategory AS BillingPlanDateCategory,
  SalesOrderBillingPlanItem.CustomerPaymentTerms AS CustomerPaymentTerms,
  SalesOrderBillingPlanItem.ProposedBillingDocumentType AS ProposedBillingDocumentType,
  SalesOrderBillingPlanItem.AdoptingBillingDateID AS AdoptingBillingDateID,
  SalesOrderBillingPlanItem.BillingPlanBillingRule AS BillingPlanBillingRule,
  SalesOrderBillingPlanItem.BillingPlanDateDescriptionCode AS BillingPlanDateDescriptionCode,
  SalesOrderBillingPlanItem.BillingPlanAmountPercent AS BillingPlanAmountPercent,
  SalesOrderBillingPlanItem.BillgPlnDteCorrectionRfndType AS BillgPlnDteCorrectionRfndType,
  SalesOrderBillingPlanItem.AccountingExchangeRate AS AccountingExchangeRate,
  SalesOrderBillingPlanItem.SalesOrderType AS SalesOrderType,
  SalesOrderBillingPlanItem.SalesOrganization AS SalesOrganization,
  SalesOrderBillingPlanItem.DistributionChannel AS DistributionChannel,
  SalesOrderBillingPlanItem.OrganizationDivision AS OrganizationDivision,
  SalesOrderBillingPlanItem._AdoptingBillingDateID AS _AdoptingBillingDateID,
  SalesOrderBillingPlanItem._BillgPlnDteDescCode AS _BillgPlnDteDescCode,
  SalesOrderBillingPlanItem._BillingBlockReason AS _BillingBlockReason,
  SalesOrderBillingPlanItem._BillingDocumentType AS _BillingDocumentType,
  SalesOrderBillingPlanItem._BillingPlanBillingRule AS _BillingPlanBillingRule,
  SalesOrderBillingPlanItem._BillingPlanDateCategory AS _BillingPlanDateCategory,
  SalesOrderBillingPlanItem._BillingPlanRelatedBillgSts AS _BillingPlanRelatedBillgSts,
  SalesOrderBillingPlanItem._BillingPlanType AS _BillingPlanType,
  SalesOrderBillingPlanItem._CustomerPaymentTerms AS _CustomerPaymentTerms,
  SalesOrderBillingPlanItem._TransactionCurrency AS _TransactionCurrency,
  SalesOrderBillingPlanItem._BillgPlnDteCrrtnRfndType AS _BillgPlnDteCrrtnRfndType
FROM I_SalesOrderBillingPlanItem AS SalesOrderBillingPlanItem
LEFT OUTER JOIN R_SalesOrderTP AS _SalesOrder ON SalesOrder = _SalesOrder.SalesOrder  -- association [1..1]
;

Learn More