RECON

Transparent Table Application Table
27 Fields 1 CDS Views

Document Item: Item of Consignment Settlement

RECON is an SAP database table in S/4HANA. Document Item: Item of Consignment Settlement. It contains 27 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_SuplrInvcItemConsignment view from BASIC Consignment Settlement Item

Fields (27)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY belnr RE_BELNR Inv. Doc. No.
KEY gjahr GJAHR Fiscal Year
KEY buzei RBLGP Item
mblnr MBLNR Material Doc.
mjahr MJAHR Mat. Doc. Year
mblpo MBLPO Mat. Doc.Item
matnr MATNR Material
bukrs BUKRS Company Code
werks WERKS_D Plant
wrbtr WRBTR_CS Amount
shkzg SHKZG Debit/Credit
mwskz MWSKZ Tax Code
txjcd TXJCD Tax Jur.
menge MENGE_D Quantity
meins MEINS Base Unit
gsber GSBER Business Area
saknr SAKNR G/L Account
prctr PRCTR Profit Center
spgrs SPGRS Blkg Reas. Amount
dummy_mmiv_si_s_item_eew_ps MMIV_SI_S_ITEM_INCL_EEW Dummy
txdat TXDAT Tax Date
txdat_from FOT_TXDAT_FROM Tax Rate Valid-From
tax_country FOT_TAX_COUNTRY Tax Ctry/Reg.
node_key MRM_SI_GUID GUID
parent_key MRM_SI_GUID GUID
root_key MRM_SI_GUID GUID

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.

-- Document Item: Item of Consignment Settlement
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE RECON (
    MANDT,                        -- Client [MANDT]
    BELNR,                        -- Inv. Doc. No. [RE_BELNR]
    GJAHR,                        -- Fiscal Year [GJAHR]
    BUZEI,                        -- Item [RBLGP]
    MBLNR,                        -- Material Doc. [MBLNR]
    MJAHR,                        -- Mat. Doc. Year [MJAHR]
    MBLPO,                        -- Mat. Doc.Item [MBLPO]
    MATNR,                        -- Material [MATNR]
    BUKRS,                        -- Company Code [BUKRS]
    WERKS,                        -- Plant [WERKS_D]
    WRBTR,                        -- Amount [WRBTR_CS]
    SHKZG,                        -- Debit/Credit [SHKZG]
    MWSKZ,                        -- Tax Code [MWSKZ]
    TXJCD,                        -- Tax Jur. [TXJCD]
    MENGE,                        -- Quantity [MENGE_D]
    MEINS,                        -- Base Unit [MEINS]
    GSBER,                        -- Business Area [GSBER]
    SAKNR,                        -- G/L Account [SAKNR]
    PRCTR,                        -- Profit Center [PRCTR]
    SPGRS,                        -- Blkg Reas. Amount [SPGRS]
    DUMMY_MMIV_SI_S_ITEM_EEW_PS,  -- Dummy [MMIV_SI_S_ITEM_INCL_EEW]
    TXDAT,                        -- Tax Date [TXDAT]
    TXDAT_FROM,                   -- Tax Rate Valid-From [FOT_TXDAT_FROM]
    TAX_COUNTRY,                  -- Tax Ctry/Reg. [FOT_TAX_COUNTRY]
    NODE_KEY,                     -- GUID [MRM_SI_GUID]
    PARENT_KEY,                   -- GUID [MRM_SI_GUID]
    ROOT_KEY,                     -- GUID [MRM_SI_GUID]
    PRIMARY KEY (MANDT, BELNR, GJAHR, BUZEI)
);

Learn More