I_ARBANKSTATEMENTITEMTP
Bank Statement Item BO active and draft
I_ARBANKSTATEMENTITEMTP is a CDS View in S/4HANA. Bank Statement Item BO active and draft. It contains 99 fields. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_Arbankstatementitem | view | from | CONSUMPTION | Manage Bank Statement Items |
| C_ARBankStatementItmUpload | view_entity | from | CONSUMPTION | Consumption CDS for Excel Upload Template Generation MBS |
Fields (99)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | BankStatementItem | BankStatementItem,FinancialStatementItem | 1 |
| KEY | BankStatementShortID | BankStatementShortID | 1 |
| AccountingClerk | AccountingClerk | 1 | |
| AccountingExchangeRate | AccountingExchangeRate | 1 | |
| AccountServicerReference | AccountServicerReference | 1 | |
| AcctDetnFreeDefinedAttribute | AcctDetnFreeDefinedAttribute | 1 | |
| AmountInOriginalCurrency | AmountInOriginalCurrency | 1 | |
| AmountInTransactionCurrency | AmountInTransactionCurrency | 1 | |
| ApplicationLog | ApplicationLog | 1 | |
| AssignmentReference | AssignmentReference | 1 | |
| BankAccount | BankAccount | 1 | |
| BankAccountInternalID | BankAccountInternalID | 1 | |
| BankInternalID | BankInternalID | 1 | |
| BankLedgerDocument | BankLedgerDocument | 1 | |
| BankLedgerExternalApplication | BankLedgerExternalApplication | 1 | |
| BankLedgerExtPostgErrorStatus | BankLedgerExtPostgErrorStatus | 1 | |
| BankLedgerExtPostingDocument | BankLedgerExtPostingDocument | 1 | |
| BankLedgerExtPostingRefDocType | BankLedgerExtPostingRefDocType | 1 | |
| BankLedgerIsPosted | BankLedgerIsPosted | 1 | |
| BankLedgerOnAccountDocument | BankLedgerOnAccountDocument | 1 | |
| BankLedgerPostingIsSuppressed | BankLedgerPostingIsSuppressed | 1 | |
| BankPostingDate | BankPostingDate | 1 | |
| BankPostingKey | BankPostingKey | 1 | |
| BankReference | BankReference | 1 | |
| BankStatementItemDescription1 | BankStatementItemDescription1 | 1 | |
| BankStatementItemDescription2 | BankStatementItemDescription2 | 1 | |
| BankStatementItemGroup | BankStatementItemGroup | 1 | |
| BankStatementItemIsInterpreted | BankStatementItemIsInterpreted | 1 | |
| BankStatementItemStatusByBank | BankStatementItemStatusByBank | 1 | |
| BankStatementItmLifeCycStsName | BankStatementItmLifeCycStsName | 1 | |
| BankStatementPostingRule | BankStatementPostingRule | 1 | |
| BankStatementPostingRuleName | BankStatementPostingRuleName | 1 | |
| BankStmntItemProcessingType | BankStmntItemProcessingType | 1 | |
| BankStmntItmProcessingCategory | BankStmntItmProcessingCategory | 1 | |
| BankStmntProcessingApplication | BankStmntProcessingApplication | 1 | |
| BillOfExchangeFailureDate | BillOfExchangeFailureDate | 1 | |
| BusinessArea | BusinessArea | 1 | |
| BusinessPartnerName | BusinessPartnerName | 1 | |
| Cheque | Cheque | 1 | |
| CompanyCode | CompanyCode | 1 | |
| CostCenter | CostCenter | 1 | |
| Customer | Customer | 1 | |
| CustomerReferenceNumber | CustomerReferenceNumber | 1 | |
| DaybookEntry | DaybookEntry | 1 | |
| DebitCreditCode | DebitCreditCode | 1 | |
| DocumentItemText | DocumentItemText | 1 | |
| DocumentReferenceID | DocumentReferenceID | 1 | |
| DunningBlockingReason | DunningBlockingReason | 1 | |
| ExchangeRate | ExchangeRate | 1 | |
| FeeAmountInOriginalCrcy | FeeAmountInOriginalCrcy | 1 | |
| FeeAmountInTransactionCrcy | FeeAmountInTransactionCrcy | 1 | |
| FiscalYear | FiscalYear | 1 | |
| GLAccount | GLAccount | 1 | |
| HasAttachment | HasAttachment | 1 | |
| InterpretationAlgorithm | InterpretationAlgorithm | 1 | |
| IsCompleted | IsCompleted | 1 | |
| IsInProcess | IsInProcess | 1 | |
| MemoLine | MemoLine | 1 | |
| MemoLine1 | MemoLine1 | 1 | |
| MemoLineIsChanged | MemoLineIsChanged | 1 | |
| OriginalCurrency | OriginalCurrency | 1 | |
| OriginalMemoLine | OriginalMemoLine | 1 | |
| OverdueChargeAmtInTransacCrcy | OverdueChargeAmtInTransacCrcy | 1 | |
| PartnerBank | PartnerBank | 1 | |
| PartnerBankAccount | PartnerBankAccount | 1 | |
| PartnerBankCountry | PartnerBankCountry | 1 | |
| PartnerBankIBAN | PartnerBankIBAN | 1 | |
| PartnerBankSWIFTCode | PartnerBankSWIFTCode | 1 | |
| PayerParty | PayerParty | 1 | |
| PaymentAdvice | PaymentAdvice | 1 | |
| PaymentAdviceAccountType | PaymentAdviceAccountType | 1 | |
| PaymentAdviceAccountTypeName | PaymentAdviceAccountTypeName | 1 | |
| PaymentExternalTransacType | PaymentExternalTransacType | 1 | |
| PaymentManualTransacType | PaymentManualTransacType | 1 | |
| PaymentManualTransacTypeName | PaymentManualTransacTypeName | 1 | |
| PaymentMediumReference | PaymentMediumReference | 1 | |
| PaymentReference | PaymentReference | 1 | |
| PaymentTransactionCategoryName | PaymentTransactionCategoryName | 1 | |
| PaymentTransactionDescription | PaymentTransactionDescription | 1 | |
| PostingDate | PostingDate | 1 | |
| PostingErrorStatus | PostingErrorStatus | 1 | |
| ProfitCenter | ProfitCenter | 1 | |
| ReferenceDocument | ReferenceDocument | 1 | |
| ReferenceDocumentType | ReferenceDocumentType | 1 | |
| ReturnReason | ReturnReason | 1 | |
| SubledgerDocument | SubledgerDocument | 1 | |
| SubledgerExtPostingApplication | SubledgerExtPostingApplication | 1 | |
| SubledgerExtPostingDocument | SubledgerExtPostingDocument | 1 | |
| SubledgerExtPostingErrorStatus | SubledgerExtPostingErrorStatus | 1 | |
| SubledgerExtPostingRefDocType | SubledgerExtPostingRefDocType | 1 | |
| SubledgerIsPostedSuccessfully | SubledgerIsPostedSuccessfully | 1 | |
| SubledgerOnAccountDocument | SubledgerOnAccountDocument | 1 | |
| SubledgerPostingIsSuppressed | SubledgerPostingIsSuppressed | 1 | |
| Supplier | Supplier | 1 | |
| TransactionCurrency | TransactionCurrency | 1 | |
| TreasuryContract | TreasuryContract | 1 | |
| TreasuryContractType | TreasuryContractType | 1 | |
| ValueDate | ValueDate | 1 | |
| ValueDateTime | ValueDateTime | 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 Statement Item BO active and draft
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_ARBANKSTATEMENTITEMTP (
BANKSTATEMENTITEM,
BANKSTATEMENTSHORTID,
ACCOUNTINGCLERK,
ACCOUNTINGEXCHANGERATE,
ACCOUNTSERVICERREFERENCE,
ACCTDETNFREEDEFINEDATTRIBUTE,
AMOUNTINORIGINALCURRENCY,
AMOUNTINTRANSACTIONCURRENCY,
APPLICATIONLOG,
ASSIGNMENTREFERENCE,
BANKACCOUNT,
BANKACCOUNTINTERNALID,
BANKINTERNALID,
BANKLEDGERDOCUMENT,
BANKLEDGEREXTERNALAPPLICATION,
BANKLEDGEREXTPOSTGERRORSTATUS,
BANKLEDGEREXTPOSTINGDOCUMENT,
BANKLEDGEREXTPOSTINGREFDOCTYPE,
BANKLEDGERISPOSTED,
BANKLEDGERONACCOUNTDOCUMENT,
BANKLEDGERPOSTINGISSUPPRESSED,
BANKPOSTINGDATE,
BANKPOSTINGKEY,
BANKREFERENCE,
BANKSTATEMENTITEMDESCRIPTION1,
BANKSTATEMENTITEMDESCRIPTION2,
BANKSTATEMENTITEMGROUP,
BANKSTATEMENTITEMISINTERPRETED,
BANKSTATEMENTITEMSTATUSBYBANK,
BANKSTATEMENTITMLIFECYCSTSNAME,
BANKSTATEMENTPOSTINGRULE,
BANKSTATEMENTPOSTINGRULENAME,
BANKSTMNTITEMPROCESSINGTYPE,
BANKSTMNTITMPROCESSINGCATEGORY,
BANKSTMNTPROCESSINGAPPLICATION,
BILLOFEXCHANGEFAILUREDATE,
BUSINESSAREA,
BUSINESSPARTNERNAME,
CHEQUE,
COMPANYCODE,
COSTCENTER,
CUSTOMER,
CUSTOMERREFERENCENUMBER,
DAYBOOKENTRY,
DEBITCREDITCODE,
DOCUMENTITEMTEXT,
DOCUMENTREFERENCEID,
DUNNINGBLOCKINGREASON,
EXCHANGERATE,
FEEAMOUNTINORIGINALCRCY,
FEEAMOUNTINTRANSACTIONCRCY,
FISCALYEAR,
GLACCOUNT,
HASATTACHMENT,
INTERPRETATIONALGORITHM,
ISCOMPLETED,
ISINPROCESS,
MEMOLINE,
MEMOLINE1,
MEMOLINEISCHANGED,
ORIGINALCURRENCY,
ORIGINALMEMOLINE,
OVERDUECHARGEAMTINTRANSACCRCY,
PARTNERBANK,
PARTNERBANKACCOUNT,
PARTNERBANKCOUNTRY,
PARTNERBANKIBAN,
PARTNERBANKSWIFTCODE,
PAYERPARTY,
PAYMENTADVICE,
PAYMENTADVICEACCOUNTTYPE,
PAYMENTADVICEACCOUNTTYPENAME,
PAYMENTEXTERNALTRANSACTYPE,
PAYMENTMANUALTRANSACTYPE,
PAYMENTMANUALTRANSACTYPENAME,
PAYMENTMEDIUMREFERENCE,
PAYMENTREFERENCE,
PAYMENTTRANSACTIONCATEGORYNAME,
PAYMENTTRANSACTIONDESCRIPTION,
POSTINGDATE,
POSTINGERRORSTATUS,
PROFITCENTER,
REFERENCEDOCUMENT,
REFERENCEDOCUMENTTYPE,
RETURNREASON,
SUBLEDGERDOCUMENT,
SUBLEDGEREXTPOSTINGAPPLICATION,
SUBLEDGEREXTPOSTINGDOCUMENT,
SUBLEDGEREXTPOSTINGERRORSTATUS,
SUBLEDGEREXTPOSTINGREFDOCTYPE,
SUBLEDGERISPOSTEDSUCCESSFULLY,
SUBLEDGERONACCOUNTDOCUMENT,
SUBLEDGERPOSTINGISSUPPRESSED,
SUPPLIER,
TRANSACTIONCURRENCY,
TREASURYCONTRACT,
TREASURYCONTRACTTYPE,
VALUEDATE,
VALUEDATETIME,
PRIMARY KEY (BANKSTATEMENTITEM, BANKSTATEMENTSHORTID)
);Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA