Fields (25)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | Characteristic | Characteristic | 4 |
| KEY | FamilyName | FamilyName | 3 |
| KEY | GivenName | GivenName | 3 |
| KEY | UtilitiesProduct | UtilitiesProduct | 4 |
| KEY | WorkplaceDepartmentName | WorkplaceDepartmentName | 3 |
| _ProductGroup | _ProductGroup | 4 | |
| _ProductType | _ProductType | 4 | |
| char1 | CharField_Ext | 1 | |
| CharcToAmount | UtilsPriceAmount | 1 | |
| CharcValue | UtilsDiscountID,UtilsPriceID | 4 | |
| CharcValuePositionNumber | ValuePositionNumber | 4 | |
| cuky | currencyCode | 1 | |
| Currency | UtilsPriceCurrency | 2 | |
| dec10 | DecField_Ext | 1 | |
| description | UtilsAttributeDescription | 1 | |
| ProductAuthorizationGroup | ProductAuthorizationGroup | 4 | |
| ProductGroup | ProductGroup | 4 | |
| ProductType | ProductType | 4 | |
| string | StringField_Ext | 1 | |
| unit3 | unitOfMeasure | 1 | |
| UtilsSemanticsName1 | UtilsSemanticsName1 | 3 | |
| UtilsSemanticsName2 | UtilsSemanticsName2 | 3 | |
| UtilsTimeSliceDurationFrom | UtilsTimeSliceDurationFrom | 3 | |
| UtilsTimeSliceDurationTo | UtilsTimeSliceDurationTo | 3 | |
| UtilsTimeSliceDurationUoM | UtilsTimeSliceDurationUoM | 3 |
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 _A (
CHARACTERISTIC,
FAMILYNAME,
GIVENNAME,
UTILITIESPRODUCT,
WORKPLACEDEPARTMENTNAME,
_PRODUCTGROUP,
_PRODUCTTYPE,
CHAR1,
CHARCTOAMOUNT,
CHARCVALUE,
CHARCVALUEPOSITIONNUMBER,
CUKY,
CURRENCY,
DEC10,
DESCRIPTION,
PRODUCTAUTHORIZATIONGROUP,
PRODUCTGROUP,
PRODUCTTYPE,
STRING,
UNIT3,
UTILSSEMANTICSNAME1,
UTILSSEMANTICSNAME2,
UTILSTIMESLICEDURATIONFROM,
UTILSTIMESLICEDURATIONTO,
UTILSTIMESLICEDURATIONUOM,
PRIMARY KEY (CHARACTERISTIC, FAMILYNAME, GIVENNAME, UTILITIESPRODUCT, WORKPLACEDEPARTMENTNAME)
);
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