Fields (35)
| Key | Field | CDS Fields | Used 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)
);
Learn More
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA