BUT0ID

Transparent Table Application Table

GP: Identifikationsnummern

BUT0ID is an SAP database table in S/4HANA. GP: Identifikationsnummern. It contains 4 fields. 13 CDS views read from this table.

CDS Views using this table (13)

ViewTypeJoinVDMDescription
/BOFU/CV_Q_BPIdentification view_entity left_outer BOPF: BP Query on Identification
/BOFU/VE_BPID view_entity from BOPF: Business Partner Identification
FNDEI_BUT0ID_BLOCKINGINFO view from Filter View for table BUT0ID
FNDEI_BUT0ID_FILTER view from Filter View for table BUT0ID
I_BPUsrExternalID view_entity from BASIC Business Partner External ID (BUM)
I_BuPaIdentification view_entity from BASIC Business Partner Identification
I_Employee view inner BASIC Employee
I_EmployeeOp view inner BASIC Employee CDS view for OP
P_EmployeeCl view inner BASIC Employee view for Cloud
P_N_Employee view left_outer BASIC Employee
P_N_EmployeeOp view inner BASIC Employee view for OnPremise
P_O_EmployeeOp view left_outer BASIC Employee view for OnPremise
R_BPIdentificationNumber view_entity from BASIC BP: Identification Numbers

Fields (4)

KeyField Data ElementDescription DomainTypeLength
KEY client mandt Client
KEY partner bu_partner Busn. Partner
KEY type bu_id_type ID Type
KEY idnumber bu_id_number ID Number

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.

-- GP: Identifikationsnummern
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE BUT0ID (
    CLIENT,    -- Client [mandt]
    PARTNER,   -- Busn. Partner [bu_partner]
    TYPE,      -- ID Type [bu_id_type]
    IDNUMBER,  -- ID Number [bu_id_number]
    PRIMARY KEY (CLIENT, PARTNER, TYPE, IDNUMBER)
);