CIM_D_TAXSUMS

Transparent Table Application Table
23 Fields 1 CDS Views

Invoice Tax

CIM_D_TAXSUMS is an SAP database table in S/4HANA. Invoice Tax. It contains 23 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_PrmtHbRpldSupplierInvoiceTax view from BASIC Procurement Hub Supplier Invoice Tax

Fields (23)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY prmthbrpldsuplrinvctaxuuid CIM_UUID UUID
prmthbrpldsupplierinvoiceuuid CIM_UUID UUID
prmthbrpldsupplierinvoice RE_BELNR Inv. Doc. No.
prmthbrpldsuplrinvcfiscalyear GJAHR Fiscal Year
procmthubcompanycode BUKRS Company Code
procmthubtaxcode MWSKZ_MRM Tax Code
supplierinvoicetaxcounter RBLGP Item
taxamount CIM_FWSTEV Tax Amount
suplrinvcautomreducedamount CIM_ARKUEN Reduced Amount
suplrinvcautomreductiontaxamt CIM_ARKUEMW Tax Inv. Reduction
taxbaseamountintranscrcy FWBAS_BSES Base Amount
taxamountincocodecrcy HWSTE LC Tax
taxbaseamountincocodecrcy HWBAS_BSES LC Base
taxresultmanualmodification TAX_MOD Tax Modified
prmthbtaxjurisdiction TXJCD Tax Jur.
prmthblowestlvltaxjurisdiction TXJCD_DEEP Jurisdict. Code
prmthbconditiontype KSCHL Condition Type
taxitemgroup TAXPS Tax doc. item number
taxdeterminationdate TXDAT Tax Date
taxcodevalidfrom FOT_TXDAT_FROM Tax Rate Valid-From
procmthubdocumentcurrency CIM_WAERS Currency Key
prmthbcompanycodecurrency CIM_HWAER Local Currency

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.

-- Invoice Tax
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CIM_D_TAXSUMS (
    MANDT,                           -- Client [MANDT]
    PRMTHBRPLDSUPLRINVCTAXUUID,      -- UUID [CIM_UUID]
    PRMTHBRPLDSUPPLIERINVOICEUUID,   -- UUID [CIM_UUID]
    PRMTHBRPLDSUPPLIERINVOICE,       -- Inv. Doc. No. [RE_BELNR]
    PRMTHBRPLDSUPLRINVCFISCALYEAR,   -- Fiscal Year [GJAHR]
    PROCMTHUBCOMPANYCODE,            -- Company Code [BUKRS]
    PROCMTHUBTAXCODE,                -- Tax Code [MWSKZ_MRM]
    SUPPLIERINVOICETAXCOUNTER,       -- Item [RBLGP]
    TAXAMOUNT,                       -- Tax Amount [CIM_FWSTEV]
    SUPLRINVCAUTOMREDUCEDAMOUNT,     -- Reduced Amount [CIM_ARKUEN]
    SUPLRINVCAUTOMREDUCTIONTAXAMT,   -- Tax Inv. Reduction [CIM_ARKUEMW]
    TAXBASEAMOUNTINTRANSCRCY,        -- Base Amount [FWBAS_BSES]
    TAXAMOUNTINCOCODECRCY,           -- LC Tax [HWSTE]
    TAXBASEAMOUNTINCOCODECRCY,       -- LC Base [HWBAS_BSES]
    TAXRESULTMANUALMODIFICATION,     -- Tax Modified [TAX_MOD]
    PRMTHBTAXJURISDICTION,           -- Tax Jur. [TXJCD]
    PRMTHBLOWESTLVLTAXJURISDICTION,  -- Jurisdict. Code [TXJCD_DEEP]
    PRMTHBCONDITIONTYPE,             -- Condition Type [KSCHL]
    TAXITEMGROUP,                    -- Tax doc. item number [TAXPS]
    TAXDETERMINATIONDATE,            -- Tax Date [TXDAT]
    TAXCODEVALIDFROM,                -- Tax Rate Valid-From [FOT_TXDAT_FROM]
    PROCMTHUBDOCUMENTCURRENCY,       -- Currency Key [CIM_WAERS]
    PRMTHBCOMPANYCODECURRENCY,       -- Local Currency [CIM_HWAER]
    PRIMARY KEY (MANDT, PRMTHBRPLDSUPLRINVCTAXUUID)
);

Learn More