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