_BANK

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

Fields (33)

KeyField CDS FieldsUsed in Views
_Address _Address 1
AddressID AddressID,BankAddressID 3
AddressRegion AddressRegion 2
Bank Bank,BankKey,BankNumber,DomesticBankkey 6
banka BankName 1
BankAddressIsHidden BankAddressIsHidden 1
BankBranch BankBranch 3
BankCategory BankCategory 1
BankGroup BankGroup 1
BankIdentification BankIdentification 1
BankInternalID CashBankKeyForDisplay 1
BankIsInternal BankIsInternal 1
BankIsStandard BankIsStandard 1
BankName BankName,HouseBankName,PayeeBankName 47
BankNetworkGrouping 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 2
ShortCityName ShortCityName 2
ShortStreetName ShortStreetName 2
StreetName StreetName 4
SWIFTCode SwiftBic,SWIFTCode 15
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 (
    _ADDRESS,
    ADDRESSID,
    ADDRESSREGION,
    BANK,
    BANKA,
    BANKADDRESSISHIDDEN,
    BANKBRANCH,
    BANKCATEGORY,
    BANKGROUP,
    BANKIDENTIFICATION,
    BANKINTERNALID,
    BANKISINTERNAL,
    BANKISSTANDARD,
    BANKNAME,
    BANKNETWORKGROUPING,
    BANKNETWORKGROUPINGISHIDDEN,
    BANKNUMBER,
    BANKNUMBERISHIDDEN,
    BANKSCRIPTEDADDRESSISHIDDEN,
    BRANCH,
    CITYNAME,
    CREATEDBYUSER,
    ISMARKEDFORDELETION,
    LASTCHANGEDATETIME,
    LONGBANKBRANCH,
    LONGBANKBRANCHISHIDDEN,
    LONGBANKNAME,
    REGION,
    SHORTCITYNAME,
    SHORTSTREETNAME,
    STREETNAME,
    SWIFTCODE,
    SWIFTCODEISHIDDEN
);