GLE_MCA_DOCREF

Transparent Table Application Table
21 Fields 1 CDS Views

MCA Document Reference Data

GLE_MCA_DOCREF is an SAP database table in S/4HANA. MCA Document Reference Data. It contains 21 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_MCAdocref view from BASIC

Fields (21)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY rldnr RLDNR Ledger
KEY bukrs BUKRS Company Code
KEY belnr BELNR_D Document Number
KEY gjahr GJAHR Fiscal Year
KEY buzei BUZEI6 Item
KEY mca_docno GLE_MCA_DTE_BELNR MCA Document Number
KEY mca_gjahr GLE_MCA_DTE_GJAHR MCA Doc. Fisc. Year
KEY doc_category GLE_MCA_DTE_DOC_CAT Document Cat
KEY runid GLE_MCA_DTE_RUNID MCA Run ID
prccat GLE_MCA_DTE_TPRC_CAT T. Process Categ.
budat BUDAT Posting Date
reversed GLE_MCA_DTE_REVERSAL Reversal Status
fipp_created GLE_MCA_DTE_RELEASED Released
fipp_rejected GLE_MCA_DTE_REJECTED Rejected
pp_objno GLE_MCA_DTE_PP_OBJNO Object Number
wf_status GLE_DTE_MCA_WF_STATUS Workflow Status
wf_rel_proc BCA_DTE_REL_PROC Req. Release Steps
archive_status TYP_ARCHIVE_STATUS Archiving Status
archive_flud TYP_ARCHIVE_FLUD Resubmission Date
rejection TYP_REJECTION Rejection Reason

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.

-- MCA Document Reference Data
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE GLE_MCA_DOCREF (
    MANDT,           -- Client [MANDT]
    RLDNR,           -- Ledger [RLDNR]
    BUKRS,           -- Company Code [BUKRS]
    BELNR,           -- Document Number [BELNR_D]
    GJAHR,           -- Fiscal Year [GJAHR]
    BUZEI,           -- Item [BUZEI6]
    MCA_DOCNO,       -- MCA Document Number [GLE_MCA_DTE_BELNR]
    MCA_GJAHR,       -- MCA Doc. Fisc. Year [GLE_MCA_DTE_GJAHR]
    DOC_CATEGORY,    -- Document Cat [GLE_MCA_DTE_DOC_CAT]
    RUNID,           -- MCA Run ID [GLE_MCA_DTE_RUNID]
    PRCCAT,          -- T. Process Categ. [GLE_MCA_DTE_TPRC_CAT]
    BUDAT,           -- Posting Date [BUDAT]
    REVERSED,        -- Reversal Status [GLE_MCA_DTE_REVERSAL]
    FIPP_CREATED,    -- Released [GLE_MCA_DTE_RELEASED]
    FIPP_REJECTED,   -- Rejected [GLE_MCA_DTE_REJECTED]
    PP_OBJNO,        -- Object Number [GLE_MCA_DTE_PP_OBJNO]
    WF_STATUS,       -- Workflow Status [GLE_DTE_MCA_WF_STATUS]
    WF_REL_PROC,     -- Req. Release Steps [BCA_DTE_REL_PROC]
    ARCHIVE_STATUS,  -- Archiving Status [TYP_ARCHIVE_STATUS]
    ARCHIVE_FLUD,    -- Resubmission Date [TYP_ARCHIVE_FLUD]
    REJECTION,       -- Rejection Reason [TYP_REJECTION]
    PRIMARY KEY (MANDT, RLDNR, BUKRS, BELNR, GJAHR, BUZEI, MCA_DOCNO, MCA_GJAHR, DOC_CATEGORY, RUNID)
);

Learn More