_BANK

_BANK is an SAP database table in S/4HANA. It contains 33 fields.

Fields (33)

KeyField CDS FieldsUsed in Views
KEY BankCountry BankCountry 2
KEY BankInternalID BankInternalID,CashBankKeyForDisplay 3
_Address _Address 1
AddressID AddressID,BankAddressID 3
AddressRegion AddressRegion 2
Bank Bank,BankKey,BankNumber,DomesticBankkey 7
banka BankName 1
BankAddressIsHidden BankAddressIsHidden 1
BankBranch BankBranch 5
BankCategory BankCategory 2
BankIsInternal BankIsInternal 1
BankIsStandard BankIsStandard 1
BankName BankName,HouseBankName,PayeeBankName 49
BankNetworkGrouping BankGroup,BankNetworkGrouping 3
BankNetworkGroupingIsHidden BankNetworkGroupingIsHidden 1
BankNumber BankNumber 2
BankNumberIsHidden BankNumberIsHidden 1
BankScriptedAddressIsHidden BankScriptedAddressIsHidden 1
Branch Branch 3
CityName CityName 8
CreatedByUser CreatedByUser 1
IsMarkedForDeletion IsMarkedForDeletion 2
LastChangeDateTime LastChangeDateTime 1
LongBankBranch LongBankBranch 2
LongBankBranchIsHidden LongBankBranchIsHidden 1
LongBankName BankName,LongBankName 6
Region Region 4
ShortCityName ShortCityName 4
ShortStreetName ShortStreetName 4
StreetName StreetName 4
swift SWIFTCode 1
SWIFTCode SwiftBic,SWIFTCode 16
SWIFTCodeIsHidden SWIFTCodeIsHidden 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE _BANK (
    BANKCOUNTRY,
    BANKINTERNALID,
    _ADDRESS,
    ADDRESSID,
    ADDRESSREGION,
    BANK,
    BANKA,
    BANKADDRESSISHIDDEN,
    BANKBRANCH,
    BANKCATEGORY,
    BANKISINTERNAL,
    BANKISSTANDARD,
    BANKNAME,
    BANKNETWORKGROUPING,
    BANKNETWORKGROUPINGISHIDDEN,
    BANKNUMBER,
    BANKNUMBERISHIDDEN,
    BANKSCRIPTEDADDRESSISHIDDEN,
    BRANCH,
    CITYNAME,
    CREATEDBYUSER,
    ISMARKEDFORDELETION,
    LASTCHANGEDATETIME,
    LONGBANKBRANCH,
    LONGBANKBRANCHISHIDDEN,
    LONGBANKNAME,
    REGION,
    SHORTCITYNAME,
    SHORTSTREETNAME,
    STREETNAME,
    SWIFT,
    SWIFTCODE,
    SWIFTCODEISHIDDEN,
    PRIMARY KEY (BANKCOUNTRY, BANKINTERNALID)
);