MARC
Plant Data for Material
MARC is an SAP database table in S/4HANA. Plant Data for Material. It contains 298 fields. 57 CDS views read from this table.
CDS Views using this table (57)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| E_Productplant | view | from | EXTENSION | Extension core view-product plant |
| F_Mmim_Marc_Dval | view_entity | from | Help View Null Values for Stock | |
| F_Mmim_Mard_Dval | view_entity | inner | Help View Null Values for Stock | |
| F_Mmim_Mcha_Dval | view_entity | inner | Help View Null Values for Stock | |
| F_Mmim_Mchb_Dval | view_entity | inner | Help View Null Values for Stock | |
| FSH_V_PLANNING_FILE_ENTRIES | view | left_outer | Planning File entries for Fashion | |
| I_BufferedMaterialPlant | view | from | BASIC | Plant Data for Buffered Material |
| I_MaterialConversionGrp | view | from | COMPOSITE | Material Conversion Group |
| I_MaterialPlant | view | from | BASIC | Material Plant |
| I_OIL_ProductPlant | view_entity | from | BASIC | Oil Specific Product Plant |
| I_PMRPProcurementType | view | from | BASIC | PMRP Procurement type |
| I_SupDmndMaterialPlant | view | inner | BASIC | Basic View for Material Plant |
| I_SupDmndOvwOpenDeliveries | view | inner | BASIC | Basic View for Open Deliveries |
| I_SupDmndOvwPlannedOrder | view | inner | BASIC | Basic View for Planned Order |
| I_SupDmndOvwProductionOrder | view | inner | BASIC | Basic View for Production Order |
| m_v_inforecord_sos | view | inner | MM-PUR: CDS View for SOS | |
| M_V_Inforecord_Sos_B | view | left_outer | MM-PUR: Basic CDS View for SOS | |
| m_v_outline_agreement_sos | view | inner | MM-PUR: CDS View for SOS | |
| Mbv_Srmerp_Css_Mat | view | inner | Compatibility view for /SRMERP/CCS_MAT view (ML integration) | |
| Mbv_V_Satz1 | view | inner | Compatibility view for V_SATZ1 view (ML integration) | |
| MDCV_E_DBVL | view | inner | Compatibility View for DBVL | |
| MDCV_E_DBVM | view | inner | Compatibility View for DBVM | |
| N_ProductPlant | view | from | Auxiliary view for Plant | |
| nsdm_e_marc | view | from | MARC Compatibility View | |
| Nsdm_E_Marc_Md | view | from | ||
| P_ADVNCDPLNGPRODPLANTMRP | view | inner | BASIC | |
| P_ADVNCDPLNGPRODUCTPLANT | view | from | BASIC | |
| P_DD_MAT_ADDLINFO | view_entity | inner | BASIC | Demand Driven Material information |
| P_DMVCMaterialValuation | view | inner | COMPOSITE | |
| P_InvtryMgmtMatlMstrVH | view | inner | BASIC | |
| P_InvtryMgmtSuplrInfoRecdVH | view | inner | BASIC | |
| P_MfgOrderCompProductPlant | view | inner | BASIC | |
| P_MRPMATERIAL | view | inner | BASIC | |
| P_ProdPlantPlndIndepRqmtBasic | view | from | BASIC | |
| P_ProductPlant | view | from | BASIC | |
| P_ProductPlantBasic | view | from | BASIC | |
| P_Productplantreferences | view | from | BASIC | |
| Pir_Keyfigures_Read_For_Sum | view | from | Read PIR Keyfigures | |
| Pir_Read_Aor_Heads | view | from | Read Header data in your area of responsibility | |
| PlndIndepRqmtPlanIndSum | view | inner | ||
| pp_mrp_read_planned_order_comp | view | left_outer | Read Planned Order Components | |
| pp_mrp_read_purchase_req | view | left_outer | Deprecated: Replaced by I_MRPPurchaseRequisition | |
| PPH_DD_MAT_CTRL_0 | view | inner | DD Materials | |
| pph_e_Mdub_1 | view | inner | ||
| PPH_E_MRBED_1 | view | inner | ||
| PPH_E_RESB_AGG | view | inner | ||
| PPH_E_RESB_FLEX | view | inner | ||
| PPH_E_VBBE_1 | view | inner | ||
| PPH_E_VBBE_AGG_1 | view | inner | ||
| PPH_MRP_CTRLR | view | left_outer | MRP Controller | |
| Pphmrp_Error_Mats | view | inner | Attributes for Displaying Materials with Issues in last MRP | |
| SHSM_H_MARC | view | from | CDS View for H_MARC (search help) | |
| SHSM_H_MARD | view | left_outer | CDS View for H_MARD (search help) | |
| v_ml_account_l2_view | view | left_outer | LOCAL: Material Ledger Periods | |
| v_ml_invtot_view | view | left_outer | LOCAL: Inventory Stock Totals | |
| V_MMIM_DDL_OM_BYPL | view | inner | Output Management: Get missing part aggr. per plant | |
| VC_INTEGRATION_MARC | view | from | Extraction for MARC |
Fields (298)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | matnr | MATNR | Material | |||
| KEY | werks | WERKS_D | Plant | |||
| pstat | PSTAT_D | Maint. Status | ||||
| lvorm | LVOWK | DF plant level | ||||
| bwtty | BWTTY_D | Valuation Cat. | ||||
| xchar | XCHAR | Batches | ||||
| mmsta | MMSTA | P-S Mat. Status | ||||
| mmstd | MMSTD | Valid From | ||||
| maabc | MAABC | ABC Indicator | ||||
| kzkri | KZKRI | Critical Part | ||||
| ekgrp | EKGRP | Purch. Group | ||||
| ausme | AUSME | Unit of Issue | ||||
| dispr | DISPR | MRP profile | ||||
| dismm | DISMM | MRP Type | ||||
| dispo | DISPO | MRP Controller | ||||
| kzdie | KZDIE | MRPCtrllr=buyer | ||||
| plifz | PLIFZ | Pl. Deliv. Time | ||||
| webaz | WEBAZ | GR proc. time | ||||
| perkz | PERKZ | Period Ind. | ||||
| ausss | AUSSS | Assembly scrap | ||||
| disls | DISLS | Lot Sizing Procedure | ||||
| beskz | BESKZ | Procurement | ||||
| sobsl | SOBSL | Special Procur. | ||||
| minbe | MINBE | Reorder Point | ||||
| eisbe | EISBE | Safety Stock | ||||
| bstmi | BSTMI | Min. Lot Size | ||||
| bstma | BSTMA | Max. Lot Size | ||||
| bstfe | BSTFE | Fixed lot size | ||||
| bstrf | BSTRF | Rounding value | ||||
| mabst | MABST | Max.Stock Level | ||||
| losfx | LOSFX | LSI Costs | ||||
| sbdkz | SBDKZ | Indiv./ Coll. | ||||
| lagpr | LAGPR | Storage Costs | ||||
| altsl | ALTSL | SelectionMethod | ||||
| kzaus | KZAUS | Discontin. ind. | ||||
| ausdt | AUSDT | Date | ||||
| nfmat | NFMAT | Follow-Up Matl | ||||
| kzbed | KZBED | Reqmts grouping | ||||
| miskz | MISKZ | Mixed MRP | ||||
| fhori | FHORI | Margin Key | ||||
| pfrei | PFREI | Autom. fix. pl. ords | ||||
| ffrei | FFREI | Autom. release | ||||
| rgekz | RGEKM | Backflush | ||||
| fevor | FEVOR | Prodn Supervisor | ||||
| bearz | BEARZ | Processing time | ||||
| ruezt | RUEZT | Setup time | ||||
| tranz | TRANZ | Interoperation | ||||
| basmg | BASMG | Base quantity | ||||
| dzeit | DZEIT | InhseProdTime | ||||
| maxlz | MAXLZ | Max. Storage | ||||
| lzeih | LZEIH | Time unit | ||||
| kzpro | KZPRO | Withd.fm.pr.bin | ||||
| gpmkz | GPMKZ | Rough-Cut Plng | ||||
| ueeto | UEETO | Overdeliv. Tol. | ||||
| ueetk | UEETK | Unlimited | ||||
| uneto | UNETO | Underdel. Tol. | ||||
| wzeit | WZEIT | Total RL time | ||||
| atpkz | ATPKZ | Replacemt Part | ||||
| vzusl | VZUSL | Surcharge % | ||||
| herbl | HERBL | State of manufac | ||||
| insmk | INSMK_MAT | Post to insp. stk | ||||
| sproz | SPROZ | Sample % | ||||
| quazt | QUAZT | Quarantine | ||||
| ssqss | QSSPUR | QM Control Key | ||||
| mpdau | MPDAU | Mean insp. dur. | ||||
| kzppv | KZPPV | Insp. plan ind. | ||||
| kzdkz | KZDKZ | Doc. required | ||||
| wstgh | WSTGH | Active subst. | ||||
| prfrq | PRFRQ | Insp. Interval | ||||
| nkmpr | NKMPR | Next inspection | ||||
| umlmc | UMLME | Stock in tfr | ||||
| ladgr | LADGR | Loading Group | ||||
| xchpf | XCHPF_WERKS | Batch Mgmt Rqt(Plnt) | ||||
| usequ | USEQU | Quota arr.usage | ||||
| lgrad | LGRAD | Service level | ||||
| auftl | AUFTL | Splitting | ||||
| plvar | PLVAR | Plan version | ||||
| otype | OTYPE | Object type | ||||
| objid | OBJEKTID | Object ID | ||||
| mtvfp | MTVFP | Avail. check | ||||
| periv | PERIV | FY Variant | ||||
| kzkfk | KZKFK | Corr. factors | ||||
| vrvez | VRVEZ | Setup time | ||||
| vbamg | VBAMG | Base quantity | ||||
| vbeaz | VBEAZ | Processing time | ||||
| lizyk | DUMMYLIZYK | Deactivated | ||||
| bwscl | BWSCL | Supply source | ||||
| kautb | KAUTB | Autom. PO | ||||
| kordb | KORDB | Source list | ||||
| stawn | STAWN | Commodity Code | ||||
| herkl | HERKL | C/R of Origin | ||||
| herkr | HERKR | Reg. of Origin | ||||
| expme | EXPME | Comm. code unit | ||||
| mtver | MTVER | Intrastat Group | ||||
| prctr | PRCTR | Profit Center | ||||
| trame | TRAME | Stk in Transit | ||||
| mrppp | MRPPP | Plan. Calendar | ||||
| sauft | SA_SAUFT | Repetitive Mfg | ||||
| fxhor | FXHOR | Plng time fence | ||||
| vrmod | VRMOD | Consmption mode | ||||
| vint1 | VINT1 | Bwd cons. per. | ||||
| vint2 | VINT2 | Fwd cons.period | ||||
| verkz | CK_VERK1 | Version | ||||
| stlal | STALT | Alternative | ||||
| stlan | STLAN | Usage | ||||
| plnnr | PLNNR | Group | ||||
| aplal | PLNAL | Group Counter | ||||
| losgr | CK_LOSGR | Cstg Lot Size | ||||
| sobsk | CK_SOBSL | SpecProcType | ||||
| frtme | FRTME | Production unit | ||||
| lgpro | LGPRO | Storage Location | ||||
| disgr | DISGR | MRP Group | ||||
| kausf | KAUSF | Component Scrap | ||||
| qzgtp | QZGTYP | CertificateType | ||||
| qmatv | QMATV | Insp. Setup | ||||
| takzt | TAKZT | Takt time | ||||
| rwpro | RWPRO | Coverage Prof. | ||||
| copam | COPAM | Field name | ||||
| abcin | ABCIN | CC Phys. Inv. | ||||
| awsls | AWSLS | Variance key | ||||
| sernp | SERAIL | SerialNoProfile | ||||
| cuobj | CUOBM | Int. object no. | ||||
| stdpd | STDPD | Conf. Material | ||||
| sfepr | SFEPR | REM Profile | ||||
| xmcng | XMCNG | Neg. Stocks | ||||
| qssys | QSSYS_SOLL | Target QM Sys. | ||||
| lfrhy | LFRHY | Planning Cycle | ||||
| rdprf | RDPRF | Rnding Profile | ||||
| vrbmt | VRBMT | Ref.matl: cons. | ||||
| vrbwk | VRBWK | Ref.plant:cons. | ||||
| vrbdt | VRBDT | Date to | ||||
| vrbfk | VRBFK | Multiplier | ||||
| autru | AUTRU | Autom.reset | ||||
| prefe | PREFE | Cus. Preference | ||||
| prenc | PRENC | Exemption cert. | ||||
| preno | PRENN | Exempt.cert.no. | ||||
| prend | PREND | Iss.date of crt | ||||
| prene | PRENE | Vendor decl. | ||||
| preng | PRENG | Vdr decl. date | ||||
| itark | ITARK | Military goods | ||||
| servg | W_SERVGRD | Service Level | ||||
| kzkup | KZKUPMAT | Co-Product | ||||
| strgr | STRGR | Strategy Group | ||||
| cuobv | CUOBV | Int. object no. | ||||
| lgfsb | LGFSB | Storage Location | ||||
| schgt | SCHGT | Bulk material | ||||
| ccfix | CCFIX | CC ind. fixed | ||||
| eprio | BF_GROUP | Stock Determ. Group | ||||
| qmata | QMATAUTH | QM Matl Auth. | ||||
| resvp | RESVP | Adjustmt period | ||||
| plnty | PLNTY | Task List Type | ||||
| uomgr | OIB_UOMGR | UoM Group | ||||
| umrsl | OIB_UMRSL | Conv. Group | ||||
| abfac | OIL_ABFAC | Air Buoy. Fact. | ||||
| sfcpf | CO_PRODPRF | Prod. Sched. Profile | ||||
| shflg | SHFLG | Safety Time Ind | ||||
| shzet | SHZET | Safety Time | ||||
| mdach | MDACH | Action Control | ||||
| kzech | KZECH | Enter batch | ||||
| megru | MEGRU | UoM Group | ||||
| mfrgr | MFRGR | Mat.Freight Grp | ||||
| sfty_stk_meth | MRP_SSTOCK_METHOD | Safety Stock Method | ||||
| profil | PPC_PROFILE_NAME | Backfl.Profile | ||||
| vkumc | VKUMC | Stk transfer SV | ||||
| vktrw | VKTRW | St.in trans./SP | ||||
| kzagl | KZAGL | Smth prom. cons | ||||
| fvidk | CK_VERID | Prod. Version | ||||
| fxpru | CK_FIXPRKU | Fixed-Price Co-Prod. | ||||
| loggr | LOGGR | Logistics group | ||||
| fprfm | FPRFM | Dist.prof. | ||||
| glgmg | GLGMG | Tied Empties | ||||
| vkglg | VKGLG | SlsVal.TiedEmpt | ||||
| indus | J_1BINDUS3 | Mat. category | ||||
| mownr | MOWNR | EU prod.list no. | ||||
| mogru | MOGRU | CAP prod. group | ||||
| casnr | CASNR | CAS no.(pharm.) | ||||
| gpnum | GPNUM | PRODCOM no. | ||||
| steuc | STEUC | Control Code | ||||
| fabkz | FABKZ | JIT Delivery | ||||
| matgr | MATNRGROUP | Mat. Grouping | ||||
| vspvb | VSPVB | Supply Area | ||||
| dplfs | DPLFS | Fair share rule | ||||
| dplpu | DPLPU | Push distribution | ||||
| dplho | DPLHO | Deploymnt hrzn | ||||
| minls | CSCP_MINLOTSIZE | Min. lot size | ||||
| maxls | CSCP_MAXLOTSIZE | Max. lot size | ||||
| fixls | CSCP_FIXLOTSIZE | Fix. lot size | ||||
| ltinc | CSCP_LOTINCREMENT | Lot size incr. | ||||
| compl | CSCP_DUMMY | This field is no longer used | ||||
| convt | CSCP_CONV_TYPE | Conv. type | ||||
| shpro | SHPRO | Time Profile | ||||
| ahdis | AHDIS | MRP Relevant | ||||
| diber | DIBER | MRP area exists | ||||
| kzpsp | KZPSP | Cross-Project | ||||
| ocmpf | OCM_GPROFILE | Overall profile | ||||
| apokz | APOKZ | Relevant to APO | ||||
| mcrue | MCRUE | MARDH rec. already exists for per. before last of MARD per. | ||||
| lfmon | LFMON | Current Period | ||||
| lfgja | LFGJA | Year Cur.Period | ||||
| eislo | EISLO | Min. Saf. Stock | ||||
| ncost | CK_NO_COSTING | Do Not Cost | ||||
| rotation_date | ROTATION_DATE | Putaway/StkRmvl | ||||
| uchkz | UCHKZ | OB Management | ||||
| ucmat | VBOB_OB_RFMAT | OB ref. matrial | ||||
| excise_tax_rlvnce | CMD_PRD_EXCISE_TAX_RLVNCE | Is Excise Tax Relevant | ||||
| temp_ctrl_max | /SCMTMS/TEMP_CONTROL_MAX | Max. Temp. | ||||
| temp_ctrl_min | /SCMTMS/TEMP_CONTROL_MIN | Min. Temp. | ||||
| temp_uom | /SCMTMS/TEMP_UOM | Temp. UoM | ||||
| jitprodnconfprofile | NJIT_PRODN_CONF_PROFILE | JIT Production Confirmation Profile | ||||
| bwesb | BWESB | Val. GR Blocked Stck | ||||
| sgt_covs | SGT_COVS | Segment. Strategy | ||||
| sgt_statc | SGT_STATC | Seg. Status MRP | ||||
| sgt_scope | SGT_SCOPE | Seg. Scope | ||||
| sgt_mrpsi | SGT_SRT_STK | Sort Stock | ||||
| sgt_prcm | SGT_PRCM | Cons. Prio. | ||||
| sgt_chint | SGT_CHINT | Discr.Batch No. | ||||
| sgt_stk_prt | SGT_STK_PRT | Stk Prot. | ||||
| sgt_defsc | SGT_DEFSC | Stock Segment | ||||
| sgt_mrp_atp_status | SGT_MRP_ATP_STATUS | ATP/MRP Status | ||||
| sgt_mmstd | SGT_MMSTD | Valid from | ||||
| fsh_mg_arun_req | FSH_MG_ARUN_REQ | ARun | ||||
| fsh_seaim | FSH_SEAIM | Season Act. IM | ||||
| fsh_var_group | FSH_VAR_GROUP | Variant Group | ||||
| fsh_kzech | FSH_KZECH | Batch Assignment | ||||
| fsh_calendar_group | FSH_CALENDAR_GROUP | Calendar Group | ||||
| arun_fix_batch | ARUN_FIX_BATCH | Assign Batches | ||||
| ppskz | PPSKZ | Advanced Planning | ||||
| cons_procg | WRF_CONS_PROCG | Consign.Control | ||||
| gi_pr_time | WRF_PSCD_WABAZ | GI Proc.Time | ||||
| multiple_ekgrp | WRF_POHF_OTHER_EKGRP_ALLOW | Across Purch.Group | ||||
| ref_schema | WRF_REF_SCHEMA | Deter. Schema | ||||
| min_troc | WRF_FRE_TROC_MIN | Minimum Target Range | ||||
| max_troc | WRF_FRE_TROC_MAX | Maximum Target Range | ||||
| target_stock | WRF_FRE_TARGET_STOCK | Target Stock | ||||
| nf_flag | /NFM/NFMAT | NF Metals | ||||
| scm_matlocid_guid16 | /SCMB/MDL_MATID | Product | ||||
| scm_matlocid_guid22 | /SAPAPO/MATLOCID | Loc. Prod. ID | ||||
| scm_grprt | /SAPAPO/GRPRT | GR Processng Time | ||||
| scm_giprt | /SAPAPO/GIPRT | GI Processng Time | ||||
| scm_scost | /SAPAPO/SCOST | Prod.Stor. Costs | ||||
| scm_reldt | /SAPAPO/RELDT | Repl. Lead Time | ||||
| scm_rrp_type | /SAPAPO/PPS_PLANNING_TYPE | PP Plng Proced. | ||||
| scm_heur_id | /SAPAPO/PROD_HEUR_ID | Heuristic | ||||
| scm_package_id | /SAPAPO/PROD_HEUR_PACKID | Plan. Package | ||||
| scm_sspen | /SAPAPO/SSPEN | Safety Stk Pen. | ||||
| scm_get_alerts | /SAPAPO/GET_ALERTS_FOR_PROD | Product Alerts | ||||
| scm_res_net_name | /SAPAPO/RESNET_NETNAME | Network name | ||||
| scm_conhap | /SAPAPO/SNPCONHAP | GR Handlg Cap. Cons. | ||||
| scm_hunit | /SAPAPO/HUNIT | UoM:HandlCap GR | ||||
| scm_conhap_out | /SAPAPO/SNPCONHAP_OUT | GI Handlg Cap. Cons. | ||||
| scm_hunit_out | /SAPAPO/HUNIT_OUT | UoM:HandlCap GI | ||||
| scm_shelf_life_loc | /SAPAPO/SHELF_LIFE_LOC_FLAG | Shelf Life(Loc) | ||||
| scm_shelf_life_dur | /SAPAPO/SHELF_LIFE_DUR_L | Loc. Shelf Life | ||||
| scm_maturity_dur | /SAPAPO/MATURITY_DUR_L | Loc. Matur.Time | ||||
| scm_shlf_lfe_req_min | /SAPAPO/SHELF_LIFE_REQ_MIN_L | Min. Shelf Life | ||||
| scm_shlf_lfe_req_max | /SAPAPO/SHELF_LIFE_REQ_MAX_L | Max. Shelf Life | ||||
| scm_lsuom | /SAPAPO/LSUOM | Lot Size Unit | ||||
| scm_reord_dur | /SAPAPO/REORD_DUR | Reorder DS | ||||
| scm_target_dur | /SAPAPO/TARGET_DUR | Trgt Days' Sup. | ||||
| scm_tstrid | /SAPAPO/LOT_TSTRID | Per.LS Plng Cal | ||||
| scm_stra1 | /SAPAPO/STRA1 | Requirement Str. | ||||
| scm_peg_past_alert | /SAPAPO/DM_PEGGING_PAST_ALERT | Pegg.AlertBack | ||||
| scm_peg_future_alert | /SAPAPO/DM_PEGGING_FUTUR_ALERT | Pegg.Alert | ||||
| scm_peg_strategy | /SAPAPO/PEG_STRATEGY | Peggng Strategy | ||||
| scm_peg_wo_alert_fst | /SAPAPO/PEG_WO_ALERT_FIRST | Avoid Alerts | ||||
| scm_fixpeg_prod_set | /SAPAPO/DM_FIXPEG_PROD_SETTING | Fixed Pegging | ||||
| scm_whatbom | /SAPAPO/WHATBOM | Plan Explosion | ||||
| scm_rrp_sel_group | /SAPAPO/RRP_SEL_GROUP | Planning Group | ||||
| scm_intsrc_prof | /SAPAPO/CDPS_INTSRC_PROF | Profile | ||||
| scm_prio | /SAPAPO/PRIO | Priority | ||||
| scm_min_pass_amount | /SAPAPO/MIN_PASS_AMOUNT | Min Passing Amt | ||||
| scm_profid | /SAPAPO/PROF_EXEC_CHECK_P | Conversion Rule | ||||
| scm_ges_mng_use | /SAPAPO/GES_MNG_USE | Entire Receipt | ||||
| scm_ges_bst_use | /SAPAPO/GES_BST_USE | Entire Stock | ||||
| esppflg | ESPPFLG | Extended SPP | ||||
| scm_thruput_time | /SAPAPO/THRUPUT_TIME | Throughput Time | ||||
| scm_tpop | /SAPAPO/TPOP | TPOP | ||||
| scm_safty_v | SAFTYV | Safety Stock for VCL | ||||
| scm_ppsaftystk | PPSAFTYSTK | SFT Parent Location | ||||
| scm_ppsaftystk_v | PPSAFTYSTKV | SFT Parent Loc. VCL | ||||
| scm_repsafty | REPSAFTY | Rep. Safety St. | ||||
| scm_repsafty_v | REPSAFTYV | Rep. SFT f. VCL | ||||
| scm_reord_v | REORD_V | Reord. Point (VCL) | ||||
| scm_maxstock_v | MAXSTOCK_V | Maximum Stock (VCL) | ||||
| scm_scost_prcnt | /SAPAPO/PERCENT_SCOST | Holding Cost Factor | ||||
| scm_proc_cost | /SAPAPO/PROC_COST | Procuremt Costs | ||||
| scm_ndcostwe | NDCOSTWE | GR Costs | ||||
| scm_ndcostwa | NDCOSTWA | GI Costs | ||||
| scm_coninp | /SAPAPO/SNPCONINP | Stor. Consumptn | ||||
| conf_gmsync | /SAPAPO/PPC_GMSYNC | Sync.GI Posting | ||||
| scm_iunit | /SAPAPO/UNIT | Unit of Meas. | ||||
| scm_sft_lock | /SAPAPO/SFT_OVRRIDE | SS Override | ||||
| dummy_plnt_incl_eew_ps | PLNT_INCL_EEW | MD product plant extensible field element | ||||
| iuid_relevant | IUID_RELEVANT | IUID-Relevant | ||||
| iuid_type | IUID_TYPE | IUID Type | ||||
| uid_iea | UID_IEA | Ext. Allocation | ||||
| dpcbt | MILL_DPCBT | SU Btch Default Val. |
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.
-- Plant Data for Material
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MARC (
MANDT, -- Client [MANDT]
MATNR, -- Material [MATNR]
WERKS, -- Plant [WERKS_D]
PSTAT, -- Maint. Status [PSTAT_D]
LVORM, -- DF plant level [LVOWK]
BWTTY, -- Valuation Cat. [BWTTY_D]
XCHAR, -- Batches [XCHAR]
MMSTA, -- P-S Mat. Status [MMSTA]
MMSTD, -- Valid From [MMSTD]
MAABC, -- ABC Indicator [MAABC]
KZKRI, -- Critical Part [KZKRI]
EKGRP, -- Purch. Group [EKGRP]
AUSME, -- Unit of Issue [AUSME]
DISPR, -- MRP profile [DISPR]
DISMM, -- MRP Type [DISMM]
DISPO, -- MRP Controller [DISPO]
KZDIE, -- MRPCtrllr=buyer [KZDIE]
PLIFZ, -- Pl. Deliv. Time [PLIFZ]
WEBAZ, -- GR proc. time [WEBAZ]
PERKZ, -- Period Ind. [PERKZ]
AUSSS, -- Assembly scrap [AUSSS]
DISLS, -- Lot Sizing Procedure [DISLS]
BESKZ, -- Procurement [BESKZ]
SOBSL, -- Special Procur. [SOBSL]
MINBE, -- Reorder Point [MINBE]
EISBE, -- Safety Stock [EISBE]
BSTMI, -- Min. Lot Size [BSTMI]
BSTMA, -- Max. Lot Size [BSTMA]
BSTFE, -- Fixed lot size [BSTFE]
BSTRF, -- Rounding value [BSTRF]
MABST, -- Max.Stock Level [MABST]
LOSFX, -- LSI Costs [LOSFX]
SBDKZ, -- Indiv./ Coll. [SBDKZ]
LAGPR, -- Storage Costs [LAGPR]
ALTSL, -- SelectionMethod [ALTSL]
KZAUS, -- Discontin. ind. [KZAUS]
AUSDT, -- Date [AUSDT]
NFMAT, -- Follow-Up Matl [NFMAT]
KZBED, -- Reqmts grouping [KZBED]
MISKZ, -- Mixed MRP [MISKZ]
FHORI, -- Margin Key [FHORI]
PFREI, -- Autom. fix. pl. ords [PFREI]
FFREI, -- Autom. release [FFREI]
RGEKZ, -- Backflush [RGEKM]
FEVOR, -- Prodn Supervisor [FEVOR]
BEARZ, -- Processing time [BEARZ]
RUEZT, -- Setup time [RUEZT]
TRANZ, -- Interoperation [TRANZ]
BASMG, -- Base quantity [BASMG]
DZEIT, -- InhseProdTime [DZEIT]
MAXLZ, -- Max. Storage [MAXLZ]
LZEIH, -- Time unit [LZEIH]
KZPRO, -- Withd.fm.pr.bin [KZPRO]
GPMKZ, -- Rough-Cut Plng [GPMKZ]
UEETO, -- Overdeliv. Tol. [UEETO]
UEETK, -- Unlimited [UEETK]
UNETO, -- Underdel. Tol. [UNETO]
WZEIT, -- Total RL time [WZEIT]
ATPKZ, -- Replacemt Part [ATPKZ]
VZUSL, -- Surcharge % [VZUSL]
HERBL, -- State of manufac [HERBL]
INSMK, -- Post to insp. stk [INSMK_MAT]
SPROZ, -- Sample % [SPROZ]
QUAZT, -- Quarantine [QUAZT]
SSQSS, -- QM Control Key [QSSPUR]
MPDAU, -- Mean insp. dur. [MPDAU]
KZPPV, -- Insp. plan ind. [KZPPV]
KZDKZ, -- Doc. required [KZDKZ]
WSTGH, -- Active subst. [WSTGH]
PRFRQ, -- Insp. Interval [PRFRQ]
NKMPR, -- Next inspection [NKMPR]
UMLMC, -- Stock in tfr [UMLME]
LADGR, -- Loading Group [LADGR]
XCHPF, -- Batch Mgmt Rqt(Plnt) [XCHPF_WERKS]
USEQU, -- Quota arr.usage [USEQU]
LGRAD, -- Service level [LGRAD]
AUFTL, -- Splitting [AUFTL]
PLVAR, -- Plan version [PLVAR]
OTYPE, -- Object type [OTYPE]
OBJID, -- Object ID [OBJEKTID]
MTVFP, -- Avail. check [MTVFP]
PERIV, -- FY Variant [PERIV]
KZKFK, -- Corr. factors [KZKFK]
VRVEZ, -- Setup time [VRVEZ]
VBAMG, -- Base quantity [VBAMG]
VBEAZ, -- Processing time [VBEAZ]
LIZYK, -- Deactivated [DUMMYLIZYK]
BWSCL, -- Supply source [BWSCL]
KAUTB, -- Autom. PO [KAUTB]
KORDB, -- Source list [KORDB]
STAWN, -- Commodity Code [STAWN]
HERKL, -- C/R of Origin [HERKL]
HERKR, -- Reg. of Origin [HERKR]
EXPME, -- Comm. code unit [EXPME]
MTVER, -- Intrastat Group [MTVER]
PRCTR, -- Profit Center [PRCTR]
TRAME, -- Stk in Transit [TRAME]
MRPPP, -- Plan. Calendar [MRPPP]
SAUFT, -- Repetitive Mfg [SA_SAUFT]
FXHOR, -- Plng time fence [FXHOR]
VRMOD, -- Consmption mode [VRMOD]
VINT1, -- Bwd cons. per. [VINT1]
VINT2, -- Fwd cons.period [VINT2]
VERKZ, -- Version [CK_VERK1]
STLAL, -- Alternative [STALT]
STLAN, -- Usage [STLAN]
PLNNR, -- Group [PLNNR]
APLAL, -- Group Counter [PLNAL]
LOSGR, -- Cstg Lot Size [CK_LOSGR]
SOBSK, -- SpecProcType [CK_SOBSL]
FRTME, -- Production unit [FRTME]
LGPRO, -- Storage Location [LGPRO]
DISGR, -- MRP Group [DISGR]
KAUSF, -- Component Scrap [KAUSF]
QZGTP, -- CertificateType [QZGTYP]
QMATV, -- Insp. Setup [QMATV]
TAKZT, -- Takt time [TAKZT]
RWPRO, -- Coverage Prof. [RWPRO]
COPAM, -- Field name [COPAM]
ABCIN, -- CC Phys. Inv. [ABCIN]
AWSLS, -- Variance key [AWSLS]
SERNP, -- SerialNoProfile [SERAIL]
CUOBJ, -- Int. object no. [CUOBM]
STDPD, -- Conf. Material [STDPD]
SFEPR, -- REM Profile [SFEPR]
XMCNG, -- Neg. Stocks [XMCNG]
QSSYS, -- Target QM Sys. [QSSYS_SOLL]
LFRHY, -- Planning Cycle [LFRHY]
RDPRF, -- Rnding Profile [RDPRF]
VRBMT, -- Ref.matl: cons. [VRBMT]
VRBWK, -- Ref.plant:cons. [VRBWK]
VRBDT, -- Date to [VRBDT]
VRBFK, -- Multiplier [VRBFK]
AUTRU, -- Autom.reset [AUTRU]
PREFE, -- Cus. Preference [PREFE]
PRENC, -- Exemption cert. [PRENC]
PRENO, -- Exempt.cert.no. [PRENN]
PREND, -- Iss.date of crt [PREND]
PRENE, -- Vendor decl. [PRENE]
PRENG, -- Vdr decl. date [PRENG]
ITARK, -- Military goods [ITARK]
SERVG, -- Service Level [W_SERVGRD]
KZKUP, -- Co-Product [KZKUPMAT]
STRGR, -- Strategy Group [STRGR]
CUOBV, -- Int. object no. [CUOBV]
LGFSB, -- Storage Location [LGFSB]
SCHGT, -- Bulk material [SCHGT]
CCFIX, -- CC ind. fixed [CCFIX]
EPRIO, -- Stock Determ. Group [BF_GROUP]
QMATA, -- QM Matl Auth. [QMATAUTH]
RESVP, -- Adjustmt period [RESVP]
PLNTY, -- Task List Type [PLNTY]
UOMGR, -- UoM Group [OIB_UOMGR]
UMRSL, -- Conv. Group [OIB_UMRSL]
ABFAC, -- Air Buoy. Fact. [OIL_ABFAC]
SFCPF, -- Prod. Sched. Profile [CO_PRODPRF]
SHFLG, -- Safety Time Ind [SHFLG]
SHZET, -- Safety Time [SHZET]
MDACH, -- Action Control [MDACH]
KZECH, -- Enter batch [KZECH]
MEGRU, -- UoM Group [MEGRU]
MFRGR, -- Mat.Freight Grp [MFRGR]
SFTY_STK_METH, -- Safety Stock Method [MRP_SSTOCK_METHOD]
PROFIL, -- Backfl.Profile [PPC_PROFILE_NAME]
VKUMC, -- Stk transfer SV [VKUMC]
VKTRW, -- St.in trans./SP [VKTRW]
KZAGL, -- Smth prom. cons [KZAGL]
FVIDK, -- Prod. Version [CK_VERID]
FXPRU, -- Fixed-Price Co-Prod. [CK_FIXPRKU]
LOGGR, -- Logistics group [LOGGR]
FPRFM, -- Dist.prof. [FPRFM]
GLGMG, -- Tied Empties [GLGMG]
VKGLG, -- SlsVal.TiedEmpt [VKGLG]
INDUS, -- Mat. category [J_1BINDUS3]
MOWNR, -- EU prod.list no. [MOWNR]
MOGRU, -- CAP prod. group [MOGRU]
CASNR, -- CAS no.(pharm.) [CASNR]
GPNUM, -- PRODCOM no. [GPNUM]
STEUC, -- Control Code [STEUC]
FABKZ, -- JIT Delivery [FABKZ]
MATGR, -- Mat. Grouping [MATNRGROUP]
VSPVB, -- Supply Area [VSPVB]
DPLFS, -- Fair share rule [DPLFS]
DPLPU, -- Push distribution [DPLPU]
DPLHO, -- Deploymnt hrzn [DPLHO]
MINLS, -- Min. lot size [CSCP_MINLOTSIZE]
MAXLS, -- Max. lot size [CSCP_MAXLOTSIZE]
FIXLS, -- Fix. lot size [CSCP_FIXLOTSIZE]
LTINC, -- Lot size incr. [CSCP_LOTINCREMENT]
COMPL, -- This field is no longer used [CSCP_DUMMY]
CONVT, -- Conv. type [CSCP_CONV_TYPE]
SHPRO, -- Time Profile [SHPRO]
AHDIS, -- MRP Relevant [AHDIS]
DIBER, -- MRP area exists [DIBER]
KZPSP, -- Cross-Project [KZPSP]
OCMPF, -- Overall profile [OCM_GPROFILE]
APOKZ, -- Relevant to APO [APOKZ]
MCRUE, -- MARDH rec. already exists for per. before last of MARD per. [MCRUE]
LFMON, -- Current Period [LFMON]
LFGJA, -- Year Cur.Period [LFGJA]
EISLO, -- Min. Saf. Stock [EISLO]
NCOST, -- Do Not Cost [CK_NO_COSTING]
ROTATION_DATE, -- Putaway/StkRmvl [ROTATION_DATE]
UCHKZ, -- OB Management [UCHKZ]
UCMAT, -- OB ref. matrial [VBOB_OB_RFMAT]
EXCISE_TAX_RLVNCE, -- Is Excise Tax Relevant [CMD_PRD_EXCISE_TAX_RLVNCE]
TEMP_CTRL_MAX, -- Max. Temp. [/SCMTMS/TEMP_CONTROL_MAX]
TEMP_CTRL_MIN, -- Min. Temp. [/SCMTMS/TEMP_CONTROL_MIN]
TEMP_UOM, -- Temp. UoM [/SCMTMS/TEMP_UOM]
JITPRODNCONFPROFILE, -- JIT Production Confirmation Profile [NJIT_PRODN_CONF_PROFILE]
BWESB, -- Val. GR Blocked Stck [BWESB]
SGT_COVS, -- Segment. Strategy [SGT_COVS]
SGT_STATC, -- Seg. Status MRP [SGT_STATC]
SGT_SCOPE, -- Seg. Scope [SGT_SCOPE]
SGT_MRPSI, -- Sort Stock [SGT_SRT_STK]
SGT_PRCM, -- Cons. Prio. [SGT_PRCM]
SGT_CHINT, -- Discr.Batch No. [SGT_CHINT]
SGT_STK_PRT, -- Stk Prot. [SGT_STK_PRT]
SGT_DEFSC, -- Stock Segment [SGT_DEFSC]
SGT_MRP_ATP_STATUS, -- ATP/MRP Status [SGT_MRP_ATP_STATUS]
SGT_MMSTD, -- Valid from [SGT_MMSTD]
FSH_MG_ARUN_REQ, -- ARun [FSH_MG_ARUN_REQ]
FSH_SEAIM, -- Season Act. IM [FSH_SEAIM]
FSH_VAR_GROUP, -- Variant Group [FSH_VAR_GROUP]
FSH_KZECH, -- Batch Assignment [FSH_KZECH]
FSH_CALENDAR_GROUP, -- Calendar Group [FSH_CALENDAR_GROUP]
ARUN_FIX_BATCH, -- Assign Batches [ARUN_FIX_BATCH]
PPSKZ, -- Advanced Planning [PPSKZ]
CONS_PROCG, -- Consign.Control [WRF_CONS_PROCG]
GI_PR_TIME, -- GI Proc.Time [WRF_PSCD_WABAZ]
MULTIPLE_EKGRP, -- Across Purch.Group [WRF_POHF_OTHER_EKGRP_ALLOW]
REF_SCHEMA, -- Deter. Schema [WRF_REF_SCHEMA]
MIN_TROC, -- Minimum Target Range [WRF_FRE_TROC_MIN]
MAX_TROC, -- Maximum Target Range [WRF_FRE_TROC_MAX]
TARGET_STOCK, -- Target Stock [WRF_FRE_TARGET_STOCK]
NF_FLAG, -- NF Metals [/NFM/NFMAT]
SCM_MATLOCID_GUID16, -- Product [/SCMB/MDL_MATID]
SCM_MATLOCID_GUID22, -- Loc. Prod. ID [/SAPAPO/MATLOCID]
SCM_GRPRT, -- GR Processng Time [/SAPAPO/GRPRT]
SCM_GIPRT, -- GI Processng Time [/SAPAPO/GIPRT]
SCM_SCOST, -- Prod.Stor. Costs [/SAPAPO/SCOST]
SCM_RELDT, -- Repl. Lead Time [/SAPAPO/RELDT]
SCM_RRP_TYPE, -- PP Plng Proced. [/SAPAPO/PPS_PLANNING_TYPE]
SCM_HEUR_ID, -- Heuristic [/SAPAPO/PROD_HEUR_ID]
SCM_PACKAGE_ID, -- Plan. Package [/SAPAPO/PROD_HEUR_PACKID]
SCM_SSPEN, -- Safety Stk Pen. [/SAPAPO/SSPEN]
SCM_GET_ALERTS, -- Product Alerts [/SAPAPO/GET_ALERTS_FOR_PROD]
SCM_RES_NET_NAME, -- Network name [/SAPAPO/RESNET_NETNAME]
SCM_CONHAP, -- GR Handlg Cap. Cons. [/SAPAPO/SNPCONHAP]
SCM_HUNIT, -- UoM:HandlCap GR [/SAPAPO/HUNIT]
SCM_CONHAP_OUT, -- GI Handlg Cap. Cons. [/SAPAPO/SNPCONHAP_OUT]
SCM_HUNIT_OUT, -- UoM:HandlCap GI [/SAPAPO/HUNIT_OUT]
SCM_SHELF_LIFE_LOC, -- Shelf Life(Loc) [/SAPAPO/SHELF_LIFE_LOC_FLAG]
SCM_SHELF_LIFE_DUR, -- Loc. Shelf Life [/SAPAPO/SHELF_LIFE_DUR_L]
SCM_MATURITY_DUR, -- Loc. Matur.Time [/SAPAPO/MATURITY_DUR_L]
SCM_SHLF_LFE_REQ_MIN, -- Min. Shelf Life [/SAPAPO/SHELF_LIFE_REQ_MIN_L]
SCM_SHLF_LFE_REQ_MAX, -- Max. Shelf Life [/SAPAPO/SHELF_LIFE_REQ_MAX_L]
SCM_LSUOM, -- Lot Size Unit [/SAPAPO/LSUOM]
SCM_REORD_DUR, -- Reorder DS [/SAPAPO/REORD_DUR]
SCM_TARGET_DUR, -- Trgt Days' Sup. [/SAPAPO/TARGET_DUR]
SCM_TSTRID, -- Per.LS Plng Cal [/SAPAPO/LOT_TSTRID]
SCM_STRA1, -- Requirement Str. [/SAPAPO/STRA1]
SCM_PEG_PAST_ALERT, -- Pegg.AlertBack [/SAPAPO/DM_PEGGING_PAST_ALERT]
SCM_PEG_FUTURE_ALERT, -- Pegg.Alert [/SAPAPO/DM_PEGGING_FUTUR_ALERT]
SCM_PEG_STRATEGY, -- Peggng Strategy [/SAPAPO/PEG_STRATEGY]
SCM_PEG_WO_ALERT_FST, -- Avoid Alerts [/SAPAPO/PEG_WO_ALERT_FIRST]
SCM_FIXPEG_PROD_SET, -- Fixed Pegging [/SAPAPO/DM_FIXPEG_PROD_SETTING]
SCM_WHATBOM, -- Plan Explosion [/SAPAPO/WHATBOM]
SCM_RRP_SEL_GROUP, -- Planning Group [/SAPAPO/RRP_SEL_GROUP]
SCM_INTSRC_PROF, -- Profile [/SAPAPO/CDPS_INTSRC_PROF]
SCM_PRIO, -- Priority [/SAPAPO/PRIO]
SCM_MIN_PASS_AMOUNT, -- Min Passing Amt [/SAPAPO/MIN_PASS_AMOUNT]
SCM_PROFID, -- Conversion Rule [/SAPAPO/PROF_EXEC_CHECK_P]
SCM_GES_MNG_USE, -- Entire Receipt [/SAPAPO/GES_MNG_USE]
SCM_GES_BST_USE, -- Entire Stock [/SAPAPO/GES_BST_USE]
ESPPFLG, -- Extended SPP [ESPPFLG]
SCM_THRUPUT_TIME, -- Throughput Time [/SAPAPO/THRUPUT_TIME]
SCM_TPOP, -- TPOP [/SAPAPO/TPOP]
SCM_SAFTY_V, -- Safety Stock for VCL [SAFTYV]
SCM_PPSAFTYSTK, -- SFT Parent Location [PPSAFTYSTK]
SCM_PPSAFTYSTK_V, -- SFT Parent Loc. VCL [PPSAFTYSTKV]
SCM_REPSAFTY, -- Rep. Safety St. [REPSAFTY]
SCM_REPSAFTY_V, -- Rep. SFT f. VCL [REPSAFTYV]
SCM_REORD_V, -- Reord. Point (VCL) [REORD_V]
SCM_MAXSTOCK_V, -- Maximum Stock (VCL) [MAXSTOCK_V]
SCM_SCOST_PRCNT, -- Holding Cost Factor [/SAPAPO/PERCENT_SCOST]
SCM_PROC_COST, -- Procuremt Costs [/SAPAPO/PROC_COST]
SCM_NDCOSTWE, -- GR Costs [NDCOSTWE]
SCM_NDCOSTWA, -- GI Costs [NDCOSTWA]
SCM_CONINP, -- Stor. Consumptn [/SAPAPO/SNPCONINP]
CONF_GMSYNC, -- Sync.GI Posting [/SAPAPO/PPC_GMSYNC]
SCM_IUNIT, -- Unit of Meas. [/SAPAPO/UNIT]
SCM_SFT_LOCK, -- SS Override [/SAPAPO/SFT_OVRRIDE]
DUMMY_PLNT_INCL_EEW_PS, -- MD product plant extensible field element [PLNT_INCL_EEW]
IUID_RELEVANT, -- IUID-Relevant [IUID_RELEVANT]
IUID_TYPE, -- IUID Type [IUID_TYPE]
UID_IEA, -- Ext. Allocation [UID_IEA]
DPCBT, -- SU Btch Default Val. [MILL_DPCBT]
PRIMARY KEY (MANDT, MATNR, WERKS)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- 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