P_ARBANKTRANSACTIONDOCITEM_06
P_ARBANKTRANSACTIONDOCITEM_06 is a CDS View in S/4HANA. It contains 93 fields. 5 CDS views read from this table.
CDS Views using this table (5)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_BankStatementByDays | view | from | COMPOSITE | Bank Statement by Days |
| I_BankStatementItem | view | from | COMPOSITE | Items of a bank statement |
| I_HouseBankAccountBkStmntItm | view | from | COMPOSITE | House Bank Account Bank Statement Item |
| P_ARBankTransacDocItmCnt | view | from | COMPOSITE | |
| P_Arbanktransactiondocitem_07 | view | from | COMPOSITE |
Fields (93)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | StatementItem | BankStatementItem,StatementItem | 3 |
| KEY | StatementShortID | BankStatementShortID,StatementShortID | 3 |
| AccountingClerk | AccountingClerk | 1 | |
| AccountingExchangeRate | AccountingExchangeRate | 1 | |
| AccountServicerReference | AccountServicerReference | 1 | |
| AcctDetnFreeDefinedAttribute | AcctDetnFreeDefinedAttribute | 1 | |
| AdditionalInformation | AdditionalInformation | 1 | |
| AmountInAccountCurrency | AmountInAccountCurrency | 1 | |
| AssignmentReference | AssignmentReference | 1 | |
| BankLedgerAcctgDocFiscalYear | BankLedgerAcctgDocFiscalYear | 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 | |
| BankStatementItemStatusByBank | BankStatementItemStatusByBank | 1 | |
| BankStmntItmProcessingCategory | BankStmntItmProcessingCategory | 1 | |
| BankStmntProcessingApplication | BankStmntProcessingApplication | 1 | |
| BatchNumber | BatchNumber | 1 | |
| BillOfExchangeFailureDate | BillOfExchangeFailureDate | 1 | |
| BusinessArea | BusinessArea | 1 | |
| BusinessPartnerName | BusinessPartnerName | 1 | |
| CostCenter | CostCenter | 1 | |
| DaybookEntry | DaybookEntry | 1 | |
| DebitCreditCode | DebitCreditCode | 2 | |
| DocumentItemText | DocumentItemText | 2 | |
| DocumentReferenceID | DocumentReferenceID | 1 | |
| DunningBlockingReason | DunningBlockingReason | 1 | |
| ExchangeRate | ExchangeRate | 1 | |
| FeeAmountInOriginalCrcy | FeeAmountInOriginalCrcy | 1 | |
| FeeAmountInTransactionCrcy | FeeAmountInTransactionCrcy | 2 | |
| FinancialAssetsMgmtInfoField | FinancialAssetsMgmtInfoField | 1 | |
| FinancialAssetsMgmtStatus | FinancialAssetsMgmtStatus | 1 | |
| FiscalYear | FiscalYear | 2 | |
| ForeignCurrencyAmount | ForeignCurrencyAmount | 1 | |
| IdNumberForCashMgmtAndForecast | IdNumberForCashMgmtAndForecast | 1 | |
| InterpretationAlgorithm | InterpretationAlgorithm | 2 | |
| IsCompleted | IsCompleted | 2 | |
| IsInProcess | IsInProcess | 1 | |
| ItemDescription1 | ItemDescription1 | 1 | |
| ItemDescription2 | ItemDescription2 | 1 | |
| ItemGroup | ItemGroup | 1 | |
| ItemIsInterpreted | ItemIsInterpreted | 1 | |
| ItemIsReprocessed | ItemIsReprocessed | 1 | |
| ItemProcessingType | ItemProcessingType | 1 | |
| ItemReprocessReason | BankStmntItemReprocessReason | 1 | |
| MachineLrngBankStmntItemStatus | MachineLrngBankStmntItemStatus | 1 | |
| MemoLineIsChanged | MemoLineIsChanged | 1 | |
| NumberOfSecondSubledgerDoc | NumberOfSecondSubledgerDoc | 1 | |
| OriginalCurrency | OriginalCurrency | 2 | |
| OverdueChargeAmtInTransacCrcy | OverdueChargeAmtInTransacCrcy | 1 | |
| PartnerBank | PartnerBank | 1 | |
| PartnerBankAccount | PartnerBankAccount | 1 | |
| PartnerBankCountry | PartnerBankCountry | 1 | |
| PartnerBankIBAN | PartnerBankIBAN | 2 | |
| PartnerBankSWIFTCode | PartnerBankSWIFTCode | 1 | |
| PayerParty | PayerParty | 1 | |
| PaymentAdvice | PaymentAdvice | 2 | |
| PaymentAdviceAccount | PaymentAdviceAccount | 1 | |
| PaymentAdviceAccountType | PaymentAdviceAccountType | 1 | |
| PaymentExternalTransacType | PaymentExternalTransacType | 2 | |
| PaymentManualTransacType | PaymentManualTransacType | 1 | |
| PaymentReference | PaymentReference | 1 | |
| PaymentTransaction | PaymentTransaction | 1 | |
| PaymentTransactionDescription | PaymentTransactionDescription | 1 | |
| PostingAlgorithm | PostingAlgorithm | 1 | |
| PostingDate | PostingDate | 2 | |
| PostingErrorStatus | PostingErrorStatus | 1 | |
| PostingRule | PostingRule | 1 | |
| ProfitCenter | ProfitCenter | 1 | |
| ReferenceDocument | ReferenceDocument | 1 | |
| ReferenceDocumentType | ReferenceDocumentType | 1 | |
| ReturnReason | ReturnReason | 1 | |
| SubledgerAcctgDocFiscalYear | SubledgerAcctgDocFiscalYear | 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 | |
| TransactionCurrency | TransactionCurrency | 3 | |
| TreasuryContract | TreasuryContract | 1 | |
| TreasuryContractType | TreasuryContractType | 1 | |
| ValueDate | ValueDate | 2 | |
| ValueDateTime | ValueDateTime | 2 |
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 P_ARBANKTRANSACTIONDOCITEM_06 (
STATEMENTITEM,
STATEMENTSHORTID,
ACCOUNTINGCLERK,
ACCOUNTINGEXCHANGERATE,
ACCOUNTSERVICERREFERENCE,
ACCTDETNFREEDEFINEDATTRIBUTE,
ADDITIONALINFORMATION,
AMOUNTINACCOUNTCURRENCY,
ASSIGNMENTREFERENCE,
BANKLEDGERACCTGDOCFISCALYEAR,
BANKLEDGERDOCUMENT,
BANKLEDGEREXTERNALAPPLICATION,
BANKLEDGEREXTPOSTGERRORSTATUS,
BANKLEDGEREXTPOSTINGDOCUMENT,
BANKLEDGEREXTPOSTINGREFDOCTYPE,
BANKLEDGERISPOSTED,
BANKLEDGERONACCOUNTDOCUMENT,
BANKLEDGERPOSTINGISSUPPRESSED,
BANKPOSTINGDATE,
BANKPOSTINGKEY,
BANKREFERENCE,
BANKSTATEMENTITEMSTATUSBYBANK,
BANKSTMNTITMPROCESSINGCATEGORY,
BANKSTMNTPROCESSINGAPPLICATION,
BATCHNUMBER,
BILLOFEXCHANGEFAILUREDATE,
BUSINESSAREA,
BUSINESSPARTNERNAME,
COSTCENTER,
DAYBOOKENTRY,
DEBITCREDITCODE,
DOCUMENTITEMTEXT,
DOCUMENTREFERENCEID,
DUNNINGBLOCKINGREASON,
EXCHANGERATE,
FEEAMOUNTINORIGINALCRCY,
FEEAMOUNTINTRANSACTIONCRCY,
FINANCIALASSETSMGMTINFOFIELD,
FINANCIALASSETSMGMTSTATUS,
FISCALYEAR,
FOREIGNCURRENCYAMOUNT,
IDNUMBERFORCASHMGMTANDFORECAST,
INTERPRETATIONALGORITHM,
ISCOMPLETED,
ISINPROCESS,
ITEMDESCRIPTION1,
ITEMDESCRIPTION2,
ITEMGROUP,
ITEMISINTERPRETED,
ITEMISREPROCESSED,
ITEMPROCESSINGTYPE,
ITEMREPROCESSREASON,
MACHINELRNGBANKSTMNTITEMSTATUS,
MEMOLINEISCHANGED,
NUMBEROFSECONDSUBLEDGERDOC,
ORIGINALCURRENCY,
OVERDUECHARGEAMTINTRANSACCRCY,
PARTNERBANK,
PARTNERBANKACCOUNT,
PARTNERBANKCOUNTRY,
PARTNERBANKIBAN,
PARTNERBANKSWIFTCODE,
PAYERPARTY,
PAYMENTADVICE,
PAYMENTADVICEACCOUNT,
PAYMENTADVICEACCOUNTTYPE,
PAYMENTEXTERNALTRANSACTYPE,
PAYMENTMANUALTRANSACTYPE,
PAYMENTREFERENCE,
PAYMENTTRANSACTION,
PAYMENTTRANSACTIONDESCRIPTION,
POSTINGALGORITHM,
POSTINGDATE,
POSTINGERRORSTATUS,
POSTINGRULE,
PROFITCENTER,
REFERENCEDOCUMENT,
REFERENCEDOCUMENTTYPE,
RETURNREASON,
SUBLEDGERACCTGDOCFISCALYEAR,
SUBLEDGERDOCUMENT,
SUBLEDGEREXTPOSTINGAPPLICATION,
SUBLEDGEREXTPOSTINGDOCUMENT,
SUBLEDGEREXTPOSTINGERRORSTATUS,
SUBLEDGEREXTPOSTINGREFDOCTYPE,
SUBLEDGERISPOSTEDSUCCESSFULLY,
SUBLEDGERONACCOUNTDOCUMENT,
SUBLEDGERPOSTINGISSUPPRESSED,
TRANSACTIONCURRENCY,
TREASURYCONTRACT,
TREASURYCONTRACTTYPE,
VALUEDATE,
VALUEDATETIME,
PRIMARY KEY (STATEMENTITEM, STATEMENTSHORTID)
);
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