BSE_CLR

Transparent Table Application Table
39 Fields 11 CDS Views

Additional Data for Document Segment: Clearing Information

BSE_CLR is an SAP database table in S/4HANA. Additional Data for Document Segment: Clearing Information. It contains 39 fields. 11 CDS views read from this table.

CDS Views using this table (11)

ViewTypeJoinVDMDescription
finoc_spl_dc_clearing view_entity from OrgChange: Select Clearing Information
finoc_spl_dc_clearing view_entity union_all OrgChange: Select Clearing Information
FINOC_SPL_DC_CLR view inner OrgChange: Documents to be reconstructed
fins_cnv_rec_bcbs view_entity inner LCC: REconcile BSE_CLR with BSEG
fins_cnv_rec_bcbs_nri view_entity from LCC: Select non-relevant clearings
fins_cnv_rec_bcbs_ri view_entity from LCC: Select all relevant cleared items
fins_cnv_rec_clr_ri view from LCC: Select all relevant cleared JE
fins_cnv_rec_clr_ri view union_all LCC: Select all relevant cleared JE
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

Fields (39)

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
uzawe UZAWE Pmnt Meth. Sup.
_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.

-- Additional Data for Document Segment: Clearing Information
-- 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]
    UZAWE,       -- Pmnt Meth. Sup. [UZAWE]
    _DATAAGING,  -- Data Aging [DATA_TEMPERATURE]
    PRIMARY KEY (MANDT, BUKRS_CLR, BELNR_CLR, GJAHR_CLR, INDEX_CLR)
);

Learn More