P_ARBANKTRANSACTIONDOCITEM_06

CDS View

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)

ViewTypeJoinVDMDescription
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)

KeyField CDS FieldsUsed 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)
);