CRFH

Transparent Table Application Table
64 Fields 7 CDS Views

CIM production resource/tool master data

CRFH is an SAP database table in S/4HANA. CIM production resource/tool master data. It contains 64 fields. 7 CDS views read from this table.

CDS Views using this table (7)

ViewTypeJoinVDMDescription
I_MaintOrderOpProdnRsceTool view inner BASIC Maintenance Order Operation PRT
I_ProdnRsceToolMasterData view from BASIC Production Resource Tool Master Data
I_ProdnRtgDocPRTAssgmtDEX view_entity inner BASIC Prodn Routing Document PRT Assignment
I_ProdnRtgEquipPRTAssgmtDEX view_entity inner BASIC Prodn Routing Equipment PRT Assignment
I_ProdnRtgMatlPRTAssgmtDEX view_entity inner BASIC Prodn Routing Material PRT Assignment
I_ProdnRtgMiscPRTAssgmtDEX view_entity inner BASIC Prodn Rtg Miscellaneous PRT Assignment
I_RoutingPRTMasterDataSrchMod view_entity from BASIC Production Resource/Tool Master Data

Fields (64)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY objty CR_OBJTY Object Type
KEY objid CR_OBJID Object ID
KEY zaehl CIM_COUNT Counter
fhmar FHMAR PRT Category
objty_v CR_OBJTY Object Type
objid_v CR_OBJID Object ID
loekz CF_LOEKZ Deletion Flag
datuv DATUV Valid From
datub DATUB to
aennr AENNR Change Number
annam ANNAM Created by
andat ANDAT Created On
aenam AENAM Changed By
aedat AEDAT Changed On
brgru BRGRU Authorization
status CF_CRFHST Status
kzkbl KZKBL Load records
stowk CF_STOWK Plant
stort CF_STORT Location
baseh CF_BASEH Base Unit
steuf STEUF PRT Control Profile
steuf_ref CF_STKZR Reference ind.
fgru1 FGRUA Grouping Key 1
fgru2 FGRUB Grouping Key 2
planv FH_PLANV Usage
ktsch CF_KTSCH Std Text Key
ktsch_ref CF_KTKZR Reference ind.
bzoffb BZOFFB Reference Date
bzoffb_ref CF_BBKZR Reference ind.
offstb OFFSTB Offset
ehoffb EHOFFB Unit
offstb_ref CF_OBKZR Reference ind.
bzoffe BZOFFE Reference
bzoffe_ref CF_BEKZR Reference ind.
offste OFFSTE Offset to finsh
ehoffe EHOFFE Unit
offste_ref CF_OEKZR Reference ind.
mgform CF_MGFORM Formula
mgform_ref CF_MFKZR Reference ind.
ewform CF_EWFORM Formula
ewform_ref CF_EFKZR Reference ind.
par01 CF_PAR01 1st parameter
par02 CF_PAR02 2nd parameter
par03 CF_PAR03 3rd parameter
par04 CF_PAR04 4th parameter
par05 CF_PAR05 5th parameter
par06 CF_PAR06 6th parameter
paru1 CF_PARUNIT Unit
paru2 CF_PARUNIT Unit
paru3 CF_PARUNIT Unit
paru4 CF_PARUNIT Unit
paru5 CF_PARUNIT Unit
paru6 CF_PARUNIT Unit
parv1 CF_PARVAL Parameter value
parv2 CF_PARVAL Parameter value
parv3 CF_PARVAL Parameter value
parv4 CF_PARVAL Parameter value
parv5 CF_PARVAL Parameter value
parv6 CF_PARVAL Parameter value
registrable MPE_PRT_REGISTRABLE Registrable
tool_wc_objty CR_OBJTY Object Type
tool_wc_objid CR_OBJID Object ID
tool_wc_werks WERKS_D Plant

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.

-- CIM production resource/tool master data
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CRFH (
    MANDT,          -- Client [MANDT]
    OBJTY,          -- Object Type [CR_OBJTY]
    OBJID,          -- Object ID [CR_OBJID]
    ZAEHL,          -- Counter [CIM_COUNT]
    FHMAR,          -- PRT Category [FHMAR]
    OBJTY_V,        -- Object Type [CR_OBJTY]
    OBJID_V,        -- Object ID [CR_OBJID]
    LOEKZ,          -- Deletion Flag [CF_LOEKZ]
    DATUV,          -- Valid From [DATUV]
    DATUB,          -- to [DATUB]
    AENNR,          -- Change Number [AENNR]
    ANNAM,          -- Created by [ANNAM]
    ANDAT,          -- Created On [ANDAT]
    AENAM,          -- Changed By [AENAM]
    AEDAT,          -- Changed On [AEDAT]
    BRGRU,          -- Authorization [BRGRU]
    STATUS,         -- Status [CF_CRFHST]
    KZKBL,          -- Load records [KZKBL]
    STOWK,          -- Plant [CF_STOWK]
    STORT,          -- Location [CF_STORT]
    BASEH,          -- Base Unit [CF_BASEH]
    STEUF,          -- PRT Control Profile [STEUF]
    STEUF_REF,      -- Reference ind. [CF_STKZR]
    FGRU1,          -- Grouping Key 1 [FGRUA]
    FGRU2,          -- Grouping Key 2 [FGRUB]
    PLANV,          -- Usage [FH_PLANV]
    KTSCH,          -- Std Text Key [CF_KTSCH]
    KTSCH_REF,      -- Reference ind. [CF_KTKZR]
    BZOFFB,         -- Reference Date [BZOFFB]
    BZOFFB_REF,     -- Reference ind. [CF_BBKZR]
    OFFSTB,         -- Offset [OFFSTB]
    EHOFFB,         -- Unit [EHOFFB]
    OFFSTB_REF,     -- Reference ind. [CF_OBKZR]
    BZOFFE,         -- Reference [BZOFFE]
    BZOFFE_REF,     -- Reference ind. [CF_BEKZR]
    OFFSTE,         -- Offset to finsh [OFFSTE]
    EHOFFE,         -- Unit [EHOFFE]
    OFFSTE_REF,     -- Reference ind. [CF_OEKZR]
    MGFORM,         -- Formula [CF_MGFORM]
    MGFORM_REF,     -- Reference ind. [CF_MFKZR]
    EWFORM,         -- Formula [CF_EWFORM]
    EWFORM_REF,     -- Reference ind. [CF_EFKZR]
    PAR01,          -- 1st parameter [CF_PAR01]
    PAR02,          -- 2nd parameter [CF_PAR02]
    PAR03,          -- 3rd parameter [CF_PAR03]
    PAR04,          -- 4th parameter [CF_PAR04]
    PAR05,          -- 5th parameter [CF_PAR05]
    PAR06,          -- 6th parameter [CF_PAR06]
    PARU1,          -- Unit [CF_PARUNIT]
    PARU2,          -- Unit [CF_PARUNIT]
    PARU3,          -- Unit [CF_PARUNIT]
    PARU4,          -- Unit [CF_PARUNIT]
    PARU5,          -- Unit [CF_PARUNIT]
    PARU6,          -- Unit [CF_PARUNIT]
    PARV1,          -- Parameter value [CF_PARVAL]
    PARV2,          -- Parameter value [CF_PARVAL]
    PARV3,          -- Parameter value [CF_PARVAL]
    PARV4,          -- Parameter value [CF_PARVAL]
    PARV5,          -- Parameter value [CF_PARVAL]
    PARV6,          -- Parameter value [CF_PARVAL]
    REGISTRABLE,    -- Registrable [MPE_PRT_REGISTRABLE]
    TOOL_WC_OBJTY,  -- Object Type [CR_OBJTY]
    TOOL_WC_OBJID,  -- Object ID [CR_OBJID]
    TOOL_WC_WERKS,  -- Plant [WERKS_D]
    PRIMARY KEY (MANDT, OBJTY, OBJID, ZAEHL)
);

Learn More