I_SLSCONTRITEMBILLINGPLANITEM

CDS View

Billing Plan Item of Sales Contract Item

I_SLSCONTRITEMBILLINGPLANITEM is a CDS View in S/4HANA. Billing Plan Item of Sales Contract Item. It contains 38 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_SlsContrItmBillingPlanItemTP view_entity from TRANSACTIONAL Billing Plan Item for Sls Contr Item - TP

Fields (38)

KeyField CDS FieldsUsed in Views
KEY BillingPlan BillingPlan 1
KEY BillingPlanItem BillingPlanItem,BillingPlanItemForEdit 1
KEY SalesContract SalesContract 1
KEY SalesContractItem SalesContractItem 1
_AdoptingBillingDateID _AdoptingBillingDateID 1
_BillgPlnDteCrrtnRfndType _BillgPlnDteCrrtnRfndType 1
_BillgPlnDteDescCode _BillgPlnDteDescCode 1
_BillingBlockReason _BillingBlockReason 1
_BillingDocumentType _BillingDocumentType 1
_BillingPlanBillingRule _BillingPlanBillingRule 1
_BillingPlanDateCategory _BillingPlanDateCategory 1
_BillingPlanMilestoneUsage _BillingPlanMilestoneUsage 1
_BillingPlanRelatedBillgSts _BillingPlanRelatedBillgSts 1
_BillingPlanType _BillingPlanType 1
_CustomerPaymentTerms _CustomerPaymentTerms 1
_TransactionCurrency _TransactionCurrency 1
AccountingExchangeRate AccountingExchangeRate 1
AdoptingBillingDateID AdoptingBillingDateID 1
BillgPlnDteCorrectionRfndType BillgPlnDteCorrectionRfndType 1
BillingBlockReason BillingBlockReason 1
BillingPlanAmount BillingPlanAmount 1
BillingPlanAmountPercent BillingPlanAmountPercent 1
BillingPlanBillingDate BillingPlanBillingDate 1
BillingPlanBillingRule BillingPlanBillingRule 1
BillingPlanDateCategory BillingPlanDateCategory 1
BillingPlanDateDescriptionCode BillingPlanDateDescriptionCode 1
BillingPlanMilestoneUsage BillingPlanMilestoneUsage 1
BillingPlanRelatedBillgStatus BillingPlanRelatedBillgStatus 1
BillingPlanServiceEndDate BillingPlanServiceEndDate 1
BillingPlanServiceStartDate BillingPlanServiceStartDate 1
BillingPlanType BillingPlanType 1
CustomerPaymentTerms CustomerPaymentTerms 1
DistributionChannel DistributionChannel 1
OrganizationDivision OrganizationDivision 1
ProposedBillingDocumentType ProposedBillingDocumentType 1
SalesContractType SalesContractType 1
SalesOrganization SalesOrganization 1
TransactionCurrency TransactionCurrency 1

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Billing Plan Item of Sales Contract Item
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_SLSCONTRITEMBILLINGPLANITEM (
    BILLINGPLAN,
    BILLINGPLANITEM,
    SALESCONTRACT,
    SALESCONTRACTITEM,
    _ADOPTINGBILLINGDATEID,
    _BILLGPLNDTECRRTNRFNDTYPE,
    _BILLGPLNDTEDESCCODE,
    _BILLINGBLOCKREASON,
    _BILLINGDOCUMENTTYPE,
    _BILLINGPLANBILLINGRULE,
    _BILLINGPLANDATECATEGORY,
    _BILLINGPLANMILESTONEUSAGE,
    _BILLINGPLANRELATEDBILLGSTS,
    _BILLINGPLANTYPE,
    _CUSTOMERPAYMENTTERMS,
    _TRANSACTIONCURRENCY,
    ACCOUNTINGEXCHANGERATE,
    ADOPTINGBILLINGDATEID,
    BILLGPLNDTECORRECTIONRFNDTYPE,
    BILLINGBLOCKREASON,
    BILLINGPLANAMOUNT,
    BILLINGPLANAMOUNTPERCENT,
    BILLINGPLANBILLINGDATE,
    BILLINGPLANBILLINGRULE,
    BILLINGPLANDATECATEGORY,
    BILLINGPLANDATEDESCRIPTIONCODE,
    BILLINGPLANMILESTONEUSAGE,
    BILLINGPLANRELATEDBILLGSTATUS,
    BILLINGPLANSERVICEENDDATE,
    BILLINGPLANSERVICESTARTDATE,
    BILLINGPLANTYPE,
    CUSTOMERPAYMENTTERMS,
    DISTRIBUTIONCHANNEL,
    ORGANIZATIONDIVISION,
    PROPOSEDBILLINGDOCUMENTTYPE,
    SALESCONTRACTTYPE,
    SALESORGANIZATION,
    TRANSACTIONCURRENCY,
    PRIMARY KEY (BILLINGPLAN, BILLINGPLANITEM, SALESCONTRACT, SALESCONTRACTITEM)
);