P_ENGMNTPROJGLACCTRAWDATA

CDS View

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

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_EngmntProjectWithActual view inner COMPOSITE
P_EngmtProjActuals view inner COMPOSITE

Fields (27)

KeyField CDS FieldsUsed in Views
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency 2
AmountInGlobalCurrency AmountInGlobalCurrency 1
AmountInObjectCurrency AmountInObjectCurrency 1
AmountInTransactionCurrency AmountInTransactionCurrency 1
BusinessTransactionType BusinessTransactionType 2
ChartOfAccounts ChartOfAccounts 2
CompanyCodeCurrency CompanyCodeCurrency 2
ControllingArea ControllingArea 2
ControllingObject ControllingObject 2
ControllingObjectCurrency ControllingObjectCurrency 1
ControllingObjectDebitType ControllingObjectDebitType 2
CostSourceUnit CostSourceUnit 2
FiscalYearPeriod FiscalYearPeriod 2
GLAccount GLAccount 2
GlobalCurrency GlobalCurrency 1
PersonnelNumber PersonnelNumber 2
PostingDate PostingDate 2
Product Material 2
Project Project 1
Quantity Quantity 2
SalesDocument SalesOrder 2
SalesDocumentItem SalesOrderItem 2
SourceLedger Ledger 2
TransactionCurrency TransactionCurrency 1
WBSElement WBSElement 2
WorkItem WorkItem 2
WorkPackage WorkPackage 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_ENGMNTPROJGLACCTRAWDATA (
    AMOUNTINCOMPANYCODECURRENCY,
    AMOUNTINGLOBALCURRENCY,
    AMOUNTINOBJECTCURRENCY,
    AMOUNTINTRANSACTIONCURRENCY,
    BUSINESSTRANSACTIONTYPE,
    CHARTOFACCOUNTS,
    COMPANYCODECURRENCY,
    CONTROLLINGAREA,
    CONTROLLINGOBJECT,
    CONTROLLINGOBJECTCURRENCY,
    CONTROLLINGOBJECTDEBITTYPE,
    COSTSOURCEUNIT,
    FISCALYEARPERIOD,
    GLACCOUNT,
    GLOBALCURRENCY,
    PERSONNELNUMBER,
    POSTINGDATE,
    PRODUCT,
    PROJECT,
    QUANTITY,
    SALESDOCUMENT,
    SALESDOCUMENTITEM,
    SOURCELEDGER,
    TRANSACTIONCURRENCY,
    WBSELEMENT,
    WORKITEM,
    WORKPACKAGE
);