_BANKSTATEMENTITEM

_BANKSTATEMENTITEM is an SAP database table in S/4HANA. It contains 16 fields.

Fields (16)

KeyField CDS FieldsUsed in Views
AmountInOriginalCurrency AmountInOriginalCurrency 1
AmountInTransactionCurrency AmountInTransactionCurrency 1
AssignmentReference AssignmentReference 1
BankLedgerDocument BankLedgerDocument 1
BankStatement BankStatement 1
BusinessPartnerName BusinessPartnerName 1
DocumentItemText DocumentItemText 1
FiscalYear FiscalYear 1
OriginalCurrency OriginalCurrency 1
PartnerBankAccount PartnerBankAccount 1
PaymentExternalTransacType PaymentExternalTransacType 1
PaymentManualTransacType PaymentManualTransacType 1
PaymentTransaction PaymentTransaction 1
PostingDate PostingDate 1
TransactionCurrency TransactionCurrency 1
ValueDate ValueDate 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 _BANKSTATEMENTITEM (
    AMOUNTINORIGINALCURRENCY,
    AMOUNTINTRANSACTIONCURRENCY,
    ASSIGNMENTREFERENCE,
    BANKLEDGERDOCUMENT,
    BANKSTATEMENT,
    BUSINESSPARTNERNAME,
    DOCUMENTITEMTEXT,
    FISCALYEAR,
    ORIGINALCURRENCY,
    PARTNERBANKACCOUNT,
    PAYMENTEXTERNALTRANSACTYPE,
    PAYMENTMANUALTRANSACTYPE,
    PAYMENTTRANSACTION,
    POSTINGDATE,
    TRANSACTIONCURRENCY,
    VALUEDATE
);