BSET

Transparent Table Application Table
43 Fields 9 CDS Views

Tax Data Document Segment

BSET is an SAP database table in S/4HANA. Tax Data Document Segment. It contains 43 fields. 9 CDS views read from this table.

CDS Views using this table (9)

ViewTypeJoinVDMDescription
FACVD_RJET_WLI_05 view left_outer Retrieve Tax for recurring entries
FISVD_ETXMISSFROMBSET view from External tax tables missing from BSET
I_AcctgDocItmForChgDoc view inner BASIC Accounting Documents
I_GLJrnlEntryTaxItem view union_all BASIC I View for Tax Item in Verify GJE
I_RO_SAFTPurInvoiceTaxAmount view from BASIC RO SAFT Purchase Invoice Tax Amount
P_Bset view from BASIC
P_RU_BSET view from BASIC
P_TaxRecon12 view from BASIC
P_TaxRegisterIndirectTaxItem view from BASIC

Fields (43)

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 buzei BUZEI Item
tax_country FOT_TAX_COUNTRY Tax Ctry/Reg.
mwskz MWSKZ Tax Code
txdat_from FOT_TXDAT_FROM Tax Rate Valid-From
hkont HKONT G/L Acct
txgrp TXGRP Group Indicator
shkzg SHKZG Debit/Credit
hwbas HWBAS_BSES LC Base
fwbas FWBAS_BSES Base Amount
hwste HWSTE LC Tax
fwste FWSTE Amount
ktosl KTOSL Transaction
knumh KNUMH Cond.Record No.
stceg STCEG VAT Reg. No.
egbld EGBLD Dest. C/R
eglld EGLLD Supplying C/R
txjcd TXJCD Tax Jur.
h2ste H2STE LC 2 Tax
h3ste H3STE LC 3 Tax
h2bas H2BAS_BSES LC 2 Base
h3bas H3BAS_BSES LC 3 Base
kschl KSCHL Condition Type
stmdt STMDT_BSET Return On
stmti STMTI_BSET Return At
mlddt MLDDT_BSET Reporting Date
kbetr KBETR_TAX Percent
stbkz STBKZ_007B Posting indic.
lstml LAND1_STML Reporting C/R
lwste LWSTE_BSET Tax Rept. Crcy
lwbas LWBAS_BSET Base Amount
txdat TXDAT Tax Date
bupla BUPLA Business place
txjdp TXJCD_DEEP Jurisdict. Code
txjlv TXJCD_LEVEL Jurisdiction level
taxps TAX_POSNR Tax doc. item number
txmod TAX_MOD Tax Modified
_dataaging DATA_TEMPERATURE Data Aging
fiwtin_chn FIWTIN_CHN Challan Number
fiwtin_chd FIWTIN_CHD Challan Date

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.

-- Tax Data Document Segment
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE BSET (
    MANDT,        -- Client [MANDT]
    BUKRS,        -- Company Code [BUKRS]
    BELNR,        -- Document Number [BELNR_D]
    GJAHR,        -- Fiscal Year [GJAHR]
    BUZEI,        -- Item [BUZEI]
    TAX_COUNTRY,  -- Tax Ctry/Reg. [FOT_TAX_COUNTRY]
    MWSKZ,        -- Tax Code [MWSKZ]
    TXDAT_FROM,   -- Tax Rate Valid-From [FOT_TXDAT_FROM]
    HKONT,        -- G/L Acct [HKONT]
    TXGRP,        -- Group Indicator [TXGRP]
    SHKZG,        -- Debit/Credit [SHKZG]
    HWBAS,        -- LC Base [HWBAS_BSES]
    FWBAS,        -- Base Amount [FWBAS_BSES]
    HWSTE,        -- LC Tax [HWSTE]
    FWSTE,        -- Amount [FWSTE]
    KTOSL,        -- Transaction [KTOSL]
    KNUMH,        -- Cond.Record No. [KNUMH]
    STCEG,        -- VAT Reg. No. [STCEG]
    EGBLD,        -- Dest. C/R [EGBLD]
    EGLLD,        -- Supplying C/R [EGLLD]
    TXJCD,        -- Tax Jur. [TXJCD]
    H2STE,        -- LC 2 Tax [H2STE]
    H3STE,        -- LC 3 Tax [H3STE]
    H2BAS,        -- LC 2 Base [H2BAS_BSES]
    H3BAS,        -- LC 3 Base [H3BAS_BSES]
    KSCHL,        -- Condition Type [KSCHL]
    STMDT,        -- Return On [STMDT_BSET]
    STMTI,        -- Return At [STMTI_BSET]
    MLDDT,        -- Reporting Date [MLDDT_BSET]
    KBETR,        -- Percent [KBETR_TAX]
    STBKZ,        -- Posting indic. [STBKZ_007B]
    LSTML,        -- Reporting C/R [LAND1_STML]
    LWSTE,        -- Tax Rept. Crcy [LWSTE_BSET]
    LWBAS,        -- Base Amount [LWBAS_BSET]
    TXDAT,        -- Tax Date [TXDAT]
    BUPLA,        -- Business place [BUPLA]
    TXJDP,        -- Jurisdict. Code [TXJCD_DEEP]
    TXJLV,        -- Jurisdiction level [TXJCD_LEVEL]
    TAXPS,        -- Tax doc. item number [TAX_POSNR]
    TXMOD,        -- Tax Modified [TAX_MOD]
    _DATAAGING,   -- Data Aging [DATA_TEMPERATURE]
    FIWTIN_CHN,   -- Challan Number [FIWTIN_CHN]
    FIWTIN_CHD,   -- Challan Date [FIWTIN_CHD]
    PRIMARY KEY (MANDT, BUKRS, BELNR, GJAHR, BUZEI)
);

Learn More