ICA_DOCH

Transparent Table Application Table
27 Fields 1 CDS Views

Matching Document Head

ICA_DOCH is an SAP database table in S/4HANA. Matching Document Head. It contains 27 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_ICA_MATCHING_DOC view from BASIC Matching Documents

Fields (27)

KeyField Data ElementDescription DomainTypeLength
KEY rclnt MANDT Client
KEY method_id ICA_METHOD_ID Matching Method
KEY docnr ICA_DOCNR Matching Document Number
rtimestamp ICA_TIMESTAMP Cutoff Timestamp
descr ICA_DOC_DESC Matching Document Description
bttype ICA_BTTYPE Business Transaction Type
delflg ICA_DELFLG Deletion Flag
rbukrs BUKRS Company Code
rcomp RCOMP_D Company
rcntr KOSTL Cost Center
prctr PRCTR Profit Center
rfarea FKBER Functional Area
rbusa GSBER Business Area
kokrs KOKRS CO Area
segment FB_SEGMENT Segment
rbunit FC_BUNIT Cons. Unit
periv PERIV FY Variant
ryear RYEAR Fiscal Year
poper POPER Posting Period
fiscyearper JAHRPER Period/Year
rldnr RLDNR Ledger
rvers FC_RVERS Version
ritclg FC_ITCLG Cons. COA
createdby ICA_CREATOR Created By
createdat ICA_TIMESTAMP_C Created On
changedby ICA_MODIFIER Changed By
changedat ICA_TIMESTAMP_M Changed On

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.

-- Matching Document Head
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ICA_DOCH (
    RCLNT,        -- Client [MANDT]
    METHOD_ID,    -- Matching Method [ICA_METHOD_ID]
    DOCNR,        -- Matching Document Number [ICA_DOCNR]
    RTIMESTAMP,   -- Cutoff Timestamp [ICA_TIMESTAMP]
    DESCR,        -- Matching Document Description [ICA_DOC_DESC]
    BTTYPE,       -- Business Transaction Type [ICA_BTTYPE]
    DELFLG,       -- Deletion Flag [ICA_DELFLG]
    RBUKRS,       -- Company Code [BUKRS]
    RCOMP,        -- Company [RCOMP_D]
    RCNTR,        -- Cost Center [KOSTL]
    PRCTR,        -- Profit Center [PRCTR]
    RFAREA,       -- Functional Area [FKBER]
    RBUSA,        -- Business Area [GSBER]
    KOKRS,        -- CO Area [KOKRS]
    SEGMENT,      -- Segment [FB_SEGMENT]
    RBUNIT,       -- Cons. Unit [FC_BUNIT]
    PERIV,        -- FY Variant [PERIV]
    RYEAR,        -- Fiscal Year [RYEAR]
    POPER,        -- Posting Period [POPER]
    FISCYEARPER,  -- Period/Year [JAHRPER]
    RLDNR,        -- Ledger [RLDNR]
    RVERS,        -- Version [FC_RVERS]
    RITCLG,       -- Cons. COA [FC_ITCLG]
    CREATEDBY,    -- Created By [ICA_CREATOR]
    CREATEDAT,    -- Created On [ICA_TIMESTAMP_C]
    CHANGEDBY,    -- Changed By [ICA_MODIFIER]
    CHANGEDAT,    -- Changed On [ICA_TIMESTAMP_M]
    PRIMARY KEY (RCLNT, METHOD_ID, DOCNR)
);

Learn More