I_BANKACCOUNTOPENINGREQUEST

CDS View
18 Fields 6 CDS Views

Bank Account Opening Request

I_BANKACCOUNTOPENINGREQUEST is a CDS View in S/4HANA. Bank Account Opening Request. It contains 18 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
C_BankAccountOpeningReqDrftTP view_entity from CONSUMPTION Submit Bank Account Applications
C_BankAccountOpeningReqOvw view_entity from CONSUMPTION Bank Account Applications
C_BankAccountOpeningReqWl view_entity from CONSUMPTION Approve Bank Account Applications
I_BankAccountApplicationVH view from BASIC Bank Account Application
I_BkAcctOpngReqApprvrNoReqr view from COMPOSITE Bank Account Opening Request Approvers without requestor
I_BkAcctOpngReqEmlTmpl view from COMPOSITE Email Template for Bank Account Application

Fields (18)

KeyField CDS FieldsUsed in Views
KEY BankAccountChangeRequest BankAccountChangeRequest 5
KEY BankAccountOpeningRequestUUID BankAccountOpeningRequestUUID 5
BankAccountAction BankAccountAction 3
BankAccountChangeRequestStatus BankAccountChangeRequestStatus 4
BankAccountContractType BankAccountContractType,BankAccountRequestContractType 4
BankAccountCurrency BankAccountCurrency,BankAccountRequestCurrency 4
BankAccountReqCreatedDateTime BankAccountReqCreatedDateTime 4
BankAccountReqLastChangedBy BankAccountReqLastChangedBy 4
BankAccountReqProcessedBy BankAccountReqProcessedBy 1
BankAccountRequestCreatedBy BankAccountRequestCreatedBy 4
BankAccountRequestNote BankAccountRequestNote 4
BankAcctChangeReqHeadingText BankAcctChangeReqHeadingText 5
BankAcctReqProcessedDateTime BankAcctReqProcessedDateTime 4
BankCountry BankAccountRequestBankCountry,BankCountry 4
BkAcctReqLastChgdDteTme BkAcctReqLastChgdDteTme 4
BkAcctReqLocalLastChgdDteTme BkAcctReqLocalLastChgdDteTme 2
CompanyCode BankAccountRequestCompanyCode,CompanyCode 4
IsMarkedForDeletion IsMarkedForDeletion 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.

-- Bank Account Opening Request
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_BANKACCOUNTOPENINGREQUEST (
    BANKACCOUNTCHANGEREQUEST,
    BANKACCOUNTOPENINGREQUESTUUID,
    BANKACCOUNTACTION,
    BANKACCOUNTCHANGEREQUESTSTATUS,
    BANKACCOUNTCONTRACTTYPE,
    BANKACCOUNTCURRENCY,
    BANKACCOUNTREQCREATEDDATETIME,
    BANKACCOUNTREQLASTCHANGEDBY,
    BANKACCOUNTREQPROCESSEDBY,
    BANKACCOUNTREQUESTCREATEDBY,
    BANKACCOUNTREQUESTNOTE,
    BANKACCTCHANGEREQHEADINGTEXT,
    BANKACCTREQPROCESSEDDATETIME,
    BANKCOUNTRY,
    BKACCTREQLASTCHGDDTETME,
    BKACCTREQLOCALLASTCHGDDTETME,
    COMPANYCODE,
    ISMARKEDFORDELETION,
    PRIMARY KEY (BANKACCOUNTCHANGEREQUEST, BANKACCOUNTOPENINGREQUESTUUID)
);

Learn More