I_SLSORDERITEMBILLINGPLANITEM

CDS View
38 Fields 2 CDS Views

Billing Plan Item of Sales Order Item

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

CDS Views using this table (2)

ViewTypeJoinVDMDescription
A_SlsOrderItemBillingPlanItem view_entity from COMPOSITE Item Billing Plan Item
R_SlsOrdItemBillingPlanItemTP view_entity from TRANSACTIONAL Billing Plan Item for Sls Ord Item - TP

Fields (38)

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

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 Order Item
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_SLSORDERITEMBILLINGPLANITEM (
    BILLINGPLAN,
    BILLINGPLANITEM,
    SALESORDER,
    SALESORDERITEM,
    _ADOPTINGBILLINGDATEID,
    _BILLGPLNDTECRRTNRFNDTYPE,
    _BILLGPLNDTEDESCCODE,
    _BILLINGBLOCKREASON,
    _BILLINGDOCUMENTTYPE,
    _BILLINGPLANBILLINGRULE,
    _BILLINGPLANDATECATEGORY,
    _BILLINGPLANRELATEDBILLGSTS,
    _BILLINGPLANTYPE,
    _CUSTOMERPAYMENTTERMS,
    _TRANSACTIONCURRENCY,
    ACCOUNTINGEXCHANGERATE,
    ADOPTINGBILLINGDATEID,
    BILLGPLNDTECORRECTIONRFNDTYPE,
    BILLINGBLOCKREASON,
    BILLINGPLANAMOUNT,
    BILLINGPLANAMOUNTPERCENT,
    BILLINGPLANBILLINGDATE,
    BILLINGPLANBILLINGRULE,
    BILLINGPLANDATECATEGORY,
    BILLINGPLANDATEDESCRIPTIONCODE,
    BILLINGPLANMILESTONEUSAGE,
    BILLINGPLANRELATEDBILLGSTATUS,
    BILLINGPLANSERVICEENDDATE,
    BILLINGPLANSERVICESTARTDATE,
    BILLINGPLANTYPE,
    CUSTOMERPAYMENTTERMS,
    DISTRIBUTIONCHANNEL,
    ORGANIZATIONDIVISION,
    POSTPONEMENTREASON,
    PROPOSEDBILLINGDOCUMENTTYPE,
    SALESORDERTYPE,
    SALESORGANIZATION,
    TRANSACTIONCURRENCY,
    PRIMARY KEY (BILLINGPLAN, BILLINGPLANITEM, SALESORDER, SALESORDERITEM)
);

Learn More