BNK_BTCH_STREF

Transparent Table Application Table
10 Fields 1 CDS Views

Status reference

BNK_BTCH_STREF is an SAP database table in S/4HANA. Status reference. It contains 10 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_BankPaytIncgStatusRef view from BASIC Incg Status Reference of Bank Payments

Fields (10)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY stref_guid bnk_com_stref_guid St. Ref.ID
ref_guid bnk_com_stref_id St. Ref.ID
ref_type bnk_com_ref_type Ref. Type
batch_no bnk_com_btch_no Batch Number
item_no bnk_com_btch_cnt Item Number
ref_id bnk_com_ref_id Ref. ID
crusr bnk_com_create_user CreateUser
crdat bnk_com_create_date Create Date
crtim bnk_com_create_time Create Time

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.

-- Status reference
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE BNK_BTCH_STREF (
    MANDT,       -- Client [mandt]
    STREF_GUID,  -- St. Ref.ID [bnk_com_stref_guid]
    REF_GUID,    -- St. Ref.ID [bnk_com_stref_id]
    REF_TYPE,    -- Ref. Type [bnk_com_ref_type]
    BATCH_NO,    -- Batch Number [bnk_com_btch_no]
    ITEM_NO,     -- Item Number [bnk_com_btch_cnt]
    REF_ID,      -- Ref. ID [bnk_com_ref_id]
    CRUSR,       -- CreateUser [bnk_com_create_user]
    CRDAT,       -- Create Date [bnk_com_create_date]
    CRTIM,       -- Create Time [bnk_com_create_time]
    PRIMARY KEY (MANDT, STREF_GUID)
);

Learn More