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 Retrieves Statement Item details

Fields (17)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY relid abap.char Area ar specification
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 Row number of stored data
crdat abap.dats Creation Date
aedat abap.dats Last Change Date
aetim abap.tims Last Change Time
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 Locks are deleted
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,           -- Area ar specification [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,           -- Row number of stored data [abap.int4]
    CRDAT,           -- Creation Date [abap.dats]
    AEDAT,           -- Last Change Date [abap.dats]
    AETIM,           -- Last Change Time [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,   -- Locks are deleted [abap.char]
    CLUSTR,          -- BIN2 data element for SYST [sybin2]
    CLUSTD,          -- Data [indx_clust]
    PRIMARY KEY (MANDT, RELID, USERA, TMPTY, TMPID, SRTF2)
);

Learn More