P_MX_JRNLENTRYDISTINCTGLACCT

CDS View
2 Fields 8 CDS Views

Journal Entry Distinct GL Account

P_MX_JRNLENTRYDISTINCTGLACCT is a CDS View in S/4HANA. Journal Entry Distinct GL Account. It contains 2 fields. 8 CDS views read from this table.

CDS Views using this table (8)

ViewTypeJoinVDMDescription
C_MX_JrnlEntrAuxFrgnCompnDets view inner CONSUMPTION MX Folios Foreign Compensation Details
C_MX_JrnlEntrAuxNatlCompnDets view inner CONSUMPTION MX Folios National Compensation Details
C_MX_JrnlEntrAuxOtherCompnDets view inner CONSUMPTION MX Folios Other Compensation Details
C_MX_JrnlEntrFrgnCompnDetails view inner CONSUMPTION MX JE Foreign Compensation Details
C_MX_JrnlEntrItmInvcDetailsC view inner CONSUMPTION Journal Entries Items with Invoices Cube
C_MX_JrnlEntrItmPaytDetailsC view inner CONSUMPTION Journal Entries Items with Payments Cube
C_MX_JrnlEntrNatlCompnDetails view inner CONSUMPTION MX JE National Compensation Details
C_MX_JrnlEntrOtherCompnDetails view inner CONSUMPTION MX JE Other Compensation Details

Fields (2)

KeyField CDS FieldsUsed in Views
KEY DocumentItemText DocumentItemText 2
KEY GLAccount GLAccount 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.

-- Journal Entry Distinct GL Account
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_MX_JRNLENTRYDISTINCTGLACCT (
    DOCUMENTITEMTEXT,
    GLACCOUNT,
    PRIMARY KEY (DOCUMENTITEMTEXT, GLACCOUNT)
);

Learn More