I_BPALLDATA

CDS View
22 Fields 2 CDS Views

All Billing Plan Data

I_BPALLDATA is a CDS View in S/4HANA. All Billing Plan Data. It contains 22 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_BPMasterProject view inner COMPOSITE Master Project Billing Plans
P_MstrProjWSBillingDueDate view inner COMPOSITE

Fields (22)

KeyField CDS FieldsUsed in Views
KEY BillingPlan BillingPlan 1
KEY BillingPlanItem BillingPlanItem 1
KEY SalesDocument SalesDocument 2
KEY SalesDocumentItem SalesDocumentItem 2
BillingBlockReasonDescription BillingBlockReasonDescription 1
BillingDate BillingDate 1
BillingEventTypeName BillingEventTypeName 1
BillingPlanBillingDateText BillingPlanBillingDateText 1
BillingPlanCategoryName BillingPlanCategoryName 1
BillingPlanRuleName BillingPlanRuleName 1
DocumentStatusDesc DocumentStatusDesc 1
DocumentStatusName DocumentStatusName 1
EventType EventType 1
IsBillingCreatedInAdvance IsBillingCreatedInAdvance 1
MaterialName MaterialName 1
MstrProjResourceQuantity MstrProjResourceQuantity 1
PostingDate PostingDate 1
PricingDate PricingDate 1
SDDocumentStatus SDDocumentStatus 1
SoldToParty SoldToParty 1
TransactionCurrency TransactionCurrency 1
UnitOfMeasure UnitOfMeasure 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.

-- All Billing Plan Data
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_BPALLDATA (
    BILLINGPLAN,
    BILLINGPLANITEM,
    SALESDOCUMENT,
    SALESDOCUMENTITEM,
    BILLINGBLOCKREASONDESCRIPTION,
    BILLINGDATE,
    BILLINGEVENTTYPENAME,
    BILLINGPLANBILLINGDATETEXT,
    BILLINGPLANCATEGORYNAME,
    BILLINGPLANRULENAME,
    DOCUMENTSTATUSDESC,
    DOCUMENTSTATUSNAME,
    EVENTTYPE,
    ISBILLINGCREATEDINADVANCE,
    MATERIALNAME,
    MSTRPROJRESOURCEQUANTITY,
    POSTINGDATE,
    PRICINGDATE,
    SDDOCUMENTSTATUS,
    SOLDTOPARTY,
    TRANSACTIONCURRENCY,
    UNITOFMEASURE,
    PRIMARY KEY (BILLINGPLAN, BILLINGPLANITEM, SALESDOCUMENT, SALESDOCUMENTITEM)
);

Learn More