P_ACTUALSFORENGMNTPROJECT

CDS View
35 Fields 1 CDS Views

Engagement Project - Actuals

P_ACTUALSFORENGMNTPROJECT is a CDS View in S/4HANA. Engagement Project - Actuals. It contains 35 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_ENGMTPROJACTUAL view from COMPOSITE Engagement Projects Actuals from Journal Entry

Fields (35)

KeyField CDS FieldsUsed in Views
KEY FiscalPeriod FiscalPeriod 1
KEY FiscalYear FiscalYear 1
KEY FiscalYearPeriod FiscalYearPeriod 1
KEY PostingDate PostingDate 1
KEY Project Project 1
KEY SourceLedger Ledger,SourceLedger 1
KEY WorkPackage WorkPackage 1
AccountAssignmentType AccountAssignmentType 1
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency,AmountInPlanCurrency 1
AmountInGlobalCurrency AmountInGlobalCurrency 1
AmountInObjectCurrency AmountInObjectCurrency 1
BaseUnit BaseUnit 1
BillableControl BillableControl 1
BusinessTransactionType BusinessTransactionType 1
ChartOfAccounts ChartOfAccounts 1
CompanyCodeCurrency CompanyCodeCurrency 1
ControllingArea ControllingArea 1
ControllingObject ControllingObject 1
ControllingObjectCurrency ControllingObjectCurrency 1
ControllingObjectDebitType ControllingObjectDebitType 1
GLAccount GLAccount 1
GlobalCurrency GlobalCurrency 1
IsCommitment IsCommitment 1
IsMyProject IsMyProject 1
PartnerCompanyCode CompanyCode,PartnerCompanyCode 1
PartnerCostCenter CostCenter,PartnerCostCenter 1
PersonnelNumber PersonnelNumber 1
Product Material 1
ProjectManagerName ProjectManagerName 1
Quantity Quantity 1
SalesDocument SalesOrder 1
SalesDocumentItem SalesOrderItem 1
TransactionCurrency Currency 1
WBSElement WBSElement 1
WorkItem WorkItem 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.

-- Engagement Project - Actuals
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_ACTUALSFORENGMNTPROJECT (
    FISCALPERIOD,
    FISCALYEAR,
    FISCALYEARPERIOD,
    POSTINGDATE,
    PROJECT,
    SOURCELEDGER,
    WORKPACKAGE,
    ACCOUNTASSIGNMENTTYPE,
    AMOUNTINCOMPANYCODECURRENCY,
    AMOUNTINGLOBALCURRENCY,
    AMOUNTINOBJECTCURRENCY,
    BASEUNIT,
    BILLABLECONTROL,
    BUSINESSTRANSACTIONTYPE,
    CHARTOFACCOUNTS,
    COMPANYCODECURRENCY,
    CONTROLLINGAREA,
    CONTROLLINGOBJECT,
    CONTROLLINGOBJECTCURRENCY,
    CONTROLLINGOBJECTDEBITTYPE,
    GLACCOUNT,
    GLOBALCURRENCY,
    ISCOMMITMENT,
    ISMYPROJECT,
    PARTNERCOMPANYCODE,
    PARTNERCOSTCENTER,
    PERSONNELNUMBER,
    PRODUCT,
    PROJECTMANAGERNAME,
    QUANTITY,
    SALESDOCUMENT,
    SALESDOCUMENTITEM,
    TRANSACTIONCURRENCY,
    WBSELEMENT,
    WORKITEM,
    PRIMARY KEY (FISCALPERIOD, FISCALYEAR, FISCALYEARPERIOD, POSTINGDATE, PROJECT, SOURCELEDGER, WORKPACKAGE)
);

Learn More