SAFT_PTC_TAX

Transparent Table Customizing Table

Map Tax code to SAF-T Tax Code

SAFT_PTC_TAX is an SAP database table in S/4HANA. Map Tax code to SAF-T Tax Code. It contains 12 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_PT_SAFTBillgMasterDataTax view_entity from BASIC Taxes from Billing Document Master Data
I_PT_SAFTTax view from BASIC SAF-T Tax
I_PT_SAFTTaxNotConfigured view from BASIC SAF-T PT get tax NS

Fields (12)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY kalsm kalsm_d Procedure
KEY mwskz mwskz Tax Code
KEY endda vim_endda Valid To
begda vim_begda Valid From
tax_descr saft_gen_description Description
country_region saft_pt_tax_country_region Tx. Ctry/Reg.
tax_type saft_pt_tax_type Tax Type
tax_code saft_pt_tax_code Tax Code
tax_exempt_code saft_pt_taxexemptioncode Tax Exempt Code
tax_exemp_cod_seq saft_pt_taxexemptioncode_seqno TxExempt.Reason
tax_amount saft_pt_tax_amount Fixed Amount

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.

-- Map Tax code to SAF-T Tax Code
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SAFT_PTC_TAX (
    MANDT,              -- Client [mandt]
    KALSM,              -- Procedure [kalsm_d]
    MWSKZ,              -- Tax Code [mwskz]
    ENDDA,              -- Valid To [vim_endda]
    BEGDA,              -- Valid From [vim_begda]
    TAX_DESCR,          -- Description [saft_gen_description]
    COUNTRY_REGION,     -- Tx. Ctry/Reg. [saft_pt_tax_country_region]
    TAX_TYPE,           -- Tax Type [saft_pt_tax_type]
    TAX_CODE,           -- Tax Code [saft_pt_tax_code]
    TAX_EXEMPT_CODE,    -- Tax Exempt Code [saft_pt_taxexemptioncode]
    TAX_EXEMP_COD_SEQ,  -- TxExempt.Reason [saft_pt_taxexemptioncode_seqno]
    TAX_AMOUNT,         -- Fixed Amount [saft_pt_tax_amount]
    PRIMARY KEY (MANDT, KALSM, MWSKZ, ENDDA)
);