I_SALESDOCITEMBILLINGPLANITEM

CDS View
42 Fields 11 CDS Views

Billing Plan Item of Sales Document Item

I_SALESDOCITEMBILLINGPLANITEM is a CDS View in S/4HANA. Billing Plan Item of Sales Document Item. It contains 42 fields. 11 CDS views read from this table.

CDS Views using this table (11)

ViewTypeJoinVDMDescription
C_ProjBillgElmntEntrSrceAttrib view_entity inner CONSUMPTION Proj Billg Elmnt Entr Source Attributes
C_ProjBillgSlsItmBillgPlnDuDte view_entity from CONSUMPTION Due billing date popover
I_BillingPlanDueDateAnalytics view inner COMPOSITE Billing Plan Due Date Analytics
I_CustProjSlsOrdItmBillgPlnItm view_entity inner COMPOSITE Billing Plan Item of Sales Order Item for Customer Project
I_SlsContrItemBillingPlanItem view_entity from COMPOSITE Billing Plan Item of Sales Contract Item
I_SlsOrderItemBillingPlanItem view_entity from COMPOSITE Billing Plan Item of Sales Order Item
P_RRBProposal view inner CONSUMPTION Billing Proposal Details
P_RRBSalesPricingDynamicItem view inner CONSUMPTION CDS private View for Resource Related Billing Dynamic Items
P_SlsOrdBillingPlanDueDate view inner COMPOSITE SOFM Due Date Calc. For Sales Orders With Billing Plan
P_SlsOrdItmBillgPlanDueDte view inner COMPOSITE SOFM Due Date Calc. For Sales Order Items With Billing Plan
P_SlsOrdItmBillgPlanDueDte2 view inner COMPOSITE ReuseView

Fields (42)

KeyField CDS FieldsUsed in Views
KEY BillingPlan BillingPlan 4
KEY BillingPlanItem BillingPlanItem 6
_AdoptingBillingDateID _AdoptingBillingDateID 2
_BillgPlanItemUsage _BillgPlanItemUsage 1
_BillgPlanItemUsage_2 _BillgPlanItemUsage_2 1
_BillgPlnDteCrrtnRfndType _BillgPlnDteCrrtnRfndType 2
_BillgPlnDteDescCode _BillgPlnDteDescCode 2
_BillingBlockReason _BillingBlockReason 2
_BillingDocumentType _BillingDocumentType 2
_BillingPlanBillingRule _BillingPlanBillingRule 3
_BillingPlanDateCategory _BillingPlanDateCategory 2
_BillingPlanMilestoneUsage _BillingPlanMilestoneUsage 2
_BillingPlanRelatedBillgSts _BillingPlanRelatedBillgSts 2
_BillingPlanType _BillingPlanType 2
_BillingPlanUsageCategory _BillingPlanUsageCategory 1
_CustomerPaymentTerms _CustomerPaymentTerms 2
_TransactionCurrency _TransactionCurrency 3
AccountingExchangeRate AccountingExchangeRate 2
AdoptingBillingDateID AdoptingBillingDateID 2
BillgPlnDteCorrectionRfndType BillgPlnDteCorrectionRfndType 3
BillingBlockReason BillingBlockReason 2
BillingPlanAmount BillingPlanAmount 3
BillingPlanAmountPercent BillingPlanAmountPercent 2
BillingPlanBillingDate BillingPlanBillingDate 4
BillingPlanBillingRule BillingPlanBillingRule,BillingPlanRule 3
BillingPlanDateCategory BillingPlanDateCategory 2
BillingPlanDateDescriptionCode BillingPlanDateDescriptionCode 2
BillingPlanItemDescription BillingPlanItemDescription 2
BillingPlanItemUsage BillingPlanItemUsage 2
BillingPlanItemUsage_2 BillingPlanItemUsage_2 2
BillingPlanMilestoneUsage BillingPlanMilestoneUsage 2
BillingPlanRelatedBillgStatus BillingPlanRelatedBillgStatus 5
BillingPlanServiceEndDate BillingPlanServiceEndDate 3
BillingPlanServiceStartDate BillingPlanServiceStartDate 3
BillingPlanType BillingPlanType 2
BillingPlanUsageCategory BillingPlanUsageCategory 1
CustomerPaymentTerms CustomerPaymentTerms 2
EnterpriseProjectMilestone EnterpriseProjectMilestone 1
EnterpriseProjectMilestoneUUID EnterpriseProjectMilestoneUUID 1
PostponementReason PostponementReason 3
ProposedBillingDocumentType ProposedBillingDocumentType 2
TransactionCurrency TransactionCurrency 4

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 Document Item
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_SALESDOCITEMBILLINGPLANITEM (
    BILLINGPLAN,
    BILLINGPLANITEM,
    _ADOPTINGBILLINGDATEID,
    _BILLGPLANITEMUSAGE,
    _BILLGPLANITEMUSAGE_2,
    _BILLGPLNDTECRRTNRFNDTYPE,
    _BILLGPLNDTEDESCCODE,
    _BILLINGBLOCKREASON,
    _BILLINGDOCUMENTTYPE,
    _BILLINGPLANBILLINGRULE,
    _BILLINGPLANDATECATEGORY,
    _BILLINGPLANMILESTONEUSAGE,
    _BILLINGPLANRELATEDBILLGSTS,
    _BILLINGPLANTYPE,
    _BILLINGPLANUSAGECATEGORY,
    _CUSTOMERPAYMENTTERMS,
    _TRANSACTIONCURRENCY,
    ACCOUNTINGEXCHANGERATE,
    ADOPTINGBILLINGDATEID,
    BILLGPLNDTECORRECTIONRFNDTYPE,
    BILLINGBLOCKREASON,
    BILLINGPLANAMOUNT,
    BILLINGPLANAMOUNTPERCENT,
    BILLINGPLANBILLINGDATE,
    BILLINGPLANBILLINGRULE,
    BILLINGPLANDATECATEGORY,
    BILLINGPLANDATEDESCRIPTIONCODE,
    BILLINGPLANITEMDESCRIPTION,
    BILLINGPLANITEMUSAGE,
    BILLINGPLANITEMUSAGE_2,
    BILLINGPLANMILESTONEUSAGE,
    BILLINGPLANRELATEDBILLGSTATUS,
    BILLINGPLANSERVICEENDDATE,
    BILLINGPLANSERVICESTARTDATE,
    BILLINGPLANTYPE,
    BILLINGPLANUSAGECATEGORY,
    CUSTOMERPAYMENTTERMS,
    ENTERPRISEPROJECTMILESTONE,
    ENTERPRISEPROJECTMILESTONEUUID,
    POSTPONEMENTREASON,
    PROPOSEDBILLINGDOCUMENTTYPE,
    TRANSACTIONCURRENCY,
    PRIMARY KEY (BILLINGPLAN, BILLINGPLANITEM)
);

Learn More