POS

POS is an SAP database table in S/4HANA. It contains 35 fields.

Fields (35)

KeyField CDS FieldsUsed in Views
KEY BankAccount BankAccount 10
KEY BankAccountCurrency Currency 1
KEY BankAccountInternalID BankAccountInternalID 12
KEY CertaintyLevel CertaintyLevel 10
KEY CompanyCode CompanyCode 13
KEY Currency Currency 10
After After 4
AmountInBankAccountCurrency AmountInBankAccountCurrency,AmountInTransactionCurrency 2
AmountInDisplayCurrency AmountInDisplayCurrency 3
AmountInTransactionCurrency AmountInTransactionCurrency 1
Bank Bank 12
BankAccountNumber BankAccountNumber 2
BankCountry BankCountry 11
Before Before 4
CashPlanningGroup CashPlanningGroup 4
CashPool CashPool 1
CashPoolName CashPoolName 1
Category Category,KeyFigure 4
ChartOfAccounts ChartOfAccounts 1
D1 D1 3
D2 D2 4
D3 D3 4
D4 D4 4
D5 D5 4
D6 D6 4
D7 D7 4
DisplayCurrency DisplayCurrency 2
GLAccount GLAccount 4
HouseBank HouseBank 7
HouseBankAccount HouseBankAccount 7
LiquidityItem LiquidityItem 4
PlanningLevel PlanningLevel 4
SUMGroupping SUMGroupping 1
SumTerm SumTerm 1
TransactionDate TransactionDate 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 POS (
    BANKACCOUNT,
    BANKACCOUNTCURRENCY,
    BANKACCOUNTINTERNALID,
    CERTAINTYLEVEL,
    COMPANYCODE,
    CURRENCY,
    AFTER,
    AMOUNTINBANKACCOUNTCURRENCY,
    AMOUNTINDISPLAYCURRENCY,
    AMOUNTINTRANSACTIONCURRENCY,
    BANK,
    BANKACCOUNTNUMBER,
    BANKCOUNTRY,
    BEFORE,
    CASHPLANNINGGROUP,
    CASHPOOL,
    CASHPOOLNAME,
    CATEGORY,
    CHARTOFACCOUNTS,
    D1,
    D2,
    D3,
    D4,
    D5,
    D6,
    D7,
    DISPLAYCURRENCY,
    GLACCOUNT,
    HOUSEBANK,
    HOUSEBANKACCOUNT,
    LIQUIDITYITEM,
    PLANNINGLEVEL,
    SUMGROUPPING,
    SUMTERM,
    TRANSACTIONDATE,
    PRIMARY KEY (BANKACCOUNT, BANKACCOUNTCURRENCY, BANKACCOUNTINTERNALID, CERTAINTYLEVEL, COMPANYCODE, CURRENCY)
);