HD

HD is an SAP database table in S/4HANA. It contains 25 fields.

Fields (25)

KeyField CDS FieldsUsed 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)
);