FDC_D_ACCDOC_TMP

Transparent Table Temporary Data
17 Fields 4 CDS Views

Temporary storage of an accounting document

FDC_D_ACCDOC_TMP is an SAP database table in S/4HANA. Temporary storage of an accounting document. It contains 17 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
FACVD_CLRIT_05 view left_outer Open items of incoming payment for manual clearing
FACVD_CLRIT_06 view left_outer Open items of outgoing payment for manual clearing
farvd_bs_it_02 view_entity left_outer Bank Statement Items
P_Arbanktransactiondocitem_07 view left_outer COMPOSITE

Fields (17)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY relid abap.char
KEY usera USERNAME User Name
KEY tmpty FDC_ACCDOC_TMP_DOC_TYPE Temp. Document Type
KEY tmpid FDC_ACCDOC_TMP_DOC_ID Temp. Document ID
KEY srtf2 abap.int4
crdat abap.dats
aedat abap.dats
aetim abap.tims
tcode TCODE Transaction Code
laufi LAUFI Identification
tempd TEMPN Temporary Document Number
hold_doc_uuid FDC_DFT_KEY RAW16
enq_context_id ENQ_CONTEXT_ID Context ID
xlock_deleted abap.char
clustr SYBIN2 BIN2 data element for SYST
clustd INDX_CLUST Data

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.

-- Temporary storage of an accounting document
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FDC_D_ACCDOC_TMP (
    MANDT,           -- Client [MANDT]
    RELID,           -- abap.char
    USERA,           -- User Name [USERNAME]
    TMPTY,           -- Temp. Document Type [FDC_ACCDOC_TMP_DOC_TYPE]
    TMPID,           -- Temp. Document ID [FDC_ACCDOC_TMP_DOC_ID]
    SRTF2,           -- abap.int4
    CRDAT,           -- abap.dats
    AEDAT,           -- abap.dats
    AETIM,           -- abap.tims
    TCODE,           -- Transaction Code [TCODE]
    LAUFI,           -- Identification [LAUFI]
    TEMPD,           -- Temporary Document Number [TEMPN]
    HOLD_DOC_UUID,   -- RAW16 [FDC_DFT_KEY]
    ENQ_CONTEXT_ID,  -- Context ID [ENQ_CONTEXT_ID]
    XLOCK_DELETED,   -- abap.char
    CLUSTR,          -- BIN2 data element for SYST [SYBIN2]
    CLUSTD,          -- Data [INDX_CLUST]
    PRIMARY KEY (MANDT, RELID, USERA, TMPTY, TMPID, SRTF2)
);

Learn More