BSE_CLR

Transparent Table Application Table
38 Fields 4 CDS Views

Zusatzdaten zum Belegsegment: Ausgleichsinformation

BSE_CLR is an SAP database table in S/4HANA. Zusatzdaten zum Belegsegment: Ausgleichsinformation. It contains 38 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
FINOC_SPL_DC_CLR view inner OrgChange: Documents to be reconstructed
I_ClrgInfoRelationForAcctgDoc view from BASIC Clearing Information for Accounting
I_OplAcctgDocItemClrgHist view_entity from BASIC Accounting Doc Item Clearing History
P_JrnlEntrAddlClrgInformation view from CONSUMPTION Clearing Information for MX

Fields (38)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY bukrs_clr bukrs Company Code
KEY belnr_clr belnr_d Document Number
KEY gjahr_clr gjahr Fiscal Year
KEY index_clr index_clr Clrg Info Seq. No.
agzei agzei Clearing Item
agbuz buzei Item
waers waers Currency
clrin clrinf Type of Clearing in Table AUSZ_CLR
bukrs bukrs Company Code
belnr belnr_d Document Number
gjahr gjahr Fiscal Year
buzei buzei Item
shkzg shkzg Debit/Credit
dmbtr dmbtr Amount in LC
dmbe2 dmbe2 LC2 Amount
dmbe3 dmbe3 LC3 Amount
wrbtr wrbtr Amount
difhw difhw Difference
difh2 difh2 Difference
difh3 difh3 Difference
diffw diffw Difference
sknto sknto Discount Amt
sknt2 sknt2 CD Amt LC2
sknt3 sknt3 CD Amt LC3
wskto wskto CD Amount
bdiff bdiff Valuation Diff.
bdif2 bdif2 Valuation Diff. 2
bdif3 bdif3 Valuation Diff. 3
rdiff rdiff Diff. Realized
rdif2 rdif2 Diff.Realized 2
rdif3 rdif3 Diff.Realized 3
koart koart Account type
umskz umskz Special G/L Ind
qbshb qbshb Withholding Tax
waers_op waers_op Currency OI
wskto_op wskto_op CashDsctOI
_dataaging data_temperature Data Aging

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.

-- Zusatzdaten zum Belegsegment: Ausgleichsinformation
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE BSE_CLR (
    MANDT,       -- Client [mandt]
    BUKRS_CLR,   -- Company Code [bukrs]
    BELNR_CLR,   -- Document Number [belnr_d]
    GJAHR_CLR,   -- Fiscal Year [gjahr]
    INDEX_CLR,   -- Clrg Info Seq. No. [index_clr]
    AGZEI,       -- Clearing Item [agzei]
    AGBUZ,       -- Item [buzei]
    WAERS,       -- Currency [waers]
    CLRIN,       -- Type of Clearing in Table AUSZ_CLR [clrinf]
    BUKRS,       -- Company Code [bukrs]
    BELNR,       -- Document Number [belnr_d]
    GJAHR,       -- Fiscal Year [gjahr]
    BUZEI,       -- Item [buzei]
    SHKZG,       -- Debit/Credit [shkzg]
    DMBTR,       -- Amount in LC [dmbtr]
    DMBE2,       -- LC2 Amount [dmbe2]
    DMBE3,       -- LC3 Amount [dmbe3]
    WRBTR,       -- Amount [wrbtr]
    DIFHW,       -- Difference [difhw]
    DIFH2,       -- Difference [difh2]
    DIFH3,       -- Difference [difh3]
    DIFFW,       -- Difference [diffw]
    SKNTO,       -- Discount Amt [sknto]
    SKNT2,       -- CD Amt LC2 [sknt2]
    SKNT3,       -- CD Amt LC3 [sknt3]
    WSKTO,       -- CD Amount [wskto]
    BDIFF,       -- Valuation Diff. [bdiff]
    BDIF2,       -- Valuation Diff. 2 [bdif2]
    BDIF3,       -- Valuation Diff. 3 [bdif3]
    RDIFF,       -- Diff. Realized [rdiff]
    RDIF2,       -- Diff.Realized 2 [rdif2]
    RDIF3,       -- Diff.Realized 3 [rdif3]
    KOART,       -- Account type [koart]
    UMSKZ,       -- Special G/L Ind [umskz]
    QBSHB,       -- Withholding Tax [qbshb]
    WAERS_OP,    -- Currency OI [waers_op]
    WSKTO_OP,    -- CashDsctOI [wskto_op]
    _DATAAGING,  -- Data Aging [data_temperature]
    PRIMARY KEY (MANDT, BUKRS_CLR, BELNR_CLR, GJAHR_CLR, INDEX_CLR)
);

Learn More