BANKSTATEMENTITEM

45 Fields

BANKSTATEMENTITEM is an SAP database table in S/4HANA. It contains 45 fields.

Fields (45)

KeyField CDS FieldsUsed in Views
KEY StatementItem BankStatementItem 1
KEY StatementShortID BankStatementShortID 1
AmountInTransactionCurrency AmountInTransactionCurrency 2
AssignmentReference AssignmentReference 3
BankLedgerDocument BankLedgerDocument 2
BankPostingKey BankPostingKey 3
BankReference BankReference 1
BankStatement BankStatement 2
BankStatementItem BankStatementItem 2
BankStatementPostingRule BankStatementPostingRule 2
BankStatementShortID BankStatementShortID 2
BusinessPartnerName BusinessPartnerName 2
Cheque Cheque 3
Client Client 2
CompanyCode CompanyCode 2
Currency Currency 2
DebitCreditCode DebitCreditCode 3
DocumentReferenceID DocumentReferenceID 3
FiscalYear FiscalYear 2
HouseBank HouseBank 2
HouseBankAccount HouseBankAccount 2
InterpretationAlgorithm InterpretationAlgorithm 1
ItemDescription1 BankStatementItemDescription1 1
ItemDescription2 BankStatementItemDescription2 1
MemoLineIsChanged MemoLineIsChanged 1
OriginalCurrency OriginalCurrency 1
PartnerBank PartnerBank 2
PartnerBankAccount PartnerBankAccount 2
PartnerBankCountry PartnerBankCountry 2
PartnerBankIBAN PartnerBankIBAN 2
PartnerBankSWIFTCode PartnerBankSWIFTCode 2
PaymentAdvice PaymentAdvice 2
PaymentAdviceAccount PaymentAdviceAccount 2
PaymentAdviceAccountType PaymentAdviceAccountType 2
PaymentExternalTransacType PaymentExternalTransacType 3
PaymentManualTransacType PaymentManualTransacType 1
PaymentReference PaymentReference 3
PaymentTransaction PaymentTransaction 3
PaymentTransactionDescription PaymentTransactionDescription 3
PostingDate PostingDate 2
PostingRule BankStatementPostingRule 1
SubledgerDocument SubledgerDocument 2
SubledgerOnAccountDocument SubledgerOnAccountDocument 2
TransactionCurrency TransactionCurrency 3
ValueDate ValueDate 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 BANKSTATEMENTITEM (
    STATEMENTITEM,
    STATEMENTSHORTID,
    AMOUNTINTRANSACTIONCURRENCY,
    ASSIGNMENTREFERENCE,
    BANKLEDGERDOCUMENT,
    BANKPOSTINGKEY,
    BANKREFERENCE,
    BANKSTATEMENT,
    BANKSTATEMENTITEM,
    BANKSTATEMENTPOSTINGRULE,
    BANKSTATEMENTSHORTID,
    BUSINESSPARTNERNAME,
    CHEQUE,
    CLIENT,
    COMPANYCODE,
    CURRENCY,
    DEBITCREDITCODE,
    DOCUMENTREFERENCEID,
    FISCALYEAR,
    HOUSEBANK,
    HOUSEBANKACCOUNT,
    INTERPRETATIONALGORITHM,
    ITEMDESCRIPTION1,
    ITEMDESCRIPTION2,
    MEMOLINEISCHANGED,
    ORIGINALCURRENCY,
    PARTNERBANK,
    PARTNERBANKACCOUNT,
    PARTNERBANKCOUNTRY,
    PARTNERBANKIBAN,
    PARTNERBANKSWIFTCODE,
    PAYMENTADVICE,
    PAYMENTADVICEACCOUNT,
    PAYMENTADVICEACCOUNTTYPE,
    PAYMENTEXTERNALTRANSACTYPE,
    PAYMENTMANUALTRANSACTYPE,
    PAYMENTREFERENCE,
    PAYMENTTRANSACTION,
    PAYMENTTRANSACTIONDESCRIPTION,
    POSTINGDATE,
    POSTINGRULE,
    SUBLEDGERDOCUMENT,
    SUBLEDGERONACCOUNTDOCUMENT,
    TRANSACTIONCURRENCY,
    VALUEDATE,
    PRIMARY KEY (STATEMENTITEM, STATEMENTSHORTID)
);

Learn More