I_BPMASTERPROJECT

CDS View
25 Fields 2 CDS Views

Master Project Billing Plans

I_BPMASTERPROJECT is a CDS View in S/4HANA. Master Project Billing Plans. It contains 25 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
C_MasterProjectBillingPlan view from CONSUMPTION Master Project Billing Plans
I_MasterProjectBillingPlanCube view from COMPOSITE Master Project Billing Plan Cube

Fields (25)

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

-- Master Project Billing Plans
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_BPMASTERPROJECT (
    BILLINGPLAN,
    BILLINGPLANITEM,
    MASTERPROJECT,
    SALESDOCUMENT,
    SALESDOCUMENTITEM,
    BILLINGBLOCKREASONDESCRIPTION,
    BILLINGDATE,
    BILLINGEVENTTYPENAME,
    BILLINGPLANBILLINGDATETEXT,
    BILLINGPLANCATEGORYNAME,
    BILLINGPLANRULENAME,
    CONTROLLINGOBJECTEXTERNALID,
    CUSTOMERNAME,
    DOCUMENTSTATUSDESC,
    DOCUMENTSTATUSNAME,
    EVENTTYPE,
    ISBILLINGCREATEDINADVANCE,
    MASTERPROJECTNAME,
    MSTRPROJRESOURCEQUANTITY,
    NETAMOUNT,
    SALESORGANIZATION,
    SDDOCUMENTSTATUS,
    SOLDTOPARTY,
    TRANSACTIONCURRENCY,
    UNITOFMEASURE,
    PRIMARY KEY (BILLINGPLAN, BILLINGPLANITEM, MASTERPROJECT, SALESDOCUMENT, SALESDOCUMENTITEM)
);

Learn More