Fields (16)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | PaymentTerms | PaymentTerms | 1 |
| KEY | Supplier | Supplier | 1 |
| KEY | TransactionCurrency | TransactionCurrency | 1 |
| _Country | _Country | 1 | |
| _CustomerPaymentTerms | _CustomerPaymentTerms | 1 | |
| _DisplayCurrency | _DisplayCurrency | 1 | |
| Country | SupplierCountry | 1 | |
| DisplayCurrency | DisplayCurrency | 1 | |
| hsl | salk3 | 1 | |
| hvkwrt | vksal | 1 | |
| LostCshDiscInDspCrcy_E | LostCshDiscAmtInDspCrcy | 1 | |
| OfferedCshDiscInDspCrcy_E | OfferedCshDiscAmtInDspCrcy | 1 | |
| SupplierAccountGroup | SupplierAccountGroup | 1 | |
| SupplierBasicAuthorizationGrp | SupplierBasicAuthorizationGrp | 1 | |
| TakenCshDiscInDspCrcy_E | TakenCshDiscAmtInDspCrcy | 1 | |
| vmsl | lbkum | 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 U (
PAYMENTTERMS,
SUPPLIER,
TRANSACTIONCURRENCY,
_COUNTRY,
_CUSTOMERPAYMENTTERMS,
_DISPLAYCURRENCY,
COUNTRY,
DISPLAYCURRENCY,
HSL,
HVKWRT,
LOSTCSHDISCINDSPCRCY_E,
OFFEREDCSHDISCINDSPCRCY_E,
SUPPLIERACCOUNTGROUP,
SUPPLIERBASICAUTHORIZATIONGRP,
TAKENCSHDISCINDSPCRCY_E,
VMSL,
PRIMARY KEY (PAYMENTTERMS, SUPPLIER, TRANSACTIONCURRENCY)
);
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