P_ARBANKSTATEMENTITEMIDBS

CDS View
36 Fields 2 CDS Views

P_ARBANKSTATEMENTITEMIDBS is a CDS View in S/4HANA. It contains 36 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_Arbankstatementitem view from COMPOSITE Bank Statements Statements Items
I_ARBankStatementItemTP view from COMPOSITE Bank Statement Item BO active and draft

Fields (36)

KeyField CDS FieldsUsed in Views
KEY BankStatementItem BankStatementItem 1
KEY BankStatementShortID BankStatementShortID 1
AccountServicerReference AccountServicerReference 1
AcctDetnFreeDefinedAttribute AcctDetnFreeDefinedAttribute 1
AmountInTransactionCurrency AmountInTransactionCurrency 1
BankAccount BankAccount 1
BankAccountInternalID BankAccountInternalID 1
BankInternalID BankInternalID 1
BankLedgerIsPosted BankLedgerIsPosted 1
BankStatementItemLifeCycSts BankStatementItemLifeCycSts 1
BankStatementItemStatusByBank BankStatementItemStatusByBank 1
BankStatementPostingRule BankStatementPostingRule 1
BankStatementPostingRuleName BankStatementPostingRuleName 1
BankStmntItemProcessingType BankStmntItemProcessingType 1
BankStmntItmProcessingCategory BankStmntItmProcessingCategory 1
BankStmntProcessingApplication BankStmntProcessingApplication 1
BusinessArea BusinessArea 1
BusinessPartnerName BusinessPartnerName 1
CostCenter CostCenter 1
DaybookEntry DaybookEntry 1
DebitCreditCode DebitCreditCode 1
DocumentReferenceID DocumentReferenceID 1
DunningBlockingReason DunningBlockingReason 1
FiscalYear FiscalYear 1
InterpretationAlgorithm InterpretationAlgorithm 1
MemoLine1 MemoLine1 1
PartnerBankIBAN PartnerBankIBAN 1
PayerParty PayerParty 1
PaymentAdviceAccountTypeName PaymentAdviceAccountTypeName 1
PaymentReference PaymentReference 1
ProfitCenter ProfitCenter 1
SubledgerIsPostedSuccessfully SubledgerIsPostedSuccessfully 1
TransactionCurrency TransactionCurrency 1
TreasuryContract TreasuryContract 1
TreasuryContractType TreasuryContractType 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_ARBANKSTATEMENTITEMIDBS (
    BANKSTATEMENTITEM,
    BANKSTATEMENTSHORTID,
    ACCOUNTSERVICERREFERENCE,
    ACCTDETNFREEDEFINEDATTRIBUTE,
    AMOUNTINTRANSACTIONCURRENCY,
    BANKACCOUNT,
    BANKACCOUNTINTERNALID,
    BANKINTERNALID,
    BANKLEDGERISPOSTED,
    BANKSTATEMENTITEMLIFECYCSTS,
    BANKSTATEMENTITEMSTATUSBYBANK,
    BANKSTATEMENTPOSTINGRULE,
    BANKSTATEMENTPOSTINGRULENAME,
    BANKSTMNTITEMPROCESSINGTYPE,
    BANKSTMNTITMPROCESSINGCATEGORY,
    BANKSTMNTPROCESSINGAPPLICATION,
    BUSINESSAREA,
    BUSINESSPARTNERNAME,
    COSTCENTER,
    DAYBOOKENTRY,
    DEBITCREDITCODE,
    DOCUMENTREFERENCEID,
    DUNNINGBLOCKINGREASON,
    FISCALYEAR,
    INTERPRETATIONALGORITHM,
    MEMOLINE1,
    PARTNERBANKIBAN,
    PAYERPARTY,
    PAYMENTADVICEACCOUNTTYPENAME,
    PAYMENTREFERENCE,
    PROFITCENTER,
    SUBLEDGERISPOSTEDSUCCESSFULLY,
    TRANSACTIONCURRENCY,
    TREASURYCONTRACT,
    TREASURYCONTRACTTYPE,
    VALUEDATETIME,
    PRIMARY KEY (BANKSTATEMENTITEM, BANKSTATEMENTSHORTID)
);

Learn More