SAFT_PTC_TAX

Transparent Table Customizing Table
12 Fields 3 CDS Views

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)
);

Learn More