Fields (25)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | CostEstimate | CostEstimate | 1 |
| KEY | output_mrparea | output_mrparea | 1 |
| KEY | output_plant | output_plant | 1 |
| KEY | output_product | output_product | 1 |
| KEY | ProgramName | ProgramName | 2 |
| KEY | reference_id | reference_id | 1 |
| KEY | VariantId | VariantId | 2 |
| ApplJobTemplateText | ApplJobTemplateText | 2 | |
| bktxt | bktxt | 1 | |
| bukrs | bukrs | 1 | |
| bwkey | ValuationArea | 2 | |
| bwtar | InventoryValuationType | 2 | |
| JobCatalogEntryName | JobCatalogEntryName | 2 | |
| JobTemplateName | JobTemplateName | 2 | |
| kzbws | InventorySpecialStockValnType | 1 | |
| laufid | laufid | 1 | |
| lifnr | Supplier | 1 | |
| matnr | Material | 2 | |
| mlast | PriceDeterminationControl | 1 | |
| period | period | 1 | |
| posnr | SalesOrderItem | 1 | |
| sobkz | InvtryValnSpecialStockType | 1 | |
| Text | HdrText | 2 | |
| vbeln | SalesOrder | 1 | |
| xobew | IsSupplierStockValuation | 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 HD (
COSTESTIMATE,
OUTPUT_MRPAREA,
OUTPUT_PLANT,
OUTPUT_PRODUCT,
PROGRAMNAME,
REFERENCE_ID,
VARIANTID,
APPLJOBTEMPLATETEXT,
BKTXT,
BUKRS,
BWKEY,
BWTAR,
JOBCATALOGENTRYNAME,
JOBTEMPLATENAME,
KZBWS,
LAUFID,
LIFNR,
MATNR,
MLAST,
PERIOD,
POSNR,
SOBKZ,
TEXT,
VBELN,
XOBEW,
PRIMARY KEY (COSTESTIMATE, OUTPUT_MRPAREA, OUTPUT_PLANT, OUTPUT_PRODUCT, PROGRAMNAME, REFERENCE_ID, VARIANTID)
);
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