BUT0ID

Transparent Table Application Table
12 Fields 13 CDS Views

BP: ID Numbers

BUT0ID is an SAP database table in S/4HANA. BP: ID Numbers. It contains 12 fields. 13 CDS views read from this table.

CDS Views using this table (13)

ViewTypeJoinVDMDescription
/BOFU/CV_BPIdentification view from BOPF: /BOFU/BuPa Node Identification
/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_EmployeeOp view inner BASIC Employee CDS view for OP
I_HCMEmployeeAddressBook view inner Employee Address Book
P_EmployeeCl view inner BASIC
P_N_Employee view left_outer BASIC
P_N_EmployeeOp view left_outer BASIC
P_O_EmployeeOp view left_outer BASIC

Fields (12)

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
institute BU_ID_INSTITUTE Institution
entry_date BU_ID_ENTRY_DATE Entry date
valid_date_from BU_ID_VALID_DATE_FROM Valid from
valid_date_to BU_ID_VALID_DATE_TO Valid To
country BU_IDCOUNTRY Country/Region
region REGIO Region
idnumber_guid BU_ID_GUID ID GUID
bp_eew_but0id DUMMY Dummy function in length 1

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.

-- BP: ID Numbers
-- 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]
    INSTITUTE,        -- Institution [BU_ID_INSTITUTE]
    ENTRY_DATE,       -- Entry date [BU_ID_ENTRY_DATE]
    VALID_DATE_FROM,  -- Valid from [BU_ID_VALID_DATE_FROM]
    VALID_DATE_TO,    -- Valid To [BU_ID_VALID_DATE_TO]
    COUNTRY,          -- Country/Region [BU_IDCOUNTRY]
    REGION,           -- Region [REGIO]
    IDNUMBER_GUID,    -- ID GUID [BU_ID_GUID]
    BP_EEW_BUT0ID,    -- Dummy function in length 1 [DUMMY]
    PRIMARY KEY (CLIENT, PARTNER, TYPE, IDNUMBER)
);

Learn More