I_BANKACCOUNTWITHREVISION

CDS View
61 Fields 4 CDS Views

Bank Account With Revision

I_BANKACCOUNTWITHREVISION is a CDS View in S/4HANA. Bank Account With Revision. It contains 61 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
C_BankAccountWithRevision view from CONSUMPTION Bank Account With Revision
C_BkAccountOutputParamDet view from CONSUMPTION Bank Correspondence Parameter
I_BankAccountCount view from COMPOSITE Bank Account Regardless Revision
I_BankAcctRevEmailTemplate view from COMPOSITE Email Template for Bank Account Revision

Fields (61)

KeyField CDS FieldsUsed in Views
KEY BankAccountInternalID BankAccountInternalID 1
KEY BankAccountRevision BankAccountRevision 1
ArchObjectNumber ArchObjectNumber 1
Bank Bank 1
BankAccountCurrency BankAccountCurrency 1
BankAccountHolderName BankAccountHolderName 1
BankAccountNumber BankAccountNumber 1
BankAccountStatus BankAccountStatus 1
BankAccountSupervisor BankAccountSupervisor 1
BankAccountType BankAccountType 1
BankContactPerson BankContactPerson 1
BankControlKey BankControlKey 1
BankCountry BankCountry 1
BankRelationshipManager BankRelationshipManager 1
BankStatementCheckTime BankStatementCheckTime 1
BankStatementImportChannel BankStatementImportChannel 1
BankStatementImportMethod BankStatementImportMethod 1
BusinessArea BusinessArea 1
ClosedByUser ClosedByUser 1
ClosedDate ClosedDate 1
ClosedTime ClosedTime 1
CompanyCode CompanyCode 1
CompanyContactPerson CompanyContactPerson 1
ControlFrequency ControlFrequency 1
CreatedByUser CreatedByUser 1
CreationDate CreationDate 1
CreationTime CreationTime 1
CrossBorderCutOffTime CrossBorderCutOffTime 1
DifferenceAmount DifferenceAmount 1
DifferenceStatus DifferenceStatus 1
DisplayItem DisplayItem 1
DomesticCutOffTime DomesticCutOffTime 1
ExpectedInterval ExpectedInterval 1
FactoryCalendar FactoryCalendar 1
IBAN IBAN 2
IBANValidityStartDate IBANValidityStartDate 1
IntraDayBankStateImportMethod IntraDayBankStateImportMethod 1
IsUploadOfIntraDayStatement IsUploadOfIntraDayStatement 1
LastChangeDate LastChangeDate 1
LastChangedByUser LastChangedByUser 1
LastChangeTime LastChangeTime 1
LeadingCashPoolID LeadingCashPoolID 1
LeadingPaymentMethod LeadingPaymentMethod 1
MaxTargetAmount MaxTargetAmount 1
MinTargetAmount MinTargetAmount 1
MinTransferAmount MinTransferAmount 1
OpenedByUser OpenedByUser 1
OpenedDate OpenedDate 1
ParticipantCashPoolID ParticipantCashPoolID 1
ParticipantPaymentMethod ParticipantPaymentMethod 1
PaymentServiceProvider PaymentServiceProvider 1
PaymentTransactionTypeGroup PaymentTransactionTypeGroup 1
PlannedClosingDate PlannedClosingDate 1
ProcessingStatus ProcessingStatus 1
ProfitCenter ProfitCenter 1
ReconciliationStatus ReconciliationStatus 1
ReviewedByUser ReviewedByUser 1
Segment Segment 1
SerialNumberStatus SerialNumberStatus 1
ValidityEndDate ValidityEndDate 1
ValidityStartDate ValidityStartDate 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 With Revision
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_BANKACCOUNTWITHREVISION (
    BANKACCOUNTINTERNALID,
    BANKACCOUNTREVISION,
    ARCHOBJECTNUMBER,
    BANK,
    BANKACCOUNTCURRENCY,
    BANKACCOUNTHOLDERNAME,
    BANKACCOUNTNUMBER,
    BANKACCOUNTSTATUS,
    BANKACCOUNTSUPERVISOR,
    BANKACCOUNTTYPE,
    BANKCONTACTPERSON,
    BANKCONTROLKEY,
    BANKCOUNTRY,
    BANKRELATIONSHIPMANAGER,
    BANKSTATEMENTCHECKTIME,
    BANKSTATEMENTIMPORTCHANNEL,
    BANKSTATEMENTIMPORTMETHOD,
    BUSINESSAREA,
    CLOSEDBYUSER,
    CLOSEDDATE,
    CLOSEDTIME,
    COMPANYCODE,
    COMPANYCONTACTPERSON,
    CONTROLFREQUENCY,
    CREATEDBYUSER,
    CREATIONDATE,
    CREATIONTIME,
    CROSSBORDERCUTOFFTIME,
    DIFFERENCEAMOUNT,
    DIFFERENCESTATUS,
    DISPLAYITEM,
    DOMESTICCUTOFFTIME,
    EXPECTEDINTERVAL,
    FACTORYCALENDAR,
    IBAN,
    IBANVALIDITYSTARTDATE,
    INTRADAYBANKSTATEIMPORTMETHOD,
    ISUPLOADOFINTRADAYSTATEMENT,
    LASTCHANGEDATE,
    LASTCHANGEDBYUSER,
    LASTCHANGETIME,
    LEADINGCASHPOOLID,
    LEADINGPAYMENTMETHOD,
    MAXTARGETAMOUNT,
    MINTARGETAMOUNT,
    MINTRANSFERAMOUNT,
    OPENEDBYUSER,
    OPENEDDATE,
    PARTICIPANTCASHPOOLID,
    PARTICIPANTPAYMENTMETHOD,
    PAYMENTSERVICEPROVIDER,
    PAYMENTTRANSACTIONTYPEGROUP,
    PLANNEDCLOSINGDATE,
    PROCESSINGSTATUS,
    PROFITCENTER,
    RECONCILIATIONSTATUS,
    REVIEWEDBYUSER,
    SEGMENT,
    SERIALNUMBERSTATUS,
    VALIDITYENDDATE,
    VALIDITYSTARTDATE,
    PRIMARY KEY (BANKACCOUNTINTERNALID, BANKACCOUNTREVISION)
);

Learn More