CRHD

Transparent Table Application Table
127 Fields 9 CDS Views

Work Center Header

CRHD is an SAP database table in S/4HANA. Work Center Header. It contains 127 fields. 9 CDS views read from this table.

CDS Views using this table (9)

ViewTypeJoinVDMDescription
/merp/pm_workcenter view from CDS View: Workcenter
e_mrp_prod_demands view left_outer
I_FrcElmntWorkCenter view from BASIC Force elements by plant and Work Center
I_LineHierarchy view_entity inner BASIC Line Hierarchy
I_MaintenanceWorkCenterOrgUnit view from BASIC Work Center-to-Org Unit Assignment
I_Qm_FilterBar_OperationGroup view left_outer BASIC RR Filter Bar Inspection Operation Group
I_Qm_Workcenterinfo view from BASIC Workcenter Header
I_WorkCenter view from BASIC Work Center
P_FrcElmntOrgWrkCtr view from BASIC

Fields (127)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY objty cr_objty Object Type
KEY objid cr_objid Object ID
begda begdatum Start date
endda enddatum End Date
aedat_grnd aedtm Changed on
aenam_grnd usrname User Name
aedat_vora aedtm Changed on
aenam_vora usrname User Name
aedat_term aedtm Changed on
aenam_term usrname User Name
aedat_tech aedtm Changed on
aenam_tech usrname User Name
arbpl arbpl Work Center
werks werks_d Plant
verwe ap_verwe Work Center Category
lvorm ap_loevorm Deletion Flag
par01 ap_par01 1st parameter
par02 ap_par02 2nd parameter
par03 ap_par03 3rd parameter
par04 ap_par04 4th parameter
par05 ap_par05 5th parameter
par06 ap_par06 6th parameter
paru1 ap_parunit Unit
paru2 ap_parunit Unit
paru3 ap_parunit Unit
paru4 ap_parunit Unit
paru5 ap_parunit Unit
paru6 ap_parunit Unit
parv1 ap_parval Parameter value
parv2 ap_parval Parameter value
parv3 ap_parval Parameter value
parv4 ap_parval Parameter value
parv5 ap_parval Parameter value
parv6 ap_parval Parameter value
planv ap_planv Usage
stand ap_stand Location
veran ap_veran Responsible
vgwts vorgschl Std Value Key
vgm01 ap_vgw_mes Rule for maint.
vgm02 ap_vgw_mes Rule for maint.
vgm03 ap_vgw_mes Rule for maint.
vgm04 ap_vgw_mes Rule for maint.
vgm05 ap_vgw_mes Rule for maint.
vgm06 ap_vgw_mes Rule for maint.
xdefa ap_default Defaults
xkost ap_xkost Costs
xsprr ap_xsprr Locked
xterm ap_xterm Scheduling
zgr01 idzeitgrad Efficiency rate
zgr02 idzeitgrad Efficiency rate
zgr03 idzeitgrad Efficiency rate
zgr04 idzeitgrad Efficiency rate
zgr05 idzeitgrad Efficiency rate
zgr06 idzeitgrad Efficiency rate
ktsch ktsch Std Text Key
loanz lohnanz No.TimeTickets
loart lohnart Wage type
logrp lohngrp Wage Group
qualf qualf Suitability
rasch ruearschlu Setup Type Key
steus steus Control Key
vge01 vgwrteh Std value unit
vge02 vgwrteh Std value unit
vge03 vgwrteh Std value unit
vge04 vgwrteh Std value unit
vge05 vgwrteh Std value unit
vge06 vgwrteh Std value unit
ktsch_ref ktsch_ref Std Text Referenced
loart_ref loart_ref Wage Type Ref.
loanz_ref loanz_ref No. Time Ticktes Ref
logrp_ref logrp_ref Wage Group Ref.
qualf_ref qualf_ref Suitability Ref.
rasch_ref rasch_ref Setup Type Ref.
steus_ref steus_ref Control Profile Ref.
fort1 ap_form_t1 Setup Duration
fort2 ap_form_t2 Processing Time
fort3 ap_form_t3 Teardown Dur.
kapid kapid Capacity ID
ortgr ortsgruppe Location Group
zeiwn dzeiwn Std Queue Unit
zwnor dzwnor Std Queue Time
zeiwm dzeiwm Min. Queue Unit
zwmin dzwmin Min. Queue Time
formr flgformart Formula cap.
matyp matyp Machine Type
cplgr cplgr CAPP planner
sortb sortb Sort string
mtrvp mtrvp Setup
mtmvp mtmvp Machine
mtpvp mtpvp Labor
rsanz cr_rs_anz No. of Conf. Slips
pdest cr_pdest Printer
hroid hrobjid Object ID
fortn ap_form_tn Other formula
zgr01_ref ap_kzref Reference ind.
zgr02_ref ap_kzref Reference ind.
zgr03_ref ap_kzref Reference ind.
zgr04_ref ap_kzref Reference ind.
zgr05_ref ap_kzref Reference ind.
zgr06_ref ap_kzref Reference ind.
steus_c steus Control Key
steus_i steus Control Key
steus_n steus Control Key
steus_q steus Control Key
ruzus ruzus Rnd. & add.val.
rsanz_ref rsanz_ref No. Conf. Slips Ref.
hr ap_kzhr Wr.Cntr. in HR
prvbe prvbe Supply Area
subsys qeifsubsys QDR System
bdegr bdegr Grouping
rgekz rgekzap Backflush
hrtyp otype Object type
slwid slwid Field key
lifnr lifnr Supplier
slwid_ref ap_kzref Reference ind.
lifnr_ref ap_kzref Reference ind.
vgarb vgwrtar Work Unit
vgdim vgdimar Work dimension
hrplvar plvar Plan version
vgdau daunore Norm.duratn un.
stobj j_objnr Object number
resgr matrix_id Transit. matrix
lgort_res lgort_res Stor. loc. res.
mixmat mixmat MixMat. allowed
istbed_kz cy_istbedkz CalcActCpReqmts
lastchange_datetime cr_lastchange_datetime Date and Time of Last Change

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.

-- Work Center Header
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CRHD (
    MANDT,                -- Client [mandt]
    OBJTY,                -- Object Type [cr_objty]
    OBJID,                -- Object ID [cr_objid]
    BEGDA,                -- Start date [begdatum]
    ENDDA,                -- End Date [enddatum]
    AEDAT_GRND,           -- Changed on [aedtm]
    AENAM_GRND,           -- User Name [usrname]
    AEDAT_VORA,           -- Changed on [aedtm]
    AENAM_VORA,           -- User Name [usrname]
    AEDAT_TERM,           -- Changed on [aedtm]
    AENAM_TERM,           -- User Name [usrname]
    AEDAT_TECH,           -- Changed on [aedtm]
    AENAM_TECH,           -- User Name [usrname]
    ARBPL,                -- Work Center [arbpl]
    WERKS,                -- Plant [werks_d]
    VERWE,                -- Work Center Category [ap_verwe]
    LVORM,                -- Deletion Flag [ap_loevorm]
    PAR01,                -- 1st parameter [ap_par01]
    PAR02,                -- 2nd parameter [ap_par02]
    PAR03,                -- 3rd parameter [ap_par03]
    PAR04,                -- 4th parameter [ap_par04]
    PAR05,                -- 5th parameter [ap_par05]
    PAR06,                -- 6th parameter [ap_par06]
    PARU1,                -- Unit [ap_parunit]
    PARU2,                -- Unit [ap_parunit]
    PARU3,                -- Unit [ap_parunit]
    PARU4,                -- Unit [ap_parunit]
    PARU5,                -- Unit [ap_parunit]
    PARU6,                -- Unit [ap_parunit]
    PARV1,                -- Parameter value [ap_parval]
    PARV2,                -- Parameter value [ap_parval]
    PARV3,                -- Parameter value [ap_parval]
    PARV4,                -- Parameter value [ap_parval]
    PARV5,                -- Parameter value [ap_parval]
    PARV6,                -- Parameter value [ap_parval]
    PLANV,                -- Usage [ap_planv]
    STAND,                -- Location [ap_stand]
    VERAN,                -- Responsible [ap_veran]
    VGWTS,                -- Std Value Key [vorgschl]
    VGM01,                -- Rule for maint. [ap_vgw_mes]
    VGM02,                -- Rule for maint. [ap_vgw_mes]
    VGM03,                -- Rule for maint. [ap_vgw_mes]
    VGM04,                -- Rule for maint. [ap_vgw_mes]
    VGM05,                -- Rule for maint. [ap_vgw_mes]
    VGM06,                -- Rule for maint. [ap_vgw_mes]
    XDEFA,                -- Defaults [ap_default]
    XKOST,                -- Costs [ap_xkost]
    XSPRR,                -- Locked [ap_xsprr]
    XTERM,                -- Scheduling [ap_xterm]
    ZGR01,                -- Efficiency rate [idzeitgrad]
    ZGR02,                -- Efficiency rate [idzeitgrad]
    ZGR03,                -- Efficiency rate [idzeitgrad]
    ZGR04,                -- Efficiency rate [idzeitgrad]
    ZGR05,                -- Efficiency rate [idzeitgrad]
    ZGR06,                -- Efficiency rate [idzeitgrad]
    KTSCH,                -- Std Text Key [ktsch]
    LOANZ,                -- No.TimeTickets [lohnanz]
    LOART,                -- Wage type [lohnart]
    LOGRP,                -- Wage Group [lohngrp]
    QUALF,                -- Suitability [qualf]
    RASCH,                -- Setup Type Key [ruearschlu]
    STEUS,                -- Control Key [steus]
    VGE01,                -- Std value unit [vgwrteh]
    VGE02,                -- Std value unit [vgwrteh]
    VGE03,                -- Std value unit [vgwrteh]
    VGE04,                -- Std value unit [vgwrteh]
    VGE05,                -- Std value unit [vgwrteh]
    VGE06,                -- Std value unit [vgwrteh]
    KTSCH_REF,            -- Std Text Referenced [ktsch_ref]
    LOART_REF,            -- Wage Type Ref. [loart_ref]
    LOANZ_REF,            -- No. Time Ticktes Ref [loanz_ref]
    LOGRP_REF,            -- Wage Group Ref. [logrp_ref]
    QUALF_REF,            -- Suitability Ref. [qualf_ref]
    RASCH_REF,            -- Setup Type Ref. [rasch_ref]
    STEUS_REF,            -- Control Profile Ref. [steus_ref]
    FORT1,                -- Setup Duration [ap_form_t1]
    FORT2,                -- Processing Time [ap_form_t2]
    FORT3,                -- Teardown Dur. [ap_form_t3]
    KAPID,                -- Capacity ID [kapid]
    ORTGR,                -- Location Group [ortsgruppe]
    ZEIWN,                -- Std Queue Unit [dzeiwn]
    ZWNOR,                -- Std Queue Time [dzwnor]
    ZEIWM,                -- Min. Queue Unit [dzeiwm]
    ZWMIN,                -- Min. Queue Time [dzwmin]
    FORMR,                -- Formula cap. [flgformart]
    MATYP,                -- Machine Type [matyp]
    CPLGR,                -- CAPP planner [cplgr]
    SORTB,                -- Sort string [sortb]
    MTRVP,                -- Setup [mtrvp]
    MTMVP,                -- Machine [mtmvp]
    MTPVP,                -- Labor [mtpvp]
    RSANZ,                -- No. of Conf. Slips [cr_rs_anz]
    PDEST,                -- Printer [cr_pdest]
    HROID,                -- Object ID [hrobjid]
    FORTN,                -- Other formula [ap_form_tn]
    ZGR01_REF,            -- Reference ind. [ap_kzref]
    ZGR02_REF,            -- Reference ind. [ap_kzref]
    ZGR03_REF,            -- Reference ind. [ap_kzref]
    ZGR04_REF,            -- Reference ind. [ap_kzref]
    ZGR05_REF,            -- Reference ind. [ap_kzref]
    ZGR06_REF,            -- Reference ind. [ap_kzref]
    STEUS_C,              -- Control Key [steus]
    STEUS_I,              -- Control Key [steus]
    STEUS_N,              -- Control Key [steus]
    STEUS_Q,              -- Control Key [steus]
    RUZUS,                -- Rnd. & add.val. [ruzus]
    RSANZ_REF,            -- No. Conf. Slips Ref. [rsanz_ref]
    HR,                   -- Wr.Cntr. in HR [ap_kzhr]
    PRVBE,                -- Supply Area [prvbe]
    SUBSYS,               -- QDR System [qeifsubsys]
    BDEGR,                -- Grouping [bdegr]
    RGEKZ,                -- Backflush [rgekzap]
    HRTYP,                -- Object type [otype]
    SLWID,                -- Field key [slwid]
    LIFNR,                -- Supplier [lifnr]
    SLWID_REF,            -- Reference ind. [ap_kzref]
    LIFNR_REF,            -- Reference ind. [ap_kzref]
    VGARB,                -- Work Unit [vgwrtar]
    VGDIM,                -- Work dimension [vgdimar]
    HRPLVAR,              -- Plan version [plvar]
    VGDAU,                -- Norm.duratn un. [daunore]
    STOBJ,                -- Object number [j_objnr]
    RESGR,                -- Transit. matrix [matrix_id]
    LGORT_RES,            -- Stor. loc. res. [lgort_res]
    MIXMAT,               -- MixMat. allowed [mixmat]
    ISTBED_KZ,            -- CalcActCpReqmts [cy_istbedkz]
    LASTCHANGE_DATETIME,  -- Date and Time of Last Change [cr_lastchange_datetime]
    PRIMARY KEY (MANDT, OBJTY, OBJID)
);

Learn More