PAYMENT

PAYMENT is an SAP database table in S/4HANA. It contains 31 fields.

Fields (31)

KeyField CDS FieldsUsed in Views
KEY Bank Bank,BankInternalID 8
KEY BankAccountInternalID BankAccountInternalID 1
KEY BankCountry BankCountry 8
KEY CompanyCode CompanyCode 15
KEY HouseBank HouseBank 11
KEY HouseBankAccount HouseBankAccount 11
KEY IL_IdentifierCashPaymentItem IL_IdentifierCashPaymentItem 1
KEY TransactionDate TransactionDate 2
AmountInDisplayCurrency AmountInDisplayCurrency 1
BankAccount BankAccount 1
BankNumber BankNumber 1
bukrs CompanyCode 1
CreditRating CreditRating 1
DisplayCurrency DisplayCurrency 4
HouseBankAccountDescription HouseBankAccountDescription 1
HouseBankName BankName 1
IL_BankTransferReferenceNumber IL_BankTransferReferenceNumber 1
IL_ChequeDueDate IL_ChequeDueDate 1
IL_ChequeNumber IL_ChequeNumber 1
IL_CreditCardReference IL_CreditCardReference 1
IL_CreditCardTransactionType IL_CreditCardTransactionType 1
IL_PaymentMethod IL_PaymentMethod 1
IL_PaytItmAmountInDocCrcy IL_PaytItmAmountInDocCrcy 1
InAmountInDisplayCurrency InAmountInDisplayCurrency 5
IncomingPaymentQuantity IncomingPaymentQuantity,NumberOfIncomingPayment 3
NrOfBanksRated NrOfBanksRated 1
OutAmountInDisplayCurrency OutAmountInDisplayCurrency 5
OutgoingPaymentQuantity NumberOfOutgoingPayment,OutgoingPaymentQuantity 3
PaymentMethodDescription PaymentMethodDescription 1
pernr EmploymentInternalID 1
zwels PaymentMethodsList 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 PAYMENT (
    BANK,
    BANKACCOUNTINTERNALID,
    BANKCOUNTRY,
    COMPANYCODE,
    HOUSEBANK,
    HOUSEBANKACCOUNT,
    IL_IDENTIFIERCASHPAYMENTITEM,
    TRANSACTIONDATE,
    AMOUNTINDISPLAYCURRENCY,
    BANKACCOUNT,
    BANKNUMBER,
    BUKRS,
    CREDITRATING,
    DISPLAYCURRENCY,
    HOUSEBANKACCOUNTDESCRIPTION,
    HOUSEBANKNAME,
    IL_BANKTRANSFERREFERENCENUMBER,
    IL_CHEQUEDUEDATE,
    IL_CHEQUENUMBER,
    IL_CREDITCARDREFERENCE,
    IL_CREDITCARDTRANSACTIONTYPE,
    IL_PAYMENTMETHOD,
    IL_PAYTITMAMOUNTINDOCCRCY,
    INAMOUNTINDISPLAYCURRENCY,
    INCOMINGPAYMENTQUANTITY,
    NROFBANKSRATED,
    OUTAMOUNTINDISPLAYCURRENCY,
    OUTGOINGPAYMENTQUANTITY,
    PAYMENTMETHODDESCRIPTION,
    PERNR,
    ZWELS,
    PRIMARY KEY (BANK, BANKACCOUNTINTERNALID, BANKCOUNTRY, COMPANYCODE, HOUSEBANK, HOUSEBANKACCOUNT, IL_IDENTIFIERCASHPAYMENTITEM, TRANSACTIONDATE)
);