P_BILLINGPLANITEM

CDS View
37 Fields 2 CDS Views

P_BILLINGPLANITEM is a CDS View in S/4HANA. It contains 37 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_SDBillingPlanItem view_entity from BASIC Billing Plan Item for SD Documents
R_POInvoicingPlanItem view_entity from BASIC Purchase Order Invoicing Plan Item

Fields (37)

KeyField CDS FieldsUsed in Views
KEY BillingPlan BillingPlan,InvoicingPlan 2
KEY BillingPlanItem BillingPlanItem,InvoicingPlanItem 2
_AdoptingBillingDateID _AdoptingBillingDateID 1
_BillgPlanItemUsage _BillgPlanItemUsage 1
_BillgPlanItemUsage_2 _BillgPlanItemUsage_2 1
_BillgPlnDteCrrtnRfndType _BillgPlnDteCrrtnRfndType 1
_BillgPlnDteDescCode _BillgPlnDteDescCode 1
_BillingBlockReason _BillingBlockReason 1
_BillingDocumentType _BillingDocumentType 1
_BillingPlanBillingRule _BillingPlanBillingRule 1
_BillingPlanMilestoneUsage _BillingPlanMilestoneUsage 1
_BillingPlanRelatedBillgSts _BillingPlanRelatedBillgSts 1
_BillingPlanUsageCategory _BillingPlanUsageCategory 1
_CustomerPaymentTerms _CustomerPaymentTerms 1
_TransactionCurrency _TransactionCurrency 2
AccountingExchangeRate AccountingExchangeRate 1
AdoptingBillingDateID AdoptingBillingDateID 1
BillgPlnDteCorrectionRfndType BillgPlnDteCorrectionRfndType 1
BillingBlockReason BillingBlockReason 1
BillingPlanAmount BillingPlanAmount,InvoicingPlanAmount 2
BillingPlanAmountPercent BillingPlanAmountPercent,InvoicingPlanAmountPercent 2
BillingPlanBillingDate BillingPlanBillingDate,InvoicingPlanInvoicingDate 2
BillingPlanBillingRule BillingPlanBillingRule 1
BillingPlanDateCategory BillingPlanDateCategory 1
BillingPlanDateDescriptionCode BillingPlanDateDescriptionCode 1
BillingPlanItemDescription BillingPlanItemDescription 1
BillingPlanItemUsage BillingPlanItemUsage 1
BillingPlanItemUsage_2 BillingPlanItemUsage_2 1
BillingPlanMilestoneUsage BillingPlanMilestoneUsage 1
BillingPlanRelatedBillgStatus BillingPlanRelatedBillgStatus 1
BillingPlanServiceEndDate BillingPlanServiceEndDate,InvoicingPlanSettlementToDte 2
BillingPlanServiceStartDate BillingPlanServiceStartDate,InvoicingPlanSettlementFromDte 2
BillingPlanUsageCategory BillingPlanUsageCategory 1
CustomerPaymentTerms CustomerPaymentTerms 1
PostponementReason PostponementReason 1
ProposedBillingDocumentType ProposedBillingDocumentType 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_BILLINGPLANITEM (
    BILLINGPLAN,
    BILLINGPLANITEM,
    _ADOPTINGBILLINGDATEID,
    _BILLGPLANITEMUSAGE,
    _BILLGPLANITEMUSAGE_2,
    _BILLGPLNDTECRRTNRFNDTYPE,
    _BILLGPLNDTEDESCCODE,
    _BILLINGBLOCKREASON,
    _BILLINGDOCUMENTTYPE,
    _BILLINGPLANBILLINGRULE,
    _BILLINGPLANMILESTONEUSAGE,
    _BILLINGPLANRELATEDBILLGSTS,
    _BILLINGPLANUSAGECATEGORY,
    _CUSTOMERPAYMENTTERMS,
    _TRANSACTIONCURRENCY,
    ACCOUNTINGEXCHANGERATE,
    ADOPTINGBILLINGDATEID,
    BILLGPLNDTECORRECTIONRFNDTYPE,
    BILLINGBLOCKREASON,
    BILLINGPLANAMOUNT,
    BILLINGPLANAMOUNTPERCENT,
    BILLINGPLANBILLINGDATE,
    BILLINGPLANBILLINGRULE,
    BILLINGPLANDATECATEGORY,
    BILLINGPLANDATEDESCRIPTIONCODE,
    BILLINGPLANITEMDESCRIPTION,
    BILLINGPLANITEMUSAGE,
    BILLINGPLANITEMUSAGE_2,
    BILLINGPLANMILESTONEUSAGE,
    BILLINGPLANRELATEDBILLGSTATUS,
    BILLINGPLANSERVICEENDDATE,
    BILLINGPLANSERVICESTARTDATE,
    BILLINGPLANUSAGECATEGORY,
    CUSTOMERPAYMENTTERMS,
    POSTPONEMENTREASON,
    PROPOSEDBILLINGDOCUMENTTYPE,
    TRANSACTIONCURRENCY,
    PRIMARY KEY (BILLINGPLAN, BILLINGPLANITEM)
);

Learn More