I_HCM_ESSBANKDATATP

CDS View
17 Fields 36 CDS Views

My Bank Data International - TP

I_HCM_ESSBANKDATATP is a CDS View in S/4HANA. My Bank Data International - TP. It contains 17 fields. 36 CDS views read from this table.

CDS Views using this table (36)

ViewTypeJoinVDMDescription
C_AE_HCM_ESSBankDataTP view_entity projection CONSUMPTION My Bank Data AE
C_AR_HCM_ESSBankDataTP view_entity projection CONSUMPTION My Bank Data AR
C_AT_HCM_ESSBankDataTP view_entity projection CONSUMPTION My Bank Data AT
C_AU_HCM_ESSBankDataTP view_entity projection CONSUMPTION My Bank Data AU
C_BR_HCM_ESSBankDataTP view_entity projection CONSUMPTION My Bank Data BR
C_CA_HCM_ESSBankDataTP view_entity projection CONSUMPTION My Bank Data CA
C_CN_HCM_ESSBankDataTP view_entity projection CONSUMPTION My Bank Data CN
C_DE_HCM_ESSBankDataTP view_entity projection CONSUMPTION My Bank Data DE
C_EG_HCM_ESSBankDataTP view_entity projection CONSUMPTION My Bank Data EG
C_ES_HCM_ESSBankDataTP view_entity projection CONSUMPTION My Bank Data ES
C_FI_HCM_ESSBankDataTP view_entity projection CONSUMPTION My Bank Data FI
C_FR_HCM_ESSBankDataTP view_entity projection CONSUMPTION My Bank Data FR
C_GR_HCM_ESSBankDataTP view_entity projection CONSUMPTION My Bank Data GR
C_HCM_ESSBankDataTP view_entity projection CONSUMPTION My Bank Data International
C_HK_HCM_ESSBankDataTP view_entity projection CONSUMPTION My Bank Data HK
C_ID_HCM_ESSBankDataTP view_entity projection CONSUMPTION My Bank Data ID
C_IE_HCM_ESSBankDataTP view_entity projection CONSUMPTION My Bank Data IE
C_IN_HCM_ESSBankDataTP view_entity projection CONSUMPTION My Bank Data IN
C_IT_HCM_ESSBankDataTP view_entity projection CONSUMPTION My Bank Data IT
C_KR_HCM_ESSBankDataTP view_entity projection CONSUMPTION My Bank Data KR
C_KZ_HCM_ESSBankDataTP view_entity projection CONSUMPTION My Bank Data KZ
C_MX_HCM_ESSBankDataTP view_entity projection CONSUMPTION My Bank Data MX
C_MY_HCM_ESSBankDataTP view_entity projection CONSUMPTION My Bank Data MY
C_NL_HCM_ESSBankDataTP view_entity projection CONSUMPTION My Bank Data NL
C_NO_HCM_ESSBankDataTP view_entity projection CONSUMPTION My Bank Data NO
C_PH_HCM_ESSBankDataTP view_entity projection CONSUMPTION My Bank Data PH
C_PT_HCM_ESSBankDataTP view_entity projection CONSUMPTION My Bank Data PT
C_QA_HCM_ESSBankDataTP view_entity projection CONSUMPTION My Bank Data QA
C_SA_HCM_ESSBankDataTP view_entity projection CONSUMPTION My Bank Data SA
C_SE_HCM_ESSBankDataTP view_entity projection CONSUMPTION My Bank Data SE
C_SG_HCM_ESSBankDataTP view_entity projection CONSUMPTION My Bank Data SG
C_TH_HCM_ESSBankDataTP view_entity projection CONSUMPTION My Bank Data TH
C_TR_HCM_ESSBankDataTP view_entity projection CONSUMPTION My Bank Data TR
C_TW_HCM_ESSBankDataTP view_entity projection CONSUMPTION My Bank Data TW
C_UA_HCM_ESSBankDataTP view_entity projection CONSUMPTION My Bank Data UA
I_HCMProfileBankData view_entity from TRANSACTIONAL My Profile Bank Data

Fields (17)

KeyField CDS FieldsUsed in Views
KEY EndDate EndDate 1
KEY HCMDraftSequentialNumber HCMDraftSequentialNumber 1
KEY HCMObjectIdentification HCMObjectIdentification 1
KEY HCMPersonnelNumber HCMPersonnelNumber 1
KEY HCMRecordIsLocked HCMRecordIsLocked 1
KEY HCMSequentialNumber HCMSequentialNumber 1
KEY HCMSubtype HCMSubtype 1
KEY StartDate StartDate 1
_BankCountryText _BankCountryText 1
_BankText _BankText 1
_SubtypeVisibility _SubtypeVisibility 1
BankAccount BankAccount 1
BankCountry BankCountry 1
BankNumber BankNumber 1
Currency Currency 1
HCMInternationalBankAcctNumber HCMInternationalBankAcctNumber 1
HCMValidityStartDate HCMValidityStartDate 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.

-- My Bank Data International - TP
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_HCM_ESSBANKDATATP (
    ENDDATE,
    HCMDRAFTSEQUENTIALNUMBER,
    HCMOBJECTIDENTIFICATION,
    HCMPERSONNELNUMBER,
    HCMRECORDISLOCKED,
    HCMSEQUENTIALNUMBER,
    HCMSUBTYPE,
    STARTDATE,
    _BANKCOUNTRYTEXT,
    _BANKTEXT,
    _SUBTYPEVISIBILITY,
    BANKACCOUNT,
    BANKCOUNTRY,
    BANKNUMBER,
    CURRENCY,
    HCMINTERNATIONALBANKACCTNUMBER,
    HCMVALIDITYSTARTDATE,
    PRIMARY KEY (ENDDATE, HCMDRAFTSEQUENTIALNUMBER, HCMOBJECTIDENTIFICATION, HCMPERSONNELNUMBER, HCMRECORDISLOCKED, HCMSEQUENTIALNUMBER, HCMSUBTYPE, STARTDATE)
);

Learn More