BUPA_BANK_D_2

Transparent Table Application Table
39 Fields 1 CDS Views

Draft table for entity I_BUSINESSPARTNERBANKTP_2

BUPA_BANK_D_2 is an SAP database table in S/4HANA. Draft table for entity I_BUSINESSPARTNERBANKTP_2. It contains 39 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_BusinessPartnerBankDraft view_entity from BASIC Business Partner Bank-Draft

Fields (39)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY businesspartner bu_partner Busn. Partner
KEY bankidentification bu_bkvid Bank Details
KEY draftuuid sdraft_uuid Draft Document ID
parentdraftuuid sdraft_uuid Draft Document ID
bankidnforeditvalue bu_bkvid Bank Details
bankcountrykey bu_banks Bank Ctry/Reg.
bankname banka Bank Name
banknumber bu_bankk Bank Key
swiftcode swift SWIFT/BIC
bankcontrolkey bu_bkont Control Key
bankaccountholdername bu_koinh Account Holder
bankaccountname bu_bankaccname Account Name
bankvaliditystartdate abap.dats
bankvalidityenddate abap.dats
iban iban IBAN
ibanvaliditystartdate iban_valfr IBAN Valid From
bankaccount bu_bankn Bank acct
bankaccountreferencetext bu_bkref Reference
collectionauthind bu_xezer Collect.author.
businesspartnerexternalbankid bu_bkext Extern.bank ID
bpbankdetailschangedate bu_bk_move_date Date of Change
bpbankdetailschangetargetid bu_move_bkvid Target Details
bpbankisprotected bu_protected Sensitivity
cityname ort01_gp City
authorizationgroup bu_augrp Authorization Group
bphasactiveentity sdraft_is_active Is active
isbusinesspurposecompleted bu_xpcpt Purpose Completed
datacontrollerset bu_xdcset Data Ctrlr. Set
datacontroller1 bu_data_controller Data Controller
datacontroller2 bu_data_controller Data Controller
datacontroller3 bu_data_controller Data Controller
datacontroller4 bu_data_controller Data Controller
datacontroller5 bu_data_controller Data Controller
datacontroller6 bu_data_controller Data Controller
datacontroller7 bu_data_controller Data Controller
datacontroller8 bu_data_controller Data Controller
datacontroller9 bu_data_controller Data Controller
datacontroller10 bu_data_controller Data Controller

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.

-- Draft table for entity I_BUSINESSPARTNERBANKTP_2
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE BUPA_BANK_D_2 (
    MANDT,                          -- Client [mandt]
    BUSINESSPARTNER,                -- Busn. Partner [bu_partner]
    BANKIDENTIFICATION,             -- Bank Details [bu_bkvid]
    DRAFTUUID,                      -- Draft Document ID [sdraft_uuid]
    PARENTDRAFTUUID,                -- Draft Document ID [sdraft_uuid]
    BANKIDNFOREDITVALUE,            -- Bank Details [bu_bkvid]
    BANKCOUNTRYKEY,                 -- Bank Ctry/Reg. [bu_banks]
    BANKNAME,                       -- Bank Name [banka]
    BANKNUMBER,                     -- Bank Key [bu_bankk]
    SWIFTCODE,                      -- SWIFT/BIC [swift]
    BANKCONTROLKEY,                 -- Control Key [bu_bkont]
    BANKACCOUNTHOLDERNAME,          -- Account Holder [bu_koinh]
    BANKACCOUNTNAME,                -- Account Name [bu_bankaccname]
    BANKVALIDITYSTARTDATE,          -- abap.dats
    BANKVALIDITYENDDATE,            -- abap.dats
    IBAN,                           -- IBAN [iban]
    IBANVALIDITYSTARTDATE,          -- IBAN Valid From [iban_valfr]
    BANKACCOUNT,                    -- Bank acct [bu_bankn]
    BANKACCOUNTREFERENCETEXT,       -- Reference [bu_bkref]
    COLLECTIONAUTHIND,              -- Collect.author. [bu_xezer]
    BUSINESSPARTNEREXTERNALBANKID,  -- Extern.bank ID [bu_bkext]
    BPBANKDETAILSCHANGEDATE,        -- Date of Change [bu_bk_move_date]
    BPBANKDETAILSCHANGETARGETID,    -- Target Details [bu_move_bkvid]
    BPBANKISPROTECTED,              -- Sensitivity [bu_protected]
    CITYNAME,                       -- City [ort01_gp]
    AUTHORIZATIONGROUP,             -- Authorization Group [bu_augrp]
    BPHASACTIVEENTITY,              -- Is active [sdraft_is_active]
    ISBUSINESSPURPOSECOMPLETED,     -- Purpose Completed [bu_xpcpt]
    DATACONTROLLERSET,              -- Data Ctrlr. Set [bu_xdcset]
    DATACONTROLLER1,                -- Data Controller [bu_data_controller]
    DATACONTROLLER2,                -- Data Controller [bu_data_controller]
    DATACONTROLLER3,                -- Data Controller [bu_data_controller]
    DATACONTROLLER4,                -- Data Controller [bu_data_controller]
    DATACONTROLLER5,                -- Data Controller [bu_data_controller]
    DATACONTROLLER6,                -- Data Controller [bu_data_controller]
    DATACONTROLLER7,                -- Data Controller [bu_data_controller]
    DATACONTROLLER8,                -- Data Controller [bu_data_controller]
    DATACONTROLLER9,                -- Data Controller [bu_data_controller]
    DATACONTROLLER10,               -- Data Controller [bu_data_controller]
    PRIMARY KEY (MANDT, BUSINESSPARTNER, BANKIDENTIFICATION, DRAFTUUID)
);

Learn More