P_ERPACTUALWIP

CDS View
22 Fields 1 CDS Views

P_ERPACTUALWIP is a CDS View in S/4HANA. It contains 22 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_MstrProjPlanCost view union COMPOSITE

Fields (22)

KeyField CDS FieldsUsed in Views
KEY MasterProject MasterProject 1
ActualCostAmount ActualCostAmount 1
ActualCostInObjectCrcy ActualCostInObjectCrcy 1
ActualCostInProjCrcy ActualCostInProjCrcy 1
ActualCostInTransCrcy ActualCostInTransCrcy 1
ActualRevenueAmount ActualRevenueAmount 1
ActualRevenueInObjectCrcy ActualRevenueInObjectCrcy 1
ActualRevenueInProjCrcy ActualRevenueInProjCrcy 1
ActualRevenueInTransCrcy ActualRevenueInTransCrcy 1
CmtmtCostInGlobalCurrency CmtmtCostInGlobalCurrency 1
CompanyCodeCurrency CompanyCodeCurrency 1
ControllingAreaCurrency ControllingAreaCurrency 1
ControllingObject ControllingObject 1
Currency Currency 1
MasterProjectIsConfidential MasterProjectIsConfidential 1
MasterProjectOrganization MasterProjectOrganization 1
MasterProjectType MasterProjectType 1
StrtToDteActlCostInCOCrcy StrtToDteActlCostInCOCrcy 1
StrtToDteActlCostInProjCrcy StrtToDteActlCostInProjCrcy 1
StrtToDteActlRevnInCOCrcy StrtToDteActlRevnInCOCrcy 1
StrtToDteActlRevnInProjCrcy StrtToDteActlRevnInProjCrcy 1
TransactionCurrency TransactionCurrency 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_ERPACTUALWIP (
    MASTERPROJECT,
    ACTUALCOSTAMOUNT,
    ACTUALCOSTINOBJECTCRCY,
    ACTUALCOSTINPROJCRCY,
    ACTUALCOSTINTRANSCRCY,
    ACTUALREVENUEAMOUNT,
    ACTUALREVENUEINOBJECTCRCY,
    ACTUALREVENUEINPROJCRCY,
    ACTUALREVENUEINTRANSCRCY,
    CMTMTCOSTINGLOBALCURRENCY,
    COMPANYCODECURRENCY,
    CONTROLLINGAREACURRENCY,
    CONTROLLINGOBJECT,
    CURRENCY,
    MASTERPROJECTISCONFIDENTIAL,
    MASTERPROJECTORGANIZATION,
    MASTERPROJECTTYPE,
    STRTTODTEACTLCOSTINCOCRCY,
    STRTTODTEACTLCOSTINPROJCRCY,
    STRTTODTEACTLREVNINCOCRCY,
    STRTTODTEACTLREVNINPROJCRCY,
    TRANSACTIONCURRENCY,
    PRIMARY KEY (MASTERPROJECT)
);

Learn More