R_SlsContrItmBillingPlanItemTP

DDL: R_SLSCONTRITMBILLINGPLANITEMTP Type: view_entity TRANSACTIONAL
42 Fields 1 Data Sources 2 Associations

Billing Plan Item for Sls Contr Item - TP

R_SlsContrItmBillingPlanItemTP is a Transactional CDS View that provides data about "Billing Plan Item for Sls Contr Item - TP" in SAP S/4HANA. It reads from 1 data source (I_SlsContrItemBillingPlanItem) and exposes 42 fields with key fields SalesContract, SalesContractItem, BillingPlan, BillingPlanItem. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_SlsContrItemBillingPlanItem SlsContrItemBillingPlanItem from

Associations (2)

CardinalityTargetAliasCondition
[1..1] R_SalesContractTP _SalesContract $projection.SalesContract = _SalesContract.SalesContract
[1..1] R_SalesContractItemTP _Item $projection.SalesContract = _Item.SalesContract and $projection.SalesContractItem = _Item.SalesContractItem

Annotations (8)

NameValueLevelField
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view
AccessControl.authorizationCheck #MANDATORY 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 Sls Contr Item - TP view

Fields (42)

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

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_SlsContrItmBillingPlanItemTP.
-- 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_SlsContrItmBillingPlanItemTP AS
SELECT
  SlsContrItemBillingPlanItem.SalesContract AS SalesContract,
  SlsContrItemBillingPlanItem.SalesContractItem AS SalesContractItem,
  SlsContrItemBillingPlanItem.BillingPlan AS BillingPlan,
  SlsContrItemBillingPlanItem.BillingPlanItem AS BillingPlanItem,
  SlsContrItemBillingPlanItem.BillingPlanItem AS BillingPlanItemForEdit,
  SlsContrItemBillingPlanItem.BillingPlanBillingDate AS BillingPlanBillingDate,
  SlsContrItemBillingPlanItem.BillingPlanServiceStartDate AS BillingPlanServiceStartDate,
  SlsContrItemBillingPlanItem.BillingPlanServiceEndDate AS BillingPlanServiceEndDate,
  SlsContrItemBillingPlanItem.BillingPlanAmount AS BillingPlanAmount,
  SlsContrItemBillingPlanItem.TransactionCurrency AS TransactionCurrency,
  SlsContrItemBillingPlanItem.BillingBlockReason AS BillingBlockReason,
  SlsContrItemBillingPlanItem.BillingPlanRelatedBillgStatus AS BillingPlanRelatedBillgStatus,
  SlsContrItemBillingPlanItem.BillingPlanType AS BillingPlanType,
  SlsContrItemBillingPlanItem.BillingPlanDateCategory AS BillingPlanDateCategory,
  SlsContrItemBillingPlanItem.CustomerPaymentTerms AS CustomerPaymentTerms,
  SlsContrItemBillingPlanItem.ProposedBillingDocumentType AS ProposedBillingDocumentType,
  SlsContrItemBillingPlanItem.AdoptingBillingDateID AS AdoptingBillingDateID,
  SlsContrItemBillingPlanItem.BillingPlanBillingRule AS BillingPlanBillingRule,
  SlsContrItemBillingPlanItem.BillingPlanDateDescriptionCode AS BillingPlanDateDescriptionCode,
  SlsContrItemBillingPlanItem.BillingPlanMilestoneUsage AS BillingPlanMilestoneUsage,
  SlsContrItemBillingPlanItem.BillingPlanAmountPercent AS BillingPlanAmountPercent,
  SlsContrItemBillingPlanItem.BillgPlnDteCorrectionRfndType AS BillgPlnDteCorrectionRfndType,
  SlsContrItemBillingPlanItem.AccountingExchangeRate AS AccountingExchangeRate,
  SlsContrItemBillingPlanItem.SalesContractType AS SalesContractType,
  SlsContrItemBillingPlanItem.SalesOrganization AS SalesOrganization,
  SlsContrItemBillingPlanItem.DistributionChannel AS DistributionChannel,
  SlsContrItemBillingPlanItem.OrganizationDivision AS OrganizationDivision,
  SlsContrItemBillingPlanItem._AdoptingBillingDateID AS _AdoptingBillingDateID,
  SlsContrItemBillingPlanItem._BillgPlnDteDescCode AS _BillgPlnDteDescCode,
  SlsContrItemBillingPlanItem._BillingBlockReason AS _BillingBlockReason,
  SlsContrItemBillingPlanItem._BillingDocumentType AS _BillingDocumentType,
  SlsContrItemBillingPlanItem._BillingPlanBillingRule AS _BillingPlanBillingRule,
  SlsContrItemBillingPlanItem._BillingPlanDateCategory AS _BillingPlanDateCategory,
  SlsContrItemBillingPlanItem._BillingPlanRelatedBillgSts AS _BillingPlanRelatedBillgSts,
  SlsContrItemBillingPlanItem._BillingPlanType AS _BillingPlanType,
  SlsContrItemBillingPlanItem._CustomerPaymentTerms AS _CustomerPaymentTerms,
  SlsContrItemBillingPlanItem._TransactionCurrency AS _TransactionCurrency,
  SlsContrItemBillingPlanItem._BillgPlnDteCrrtnRfndType AS _BillgPlnDteCrrtnRfndType,
  SlsContrItemBillingPlanItem._BillingPlanMilestoneUsage AS _BillingPlanMilestoneUsage
FROM I_SlsContrItemBillingPlanItem AS SlsContrItemBillingPlanItem
LEFT OUTER JOIN R_SalesContractTP AS _SalesContract ON SalesContract = _SalesContract.SalesContract  -- association [1..1]
LEFT OUTER JOIN R_SalesContractItemTP AS _Item ON SalesContract = _Item.SalesContract AND SalesContractItem = _Item.SalesContractItem  -- association [1..1]
;

Learn More