MARA_PRC

Transparent Table Application Table

Process Root Records Of OTC 194, Table MARA

MARA_PRC is an SAP database table in S/4HANA. Process Root Records Of OTC 194, Table MARA. It contains 272 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
I_ProdQualityManagementProc view_entity from BASIC
I_ProductProc view_entity from BASIC
I_ProductProcurementProc view_entity from BASIC
I_ProductSalesProc view_entity from BASIC
I_ProductStorageProc view_entity from BASIC

Fields (272)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY process_id MDC_PROCESS_ID Process ID
KEY process_step_no MDC_PROCESS_STEP_NO Process Step Number
KEY source_system MDC_BUSINESS_SYSTEM Source System
KEY source_id MDC_SOURCE_ID Source ID
matnr MATNR Material
ersda ERSDA Created On
created_at_time CREATED_AT_TIME Created Time
ernam ERNAM Created By
laeda LAEDA Last Change
aenam AENAM Changed By
vpsta VPSTA Complete status
pstat PSTAT_D Maint. Status
lvorm LVOMA DF client level
mtart MTART Material Type
mbrsh MBRSH Industry
matkl MATKL Material Group
bismt BISMT Old matl number
meins MEINS Base Unit
bstme BSTME Order Unit
zeinr DZEINR Document
zeiar DZEIAR Document Type
zeivr DZEIVR Doc. Version
zeifo DZEIFO Page Format
aeszn AESZN Doc. Change No.
blatt BLATT Page Number
blanz BLANZ No. Of Sheets
ferth FERTH Prod./insp.memo
formt FORMT Page format
groes GROES Size/dimensions
wrkst WRKST Basic material
normt NORMT Ind. Std Desc.
labor LABOR Lab/Office
ekwsl EKWSL Purch.value key
brgew BRGEW Gross Weight
ntgew NTGEW Net Weight
gewei GEWEI Unit of Weight
volum VOLUM Volume
voleh VOLEH Volume Unit
behvo BEHVO Container
raube RAUBE Stor.conditions
tempb TEMPB Temperature
disst DISST Low-Level Code
tragr TRAGR Trans. Group
stoff STOFF Haz. matl no.
spart SPART Division
kunnr WETTB Competitor
eannr EANNR EAN Number
wesch WESCH GR slips quantity
bwvor BWVOR Procure. rule
bwscl BWSCL Supply source
saiso SAISO Season
etiar ETIAR Label type
etifo ETIFO Label form
entar DUMMYENTAR Field deact.
ean11 EAN11 EAN/UPC
numtp NUMTP EAN category
laeng LAENG Length
breit BREIT Width
hoehe HOEHE Height
meabm MEABM Unit
prdha PRODH_D Prod. Hierarchy
aeklk CK_AEKLK Net Change Cstg
cadkz CADKZ CAD Indicator
qmpur QMPUR QM Procurement
ergew ERGEW Allowed Pkg wt
ergei ERGEI Unit of weight
ervol ERVOL Allowed Volume
ervoe ERVOE Volume unit
gewto GEWTO Excess wt tolerance
volto VOLTO Excess volume tol.
vabme VABME Var. Order Unit
kzrev KZREV Revision Level
kzkfg KZKFG Configrable Material
xchpf XCHPF Batch Mgmt Rqt
vhart VHIART Packag.Mat.Type
fuelg FUELG Maximum level
stfak STFAK Stacking factor
magrv MAGRV Matl Grp Pckmat
begru BEGRU AuthorizGroup
datab DATAB Valid From
liqdt LIQDT Valid To
saisj SAISJ Season Year
plgtp PLGTP Price band cat.
mlgut W_MITLEERG W/ empties BOM
extwg EXTWG Ext. Matl Group
satnr SATNR Cross-plant CM
attyp ATTYP Matl Category
kzkup KZKUPMAT Co-Product
kznfm KZNFM Follow-up matl
pmata PMATN Pr. Ref. Matl
mstae MSTAE X-Plant Status
mstav MSTAV X-DChain Status
mstde MSTDE Valid from
mstdv MSTDV Valid from
taklv TAKLV Tax class.
rbnrm RBNR Catalog Profile
mhdrz MHDRZ Rem. Shelf Life
mhdhb MHDHB Tot. shelf life
mhdlp MHDLP Storage %
inhme INHME Content Unit
inhal INHAL Net Contents
vpreh VPREH Comp.price unit
etiag ETIAG Label.matl grpg
inhbr INHBR Gross Contents
cmeth OIB_CMETH Conv. Method
cuobf CUOBM Int. object no.
kzumw KZUMW Envt. relevant
kosch KOSCH Prod.allocation
sprof SPROF Pricing profile
nrfhg NRFHG Disc. in kind
mfrpn MFRPN Mfr Part Number
mfrnr MFRNR Manufacturer
bmatn MPMAT Int. material no.
mprof MPROF Mfr Part Profile
kzwsm KZWSO Units meas. use
saity SAITY Rollout
profl ADGE_PROFL DGIndProfile
ihivi ADGE_IHIVI Highly viscous
iloos ADGE_ILOOS In bulk/liquid
serlv SERLV SerializLevel
kzgvh KZGVH Closed
xgchp XGCHP Batch rec. req.
kzeff CC_MTEFF Assign.eff.vals
compl CSCP_COMP_LVL Comp. Level
iprkz DATTP Period Ind.
rdmhd RDMHD Rounding rule
przus PRZUS ProdComposition
mtpos_mara MTPOS_MARA GenItemCatGroup
bflme BFLME Log. variants
matfi MATFI Material locked
cmrel DE_CM_RELEVANCE_FLAG CM Relevant
bbtyp BBTYP Astmt List Type
sled_bbd SLED_BBD Expiration Date
gtin_variant GTIN_VARIANT EAN Variant
gennr WSTR_SATNR_PP GenericMaterial
rmatp PL_RMATP Ref. mat. for pckg
gds_relevant GDS_RELEVANT GDS-Relevant
weora WEORA Origin Accept.
hutyp_dflt CIFHUTYPDF Stand. HU Type
pilferable CIFPILFRBL Pilferable
whstc CIFWHSTC Stor. Condition
whmatgr CIFWHMATGR WH Mat.Grp
hndlcode CIFHDLCODE Handling Ind.
hazmat CIFHAZMAT Haz. Sub.
hutyp CIFHUTYP HUTyp
tare_var CIFTAREVAR Variable TW
maxc CIFMAXC Max. Capacity
maxc_tol CIFMAXCTOL Overcapac. Tol.
maxl CIFMAXL Max.Length
maxb CIFMAXB Max. Pack Width
maxh CIFMAXH Max.Height
maxdim_uom CIFMAXDUOM Unit of Measure
herkl HERKL C/R of Origin
mfrgr MFRGR Mat.Freight Grp
qqtime CIFQQTIME Quarant.Per.
qqtimeuom CIFQQTIMEUOM Time Unit
qgrp CIFQGRP Qual.Insp.Grp
serial CIFSERIAL Serial No. Prf.
ps_smartform CIFPSSFNAME Form Name
logunit CIFLOGUNIT Logistics UoM
cwqrel CIFCWQREL CW-Relevant
cwqproc CIFCWQPROC CW Profile
cwqtolgr CIFCWQTOLGR Catch Wt Tol. Grp
adprof CIFADPROF Adjust. Profile
ipmipproduct CRM_PRODUCT_ID_IP Intel. Property
allow_pmat_igno WPM_ALLOW_PMAT_IGNO_MAT Var. Price Allowed
medium MEDIU Medium
commodity TBA_STOEFFCHEN Commodity
animal_origin WRF_ANIMAL_ORIGIN_FLAG Animal Origin
textile_comp_ind WRF_TEXTL_COMP_IND TexCompActive
last_changed_time LAST_CHANGED_TIME Last Chgd. Time
matnr_external MATNR_EXTERNAL Material
chml_cmplnc_rlvnce_ind CHML_CMPLNC_RLVNCE_IND Chemical Compliance Relevance Indicator
logistical_mat_category DE_LOGISTICAL_MAT_CATEGORY Logl Material Cat.
sales_material DE_SALES_MATERIAL Sales Material No.
identification_tag_type IDENTIFICATIONTAGTYPE Tag Type
productoid PRODUCT_OID Product OID
sdm_version SDM_MIG_STATUS_MARA SDM status
sgt_csgr SGT_CSGR Seg. Structure
sgt_covsa SGT_COVSA Seg. Strategy
sgt_stat SGT_STATD Seg. Status
sgt_scope SGT_SCOPE Seg. Scope
sgt_rel SGT_REL Seg. Relevant
anp J_1BANP ANP Code
psm_code WRF_PSM_CODE PSM code
fsh_mg_at1 FSH_MG_ATTRIBUTE1 Fsh. Attribute1
fsh_mg_at2 FSH_MG_ATTRIBUTE2 Fsh. Attribute2
fsh_mg_at3 FSH_MG_ATTRIBUTE3 Fsh. Attribute3
fsh_sealv FSH_SEALV Season Usage
fsh_seaim FSH_SEAIM Season Act. IM
fsh_sc_mid FSH_SC_MID Mat.Conv. ID
dummy_prd_incl_eew_ps PRD_INCL_EEW Dummy Field
scm_matid_guid16 /SCMB/MDL_MATID Product
scm_matid_guid22 /SAPAPO/MATID Product ID
scm_maturity_dur /SAPAPO/MATURITY_DUR Maturation Time
scm_shlf_lfe_req_min PRD_SCM_SHELF_LIFE_REQ_MIN Req.Min.Sh.Life
scm_shlf_lfe_req_max /SAPAPO/SHELF_LIFE_REQ_MAX Req.Max.Sh.Life
scm_puom /SCWM/DE_PUOM Preferred UoM
rmatp_pb /SAPAPO/MATNR_RMATP_PB Reference Product
prod_shape /SAPAPO/PROD_SHAPE Product Shape
mo_profile_id /SCMB/MO_PROFILE_ID Prod. Orient. Prof.
overhang_tresh /SAPAPO/OVERHANG_TRESH Overhang Threshold
bridge_tresh /SAPAPO/BRIDGE_TRESH Bridge Threshold
bridge_max_slope /SAPAPO/BRIDGE_MAX_SLOPE Maximum Slope
height_nonflat /SAPAPO/HEIGHT_NONFLAT Abs. Height Thresh.
height_nonflat_uom /SAPAPO/HEIGHT_NONFLAT_UOM Abs. Height Thresh.
scm_kitcomp /SAPAPO/CMPKIT Product for KITO
scm_prod_paoopt /SAPAPO/PAOOPT Procure to Order
scm_bod_deplvl /SAPAPO/BODDEPLVL PushDplnt from Suplr
scm_restrict_invbal /SAPAPO/RESTRICT_INVBAL No Invtry Balancing
scm_drp_gl_stock /SAPAPO/DRP_GL_STOCK Glob Stk Entry Loc
scm_excl_expedite /SAPAPO/EXCLEXP No Express Shipment
newprod_indi /SAPAPO/NEWPROD_INDI New Product
prd_startdt /SAPAPO/PRD_STARTDT Prod. Start Date
prd_enddt /SAPAPO/PRD_ENDDT Production End Date
inv_pln_mode ESPP_INV_PLN_MODE Invent. Plan. Mode
flagclass /SAPAPO/FLGCLASS Classified
packcode CBUNE_PACODE Packaging Code
dg_pack_status ADGE_DG_PACK_STATUS DG Pckg. Status
srv_dura CRMT_PR_DURATION Work Duration
srv_dura_uom CRMT_PR_DURATION_UOM Unit
srv_serwi SRV_SERWI Service Profile
srv_escal SRV_ESCAL Response Prof.
som_cycle CYCLE_KK Billing Cycle
som_cycle_rule CRM_ISX_CYCLE_RULE Billing Cycle Determ
som_tc_schema CRMT_TC_SCHEMA Assignment Schema
som_ctr_autorenewal CRMS4_SOM_CTR_AUTORENEWAL Ctr. Auto Renew Ind.
mcond DFPS_MCOND Condition Mgmt
retdelc DFPS_RETDELC Return Code
loglev_reto DFPS_LOGLEV_RETO Return to Log.Level
nsnid DFPS_NSNID NIIN
icfa DFS_ICFA Ammunition Code
ric_id /ISDFPS/RIC_ID RIC ID
dfs_sensitivity_key DFS_SENSITIVITY_KEY Sensitivity for Char
dfs_mfrp2 DFS_MFRP2 Long Mfr Part No.
ovlpn ADSPC_OPN Overlength Part Num
adspc_spc ADSPC_SPC Spare Prt Class Code
varid DI_VARID Var.Obj.ID.
msbookpartno DIMP_DRM_MSBOOKPART MS Book Part No
tolerance_type LMD_MDE_TOLERANCE_TYPE Tolerance Type
dpcbt MILL_DPCBT SU Btch Default Val.
xgrdt MILL_XGRDT Sng Un. Bch Rcp
imatn IMATN FFF class
picnum PIC_PICNUM_SUS Chain no
bstat WRFBSTAT Creation Status
color_atinn WRF_COLOR_ATINN Internal Char.
size1_atinn WRF_SIZE1_ATINN Internal Char.
size2_atinn WRF_SIZE2_ATINN Internal Char.
color WRF_COLOR Color
size1 WRF_SIZE1 Main Size
size2 WRF_SIZE2 Second Size
free_char WRF_FREE_CHAR Char. value
care_code WRF_CARE_CODE Care Code
brand_id WRF_BRAND_ID Brand
fiber_code1 WRF_FIBER_CODE_1 Component 1
fiber_part1 WRF_FIBER_PART_1 Perc. Share 1
fiber_code2 WRF_FIBER_CODE_2 Component 2
fiber_part2 WRF_FIBER_PART_2 Perc. Share 2
fiber_code3 WRF_FIBER_CODE_3 Component 3
fiber_part3 WRF_FIBER_PART_3 Perc. Share 3
fiber_code4 WRF_FIBER_CODE_4 Component 4
fiber_part4 WRF_FIBER_PART_4 Perc. Share 4
fiber_code5 WRF_FIBER_CODE_5 Component 5
fiber_part5 WRF_FIBER_PART_5 Perc. Share 5
fashgrd FASHGRD Fashion Grade
source_recency MDC_RECENCY Last Changed On
source_filter MDC_SOURCE_FILTER Data Package
validation_status MDC_VALIDATION_STATUS Status
source_modified MDC_SOURCE_MODIFIED Modified
source_modification_blip MDC_MODIFICATION_BLIP Modification
source_index MDC_SOURCE_INDEX Index

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.

-- Process Root Records Of OTC 194, Table MARA
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MARA_PRC (
    CLIENT,                    -- Client [MANDT]
    PROCESS_ID,                -- Process ID [MDC_PROCESS_ID]
    PROCESS_STEP_NO,           -- Process Step Number [MDC_PROCESS_STEP_NO]
    SOURCE_SYSTEM,             -- Source System [MDC_BUSINESS_SYSTEM]
    SOURCE_ID,                 -- Source ID [MDC_SOURCE_ID]
    MATNR,                     -- Material [MATNR]
    ERSDA,                     -- Created On [ERSDA]
    CREATED_AT_TIME,           -- Created Time [CREATED_AT_TIME]
    ERNAM,                     -- Created By [ERNAM]
    LAEDA,                     -- Last Change [LAEDA]
    AENAM,                     -- Changed By [AENAM]
    VPSTA,                     -- Complete status [VPSTA]
    PSTAT,                     -- Maint. Status [PSTAT_D]
    LVORM,                     -- DF client level [LVOMA]
    MTART,                     -- Material Type [MTART]
    MBRSH,                     -- Industry [MBRSH]
    MATKL,                     -- Material Group [MATKL]
    BISMT,                     -- Old matl number [BISMT]
    MEINS,                     -- Base Unit [MEINS]
    BSTME,                     -- Order Unit [BSTME]
    ZEINR,                     -- Document [DZEINR]
    ZEIAR,                     -- Document Type [DZEIAR]
    ZEIVR,                     -- Doc. Version [DZEIVR]
    ZEIFO,                     -- Page Format [DZEIFO]
    AESZN,                     -- Doc. Change No. [AESZN]
    BLATT,                     -- Page Number [BLATT]
    BLANZ,                     -- No. Of Sheets [BLANZ]
    FERTH,                     -- Prod./insp.memo [FERTH]
    FORMT,                     -- Page format [FORMT]
    GROES,                     -- Size/dimensions [GROES]
    WRKST,                     -- Basic material [WRKST]
    NORMT,                     -- Ind. Std Desc. [NORMT]
    LABOR,                     -- Lab/Office [LABOR]
    EKWSL,                     -- Purch.value key [EKWSL]
    BRGEW,                     -- Gross Weight [BRGEW]
    NTGEW,                     -- Net Weight [NTGEW]
    GEWEI,                     -- Unit of Weight [GEWEI]
    VOLUM,                     -- Volume [VOLUM]
    VOLEH,                     -- Volume Unit [VOLEH]
    BEHVO,                     -- Container [BEHVO]
    RAUBE,                     -- Stor.conditions [RAUBE]
    TEMPB,                     -- Temperature [TEMPB]
    DISST,                     -- Low-Level Code [DISST]
    TRAGR,                     -- Trans. Group [TRAGR]
    STOFF,                     -- Haz. matl no. [STOFF]
    SPART,                     -- Division [SPART]
    KUNNR,                     -- Competitor [WETTB]
    EANNR,                     -- EAN Number [EANNR]
    WESCH,                     -- GR slips quantity [WESCH]
    BWVOR,                     -- Procure. rule [BWVOR]
    BWSCL,                     -- Supply source [BWSCL]
    SAISO,                     -- Season [SAISO]
    ETIAR,                     -- Label type [ETIAR]
    ETIFO,                     -- Label form [ETIFO]
    ENTAR,                     -- Field deact. [DUMMYENTAR]
    EAN11,                     -- EAN/UPC [EAN11]
    NUMTP,                     -- EAN category [NUMTP]
    LAENG,                     -- Length [LAENG]
    BREIT,                     -- Width [BREIT]
    HOEHE,                     -- Height [HOEHE]
    MEABM,                     -- Unit [MEABM]
    PRDHA,                     -- Prod. Hierarchy [PRODH_D]
    AEKLK,                     -- Net Change Cstg [CK_AEKLK]
    CADKZ,                     -- CAD Indicator [CADKZ]
    QMPUR,                     -- QM Procurement [QMPUR]
    ERGEW,                     -- Allowed Pkg wt [ERGEW]
    ERGEI,                     -- Unit of weight [ERGEI]
    ERVOL,                     -- Allowed Volume [ERVOL]
    ERVOE,                     -- Volume unit [ERVOE]
    GEWTO,                     -- Excess wt tolerance [GEWTO]
    VOLTO,                     -- Excess volume tol. [VOLTO]
    VABME,                     -- Var. Order Unit [VABME]
    KZREV,                     -- Revision Level [KZREV]
    KZKFG,                     -- Configrable Material [KZKFG]
    XCHPF,                     -- Batch Mgmt Rqt [XCHPF]
    VHART,                     -- Packag.Mat.Type [VHIART]
    FUELG,                     -- Maximum level [FUELG]
    STFAK,                     -- Stacking factor [STFAK]
    MAGRV,                     -- Matl Grp Pckmat [MAGRV]
    BEGRU,                     -- AuthorizGroup [BEGRU]
    DATAB,                     -- Valid From [DATAB]
    LIQDT,                     -- Valid To [LIQDT]
    SAISJ,                     -- Season Year [SAISJ]
    PLGTP,                     -- Price band cat. [PLGTP]
    MLGUT,                     -- W/ empties BOM [W_MITLEERG]
    EXTWG,                     -- Ext. Matl Group [EXTWG]
    SATNR,                     -- Cross-plant CM [SATNR]
    ATTYP,                     -- Matl Category [ATTYP]
    KZKUP,                     -- Co-Product [KZKUPMAT]
    KZNFM,                     -- Follow-up matl [KZNFM]
    PMATA,                     -- Pr. Ref. Matl [PMATN]
    MSTAE,                     -- X-Plant Status [MSTAE]
    MSTAV,                     -- X-DChain Status [MSTAV]
    MSTDE,                     -- Valid from [MSTDE]
    MSTDV,                     -- Valid from [MSTDV]
    TAKLV,                     -- Tax class. [TAKLV]
    RBNRM,                     -- Catalog Profile [RBNR]
    MHDRZ,                     -- Rem. Shelf Life [MHDRZ]
    MHDHB,                     -- Tot. shelf life [MHDHB]
    MHDLP,                     -- Storage % [MHDLP]
    INHME,                     -- Content Unit [INHME]
    INHAL,                     -- Net Contents [INHAL]
    VPREH,                     -- Comp.price unit [VPREH]
    ETIAG,                     -- Label.matl grpg [ETIAG]
    INHBR,                     -- Gross Contents [INHBR]
    CMETH,                     -- Conv. Method [OIB_CMETH]
    CUOBF,                     -- Int. object no. [CUOBM]
    KZUMW,                     -- Envt. relevant [KZUMW]
    KOSCH,                     -- Prod.allocation [KOSCH]
    SPROF,                     -- Pricing profile [SPROF]
    NRFHG,                     -- Disc. in kind [NRFHG]
    MFRPN,                     -- Mfr Part Number [MFRPN]
    MFRNR,                     -- Manufacturer [MFRNR]
    BMATN,                     -- Int. material no. [MPMAT]
    MPROF,                     -- Mfr Part Profile [MPROF]
    KZWSM,                     -- Units meas. use [KZWSO]
    SAITY,                     -- Rollout [SAITY]
    PROFL,                     -- DGIndProfile [ADGE_PROFL]
    IHIVI,                     -- Highly viscous [ADGE_IHIVI]
    ILOOS,                     -- In bulk/liquid [ADGE_ILOOS]
    SERLV,                     -- SerializLevel [SERLV]
    KZGVH,                     -- Closed [KZGVH]
    XGCHP,                     -- Batch rec. req. [XGCHP]
    KZEFF,                     -- Assign.eff.vals [CC_MTEFF]
    COMPL,                     -- Comp. Level [CSCP_COMP_LVL]
    IPRKZ,                     -- Period Ind. [DATTP]
    RDMHD,                     -- Rounding rule [RDMHD]
    PRZUS,                     -- ProdComposition [PRZUS]
    MTPOS_MARA,                -- GenItemCatGroup [MTPOS_MARA]
    BFLME,                     -- Log. variants [BFLME]
    MATFI,                     -- Material locked [MATFI]
    CMREL,                     -- CM Relevant [DE_CM_RELEVANCE_FLAG]
    BBTYP,                     -- Astmt List Type [BBTYP]
    SLED_BBD,                  -- Expiration Date [SLED_BBD]
    GTIN_VARIANT,              -- EAN Variant [GTIN_VARIANT]
    GENNR,                     -- GenericMaterial [WSTR_SATNR_PP]
    RMATP,                     -- Ref. mat. for pckg [PL_RMATP]
    GDS_RELEVANT,              -- GDS-Relevant [GDS_RELEVANT]
    WEORA,                     -- Origin Accept. [WEORA]
    HUTYP_DFLT,                -- Stand. HU Type [CIFHUTYPDF]
    PILFERABLE,                -- Pilferable [CIFPILFRBL]
    WHSTC,                     -- Stor. Condition [CIFWHSTC]
    WHMATGR,                   -- WH Mat.Grp [CIFWHMATGR]
    HNDLCODE,                  -- Handling Ind. [CIFHDLCODE]
    HAZMAT,                    -- Haz. Sub. [CIFHAZMAT]
    HUTYP,                     -- HUTyp [CIFHUTYP]
    TARE_VAR,                  -- Variable TW [CIFTAREVAR]
    MAXC,                      -- Max. Capacity [CIFMAXC]
    MAXC_TOL,                  -- Overcapac. Tol. [CIFMAXCTOL]
    MAXL,                      -- Max.Length [CIFMAXL]
    MAXB,                      -- Max. Pack Width [CIFMAXB]
    MAXH,                      -- Max.Height [CIFMAXH]
    MAXDIM_UOM,                -- Unit of Measure [CIFMAXDUOM]
    HERKL,                     -- C/R of Origin [HERKL]
    MFRGR,                     -- Mat.Freight Grp [MFRGR]
    QQTIME,                    -- Quarant.Per. [CIFQQTIME]
    QQTIMEUOM,                 -- Time Unit [CIFQQTIMEUOM]
    QGRP,                      -- Qual.Insp.Grp [CIFQGRP]
    SERIAL,                    -- Serial No. Prf. [CIFSERIAL]
    PS_SMARTFORM,              -- Form Name [CIFPSSFNAME]
    LOGUNIT,                   -- Logistics UoM [CIFLOGUNIT]
    CWQREL,                    -- CW-Relevant [CIFCWQREL]
    CWQPROC,                   -- CW Profile [CIFCWQPROC]
    CWQTOLGR,                  -- Catch Wt Tol. Grp [CIFCWQTOLGR]
    ADPROF,                    -- Adjust. Profile [CIFADPROF]
    IPMIPPRODUCT,              -- Intel. Property [CRM_PRODUCT_ID_IP]
    ALLOW_PMAT_IGNO,           -- Var. Price Allowed [WPM_ALLOW_PMAT_IGNO_MAT]
    MEDIUM,                    -- Medium [MEDIU]
    COMMODITY,                 -- Commodity [TBA_STOEFFCHEN]
    ANIMAL_ORIGIN,             -- Animal Origin [WRF_ANIMAL_ORIGIN_FLAG]
    TEXTILE_COMP_IND,          -- TexCompActive [WRF_TEXTL_COMP_IND]
    LAST_CHANGED_TIME,         -- Last Chgd. Time [LAST_CHANGED_TIME]
    MATNR_EXTERNAL,            -- Material [MATNR_EXTERNAL]
    CHML_CMPLNC_RLVNCE_IND,    -- Chemical Compliance Relevance Indicator [CHML_CMPLNC_RLVNCE_IND]
    LOGISTICAL_MAT_CATEGORY,   -- Logl Material Cat. [DE_LOGISTICAL_MAT_CATEGORY]
    SALES_MATERIAL,            -- Sales Material No. [DE_SALES_MATERIAL]
    IDENTIFICATION_TAG_TYPE,   -- Tag Type [IDENTIFICATIONTAGTYPE]
    PRODUCTOID,                -- Product OID [PRODUCT_OID]
    SDM_VERSION,               -- SDM status [SDM_MIG_STATUS_MARA]
    SGT_CSGR,                  -- Seg. Structure [SGT_CSGR]
    SGT_COVSA,                 -- Seg. Strategy [SGT_COVSA]
    SGT_STAT,                  -- Seg. Status [SGT_STATD]
    SGT_SCOPE,                 -- Seg. Scope [SGT_SCOPE]
    SGT_REL,                   -- Seg. Relevant [SGT_REL]
    ANP,                       -- ANP Code [J_1BANP]
    PSM_CODE,                  -- PSM code [WRF_PSM_CODE]
    FSH_MG_AT1,                -- Fsh. Attribute1 [FSH_MG_ATTRIBUTE1]
    FSH_MG_AT2,                -- Fsh. Attribute2 [FSH_MG_ATTRIBUTE2]
    FSH_MG_AT3,                -- Fsh. Attribute3 [FSH_MG_ATTRIBUTE3]
    FSH_SEALV,                 -- Season Usage [FSH_SEALV]
    FSH_SEAIM,                 -- Season Act. IM [FSH_SEAIM]
    FSH_SC_MID,                -- Mat.Conv. ID [FSH_SC_MID]
    DUMMY_PRD_INCL_EEW_PS,     -- Dummy Field [PRD_INCL_EEW]
    SCM_MATID_GUID16,          -- Product [/SCMB/MDL_MATID]
    SCM_MATID_GUID22,          -- Product ID [/SAPAPO/MATID]
    SCM_MATURITY_DUR,          -- Maturation Time [/SAPAPO/MATURITY_DUR]
    SCM_SHLF_LFE_REQ_MIN,      -- Req.Min.Sh.Life [PRD_SCM_SHELF_LIFE_REQ_MIN]
    SCM_SHLF_LFE_REQ_MAX,      -- Req.Max.Sh.Life [/SAPAPO/SHELF_LIFE_REQ_MAX]
    SCM_PUOM,                  -- Preferred UoM [/SCWM/DE_PUOM]
    RMATP_PB,                  -- Reference Product [/SAPAPO/MATNR_RMATP_PB]
    PROD_SHAPE,                -- Product Shape [/SAPAPO/PROD_SHAPE]
    MO_PROFILE_ID,             -- Prod. Orient. Prof. [/SCMB/MO_PROFILE_ID]
    OVERHANG_TRESH,            -- Overhang Threshold [/SAPAPO/OVERHANG_TRESH]
    BRIDGE_TRESH,              -- Bridge Threshold [/SAPAPO/BRIDGE_TRESH]
    BRIDGE_MAX_SLOPE,          -- Maximum Slope [/SAPAPO/BRIDGE_MAX_SLOPE]
    HEIGHT_NONFLAT,            -- Abs. Height Thresh. [/SAPAPO/HEIGHT_NONFLAT]
    HEIGHT_NONFLAT_UOM,        -- Abs. Height Thresh. [/SAPAPO/HEIGHT_NONFLAT_UOM]
    SCM_KITCOMP,               -- Product for KITO [/SAPAPO/CMPKIT]
    SCM_PROD_PAOOPT,           -- Procure to Order [/SAPAPO/PAOOPT]
    SCM_BOD_DEPLVL,            -- PushDplnt from Suplr [/SAPAPO/BODDEPLVL]
    SCM_RESTRICT_INVBAL,       -- No Invtry Balancing [/SAPAPO/RESTRICT_INVBAL]
    SCM_DRP_GL_STOCK,          -- Glob Stk Entry Loc [/SAPAPO/DRP_GL_STOCK]
    SCM_EXCL_EXPEDITE,         -- No Express Shipment [/SAPAPO/EXCLEXP]
    NEWPROD_INDI,              -- New Product [/SAPAPO/NEWPROD_INDI]
    PRD_STARTDT,               -- Prod. Start Date [/SAPAPO/PRD_STARTDT]
    PRD_ENDDT,                 -- Production End Date [/SAPAPO/PRD_ENDDT]
    INV_PLN_MODE,              -- Invent. Plan. Mode [ESPP_INV_PLN_MODE]
    FLAGCLASS,                 -- Classified [/SAPAPO/FLGCLASS]
    PACKCODE,                  -- Packaging Code [CBUNE_PACODE]
    DG_PACK_STATUS,            -- DG Pckg. Status [ADGE_DG_PACK_STATUS]
    SRV_DURA,                  -- Work Duration [CRMT_PR_DURATION]
    SRV_DURA_UOM,              -- Unit [CRMT_PR_DURATION_UOM]
    SRV_SERWI,                 -- Service Profile [SRV_SERWI]
    SRV_ESCAL,                 -- Response Prof. [SRV_ESCAL]
    SOM_CYCLE,                 -- Billing Cycle [CYCLE_KK]
    SOM_CYCLE_RULE,            -- Billing Cycle Determ [CRM_ISX_CYCLE_RULE]
    SOM_TC_SCHEMA,             -- Assignment Schema [CRMT_TC_SCHEMA]
    SOM_CTR_AUTORENEWAL,       -- Ctr. Auto Renew Ind. [CRMS4_SOM_CTR_AUTORENEWAL]
    MCOND,                     -- Condition Mgmt [DFPS_MCOND]
    RETDELC,                   -- Return Code [DFPS_RETDELC]
    LOGLEV_RETO,               -- Return to Log.Level [DFPS_LOGLEV_RETO]
    NSNID,                     -- NIIN [DFPS_NSNID]
    ICFA,                      -- Ammunition Code [DFS_ICFA]
    RIC_ID,                    -- RIC ID [/ISDFPS/RIC_ID]
    DFS_SENSITIVITY_KEY,       -- Sensitivity for Char [DFS_SENSITIVITY_KEY]
    DFS_MFRP2,                 -- Long Mfr Part No. [DFS_MFRP2]
    OVLPN,                     -- Overlength Part Num [ADSPC_OPN]
    ADSPC_SPC,                 -- Spare Prt Class Code [ADSPC_SPC]
    VARID,                     -- Var.Obj.ID. [DI_VARID]
    MSBOOKPARTNO,              -- MS Book Part No [DIMP_DRM_MSBOOKPART]
    TOLERANCE_TYPE,            -- Tolerance Type [LMD_MDE_TOLERANCE_TYPE]
    DPCBT,                     -- SU Btch Default Val. [MILL_DPCBT]
    XGRDT,                     -- Sng Un. Bch Rcp [MILL_XGRDT]
    IMATN,                     -- FFF class [IMATN]
    PICNUM,                    -- Chain no [PIC_PICNUM_SUS]
    BSTAT,                     -- Creation Status [WRFBSTAT]
    COLOR_ATINN,               -- Internal Char. [WRF_COLOR_ATINN]
    SIZE1_ATINN,               -- Internal Char. [WRF_SIZE1_ATINN]
    SIZE2_ATINN,               -- Internal Char. [WRF_SIZE2_ATINN]
    COLOR,                     -- Color [WRF_COLOR]
    SIZE1,                     -- Main Size [WRF_SIZE1]
    SIZE2,                     -- Second Size [WRF_SIZE2]
    FREE_CHAR,                 -- Char. value [WRF_FREE_CHAR]
    CARE_CODE,                 -- Care Code [WRF_CARE_CODE]
    BRAND_ID,                  -- Brand [WRF_BRAND_ID]
    FIBER_CODE1,               -- Component 1 [WRF_FIBER_CODE_1]
    FIBER_PART1,               -- Perc. Share 1 [WRF_FIBER_PART_1]
    FIBER_CODE2,               -- Component 2 [WRF_FIBER_CODE_2]
    FIBER_PART2,               -- Perc. Share 2 [WRF_FIBER_PART_2]
    FIBER_CODE3,               -- Component 3 [WRF_FIBER_CODE_3]
    FIBER_PART3,               -- Perc. Share 3 [WRF_FIBER_PART_3]
    FIBER_CODE4,               -- Component 4 [WRF_FIBER_CODE_4]
    FIBER_PART4,               -- Perc. Share 4 [WRF_FIBER_PART_4]
    FIBER_CODE5,               -- Component 5 [WRF_FIBER_CODE_5]
    FIBER_PART5,               -- Perc. Share 5 [WRF_FIBER_PART_5]
    FASHGRD,                   -- Fashion Grade [FASHGRD]
    SOURCE_RECENCY,            -- Last Changed On [MDC_RECENCY]
    SOURCE_FILTER,             -- Data Package [MDC_SOURCE_FILTER]
    VALIDATION_STATUS,         -- Status [MDC_VALIDATION_STATUS]
    SOURCE_MODIFIED,           -- Modified [MDC_SOURCE_MODIFIED]
    SOURCE_MODIFICATION_BLIP,  -- Modification [MDC_MODIFICATION_BLIP]
    SOURCE_INDEX,              -- Index [MDC_SOURCE_INDEX]
    PRIMARY KEY (CLIENT, PROCESS_ID, PROCESS_STEP_NO, SOURCE_SYSTEM, SOURCE_ID)
);