ACDOCA_HXF

Transparent Table Application Table
19 Fields 1 CDS Views

Historical exchange rates: T2Factors used in journal entries

ACDOCA_HXF is an SAP database table in S/4HANA. Historical exchange rates: T2Factors used in journal entries. It contains 19 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_JrnlEntrAltvCrcyTrnsltnItem view from BASIC T2Factors used in journal entries

Fields (19)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY bukrs bukrs Company Code
KEY belnr belnr_d Document Number
KEY gjahr gjahr Fiscal Year
KEY item_number fin_hxf_item_number Item Number
t2ccode_crcy_conv_factor fins_t2ccode_crcy_conv_factor Tax Amt Fctr in LC
t2cntry_crcy_conv_factor fins_t2cntry_crcy_conv_factor Tax Amt Fctr in RC
fbuda fbuda Serv. Rend. Dte
prec_awref fins_prec_awref PrecRefDocument
prec_awitem fins_prec_awitem Prec. Ref. Doc. Item
ccode_factor_method fin_hxf_cocode_method Co. Cd. Fctr. Method
cntry_factor_method fin_hxf_country_method Country Fctr. Method
tax_country fot_tax_country Tax Ctry/Reg.
tax_code mwskz Tax Code
tax_rt_valid_from fot_txdat_from Tax Rate Valid-From
taxjurcode txjcd Tax Jur.
posnr_sd posnr Item
ccode_exchg_rate fin_hxf_cocode_exchg_rate Tax Exch. Rate in LC
cntry_exchg_rate fin_hxf_country_exchg_rate Tax Exch. Rate in RC

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.

-- Historical exchange rates: T2Factors used in journal entries
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ACDOCA_HXF (
    MANDT,                     -- Client [mandt]
    BUKRS,                     -- Company Code [bukrs]
    BELNR,                     -- Document Number [belnr_d]
    GJAHR,                     -- Fiscal Year [gjahr]
    ITEM_NUMBER,               -- Item Number [fin_hxf_item_number]
    T2CCODE_CRCY_CONV_FACTOR,  -- Tax Amt Fctr in LC [fins_t2ccode_crcy_conv_factor]
    T2CNTRY_CRCY_CONV_FACTOR,  -- Tax Amt Fctr in RC [fins_t2cntry_crcy_conv_factor]
    FBUDA,                     -- Serv. Rend. Dte [fbuda]
    PREC_AWREF,                -- PrecRefDocument [fins_prec_awref]
    PREC_AWITEM,               -- Prec. Ref. Doc. Item [fins_prec_awitem]
    CCODE_FACTOR_METHOD,       -- Co. Cd. Fctr. Method [fin_hxf_cocode_method]
    CNTRY_FACTOR_METHOD,       -- Country Fctr. Method [fin_hxf_country_method]
    TAX_COUNTRY,               -- Tax Ctry/Reg. [fot_tax_country]
    TAX_CODE,                  -- Tax Code [mwskz]
    TAX_RT_VALID_FROM,         -- Tax Rate Valid-From [fot_txdat_from]
    TAXJURCODE,                -- Tax Jur. [txjcd]
    POSNR_SD,                  -- Item [posnr]
    CCODE_EXCHG_RATE,          -- Tax Exch. Rate in LC [fin_hxf_cocode_exchg_rate]
    CNTRY_EXCHG_RATE,          -- Tax Exch. Rate in RC [fin_hxf_country_exchg_rate]
    PRIMARY KEY (MANDT, BUKRS, BELNR, GJAHR, ITEM_NUMBER)
);

Learn More