MARA

Transparent Table Application Table
262 Fields 208 CDS Views

General Material Data

MARA is an SAP database table in S/4HANA. General Material Data. It contains 262 fields. 208 CDS views read from this table.

CDS Views using this table (208)

ViewTypeJoinVDMDescription
/dmbe/i_LcfsProgram view from LCFS Program
/dmbe/i_lcfsprogram_Text view from LCFS Program Descriptions
/dmbe/i_Material_Search view from Material
/dmbe/i_MaterialBasic view from Material Basic View
/merp/mm_Material_Plant view from CDS View: Material Plant View
/SAPAPO/CDPS_CURTORUL_SEL view inner Selection of Resource Usage
/sapapo/sypp_ts_sosmap view inner Mapping beween external and PP/DS source of supply
/SCMTMS/CV_ResourceRoot view_entity left_outer BOPF: Resource Root
/SCMTMS/CV_ResourceRt view left_outer BOPF: Resource Root (old)
Arun_Conf_Lines view inner Supply Assignment confirmations
arun_i_batch_sel view inner Batch stock selection
ARUN_I_F_LINE view inner Production Order Item level selection
arun_i_plaf view inner Planned order selection
Arun_I_So_1 view inner SO Item level Data selection
arun_i_so_arun_check view inner Select SalesOrder Items for ARun Article
Arun_I_Sto_1 view inner STO Item level Data selection
arun_i_storage_sel view inner Storage location stock selection
Arun_Purchord_Aggr view inner Supply Assignment PO aggregate
Arun_Reqsrt_Mm view inner Requirement sorting - MM
Arun_Reqsrt_Sd view inner Requirement sorting - SD
Arun_So_Req1 view inner Sales Order Requirement - Initial join
Arun_Spo_Reqmt view inner Subcontracting PO Requirement
Arun_Sto_Req1 view inner STO Requirement - Initial join
Arun_Stock_Sel view left_outer Stock Selection for Supply Assignment
ARun_ValAddedSrvcMatlPlant view from
ARUNI_CONF_LINE view inner Confirmations selection at date level
ARUNI_EBAN_SEL view inner Get Purchase Requisition data
aruni_po_line view inner PO selection at date level
aruni_sto_line view inner PO selection at date level
ARUNI_STO_LINE_STK view inner STO as stock
aruni_stock_sel view left_outer ARun ITA: Physical stock selection
BH_MATDOC_FOR_ACD_REF view inner ML bloodhound: MATDOC for ACDOCA ref
C_EWM_LoadListHndlgUnit view_entity left_outer CONSUMPTION Form Prvdr for Loading Instruction HUs
C_PackagingMaterialVH view from CONSUMPTION VH for Packaging Materials
CIC_PRD_CONSUMPTION_QTY view_entity inner CDS for Prd Consumption Qty
CIC_SEASONPRODUCT view_entity inner Proj. on Prod. Assgmt to Season (Industry Cloud Solutions)
E_Product view from EXTENSION Extension view product core (MARA)
E_Productprocurement view from EXTENSION Product Master Procurement Extension
E_Productsales view from EXTENSION Product Master Sales Extension
E_Productstorage view from EXTENSION Product Master Storage Extension
F_Mmim_I_Material_Vh view from Material
F_Mmim_Matgrp_Ele view inner Help-View Material by material group
F_Mmim_Mathlp_Vh view from Help-View for material
F_Mmim_Mattyp_Ele view inner Help-View Material by material Type
FAC_AUDIT_Z3_MATERIAL_MASTER_B view left_outer Material Master based CDS View
FAC_CDS_UH_MATERIAL view from MATERIAL
FCML_MAT_DDL view inner CDS View with structure of table FCML_MAT
FINOC_RULE_MAT_EXAMPLE view inner Organizational Change: Customer Rule MAT
FPC_EBEW_ETC_VIEW view inner Projection on MM data for PCP
FPC_MBEW_ETC_VIEW view inner Projection on MM data for PCP
FPC_QBEW_ETC_VIEW view inner Projection on MM data for PCP
FSH_V_PLANNING_FILE_ENTRIES view inner Planning File entries for Fashion
I_ACMApplDtmnAprvdContr view_entity inner BASIC ACM App Determine Approved Contract
I_ACMMaterialDetails view from BASIC ACM Material Details
I_ACMMaterialMstrData view from BASIC Material Master Data
I_ACMMatlCostRevCkpt view_entity from BASIC Basic Entity for ACM Materials for CRC
I_ACMTrdgContrItmBsc view_entity inner BASIC Basic contract item data
I_CstrtHardwareBsc view left_outer BASIC Hardware Constraint Item Basic View
I_CstrtHardwareMatl view from BASIC Hardware Material List
I_CstrtHdrBsc view left_outer BASIC Constraint Header Basic view
I_CstrtSwBsc view left_outer BASIC Software Constraint Item Basic view
I_CstrtSwMatlCstrt view from BASIC Software Material with Constriant Data
I_EWAWasteVH view_entity from BASIC Waste Material values
I_FldLogsMaterialDetails view from BASIC Material master data from MARA for Field Logistics
I_GHOMaterialMedium view_entity from BASIC Material Medium
I_GHOMaterialVH view from BASIC Material
I_JITOutbMaterialId view from BASIC JIT S2P - S2L Material ID
I_Material view from BASIC Material
I_MaterialDescription view from BASIC Material Description
I_MaterialVH view from COMPOSITE Material Value Help
I_OIL_ProductBasic view_entity from BASIC Oil Specific Product
I_PrepaymentMaterial view from BASIC Material Data
I_PrepayTrdgContrItmQtyData view_entity inner BASIC ACM Quantity Shadow Item Data
I_ProdPlntInptAssistant view inner BASIC Input Assistance for Product Plant
I_Product view from BASIC Product
I_ProductESPP view from BASIC Product ESPP active core entity
I_ProductInternal view from BASIC Conversion of Material Number to internal format
I_Productprocurement view from BASIC Product Procurement
I_Productqm view from BASIC Product QM active core entity
I_ProductSales view from BASIC Product Sales
I_Productscm view from BASIC Product SCM
I_Productstorage view from BASIC Product Storage
I_ProductStorage_2 view from BASIC Product Storage
I_ProductToAssortmentModule view inner BASIC Product Assignment to Assortment Object
I_PSDProduct view_entity inner BASIC PSD Product
I_RFM_ProductCharcValue1Txt view from BASIC Product characteristics value 1
I_RFM_ProductCharcValue2Txt view from BASIC Product characteristics value 2
I_RFM_ProductCharcValue3Txt view from BASIC Product characteristics value 3
I_ScheduledMaterialVH view left_outer BASIC Material Value Help
I_SrvcPartsProductMap view from BASIC Product Mapping
I_SupDmndMaterialPlant view from BASIC Basic View for Material Plant
I_SupDmndOvwPlannedOrder view inner BASIC Basic View for Planned Order
I_SupDmndOvwProductionOrder view inner BASIC Basic View for Production Order
I_Swcstrtdata view inner BASIC Get Details of Constraints
I_Swcstrtdata view left_outer BASIC Get Details of Constraints
I_TrdgContractItemBasicData view inner BASIC Basic contract item data
I_TrdgContrFieldCatalogData view inner BASIC Trading Contract field catalog data
I_TrdgContrItemQuantityData view inner BASIC ACM Qty: Shadow Item Data
I_TripServiceMaterialVH view from BASIC Value Help for Service Material
I_VariantMaterial view left_outer BASIC Material of Variant
I_VisualAnalysis view left_outer COMPOSITE Visual Analysis
I_VisualProductIdVH view from BASIC Visual Product id
I_VisualSimulation view left_outer COMPOSITE IPW Simulation in Visualization
M_V_inforecord view left_outer MM-PUR: CDS View for Purchasing Info Record
M_V_Inforecord_Sos_B view left_outer MM-PUR: Basic CDS View for SOS
Mbv_J_1ambew view inner Compatibility view for J_1AMBEW view (ML integration)
Mbv_Macku view from Compatibility view for MACKU view (ML integration)
Mbv_Srmerp_Css_Mat view from Compatibility view for /SRMERP/CCS_MAT view (ML integration)
Mbv_V_Mmim_Wb view inner Compatibility view for V_MMIM_WB view (ML integration)
Mbv_V_Satz1 view from Compatibility view for V_SATZ1 view (ML integration)
Mbv_Vkp_Mbew view inner Compatibility view for VKP_MBEW view (ML integration)
Mbv_Wrma_V_Mbew view from Compatibility view for /SRMERP/CCS_MAT view (ML integration)
Mbv_Wrma_V_Mbewh view from Compatibility view for WRMA_V_MBEWH view (ML integration)
Mbv_Wrma_V_Recast_Mh view from Compatibility view for WRMA_V_RECAST_MH (ML integration)
MDCV_E_DBVL view inner Compatibility View for DBVL
MDCV_E_DBVM view inner Compatibility View for DBVM
N_Product view from Auxiliary view for Product
NSDM_e_J_3RM_MARCMARA_B view inner J_3RM_MARCMARA_B Compatibility View
NSDM_e_J_3RM_MARCMARA_W_w view inner J_3RM_MARCMARA_W Compatibility View
NSDM_E_MA07V view from MA07V Compatibility View
NSDM_E_MA61V view from MA61V Compatibility View
NSDM_E_MAWEV view from MAWEV Compatibility View
NSDM_E_MCON view from MCON Compatibility View
NSDM_E_MFAUF view from MFAUF Compatibility View
NSDM_E_V_MMIM_EN view inner V_MMIM_EN Compatibility View
NSDM_E_V_MMIM_EN2 view inner V_MMIM_EN2 Compatibility View
NSDM_E_V_MMIM_KN view inner V_MMIM_KN Compatibility View
NSDM_E_V_MMIM_LB view inner V_MMIM_LB Compatibility View
NSDM_E_V_MMIM_LC view inner V_MMIM_LC Compatibility View
NSDM_E_V_MMIM_LC_MB5M view inner V_MMIM_LC_MB5M Compatibility View
NSDM_E_V_MMIM_LN view inner V_MMIM_LN Compatibility View
NSDM_E_V_MMIM_ON view from V_MMIM_ON Compatibility View
NSDM_E_V_MMIM_QN view inner V_MMIM_QN Compatibility View
NSDM_E_V_MMIM_VW view from V_MMIM_VW Compatibility View
NSDM_e_v_OLR3_MARX view from V_OLR3_MARX Compatibility View
NSDM_e_V_SLGH_1 view from V_SLGH_1 Compatibility View
NSDM_e_V_SLGH_2 view from V_SLGH_2 Compatibility View
OIB_BOOK_INVENTORY view inner Book inventory with valuation type and method
P_ACMTrdgContrItemTypeQty view inner BASIC
P_AdvncdPlngPrdscm_Matkey view from BASIC
P_ADVNCDPLNGPRODPLANTMRP view inner BASIC
P_ADVNCDPLNGPRODUCTPLANT view inner BASIC
P_ConfigurableProductPlantSmpl view inner CONSUMPTION
P_ConfigurableProductPlantSmpl view union CONSUMPTION
P_CustomerAvgQuantity view inner BASIC
P_DD_MAT_ADDLINFO view_entity inner BASIC Demand Driven Material information
P_DRFBATCHMCH1 view inner BASIC
P_DRFBATCHMCHA view inner BASIC
P_DRFEWMProduct view union BASIC
P_FBV_PAR_SEL_MAT view from BASIC
P_InvtryMgmtMatlMstrVH view from BASIC
P_InvtryMgmtSuplrInfoRecdVH view from BASIC
P_Mara view from BASIC
P_MATERIALBOMLINKDEX_2 view_entity inner BASIC
P_MaterialInfo view from BASIC
P_Matval_Manage_Cost view inner BASIC
P_Matval_Manage_Cost_Sls_Ord view inner COMPOSITE
P_Matval_Manage_Md view inner BASIC
P_MDChgProcProdClAssgmtWthMatl view from BASIC
P_Prdscm_Matkey_Flcl view from BASIC Redirect for /SAPAPO/MATKEY
P_Prdscm_Matkey_Flcl_Calc view from BASIC Redirect for /SAPAPO/MATKEY
P_ProdPlantPlndIndepRqmtBasic view inner BASIC
P_ProductVariantCharcValuation view from BASIC
P_Rtc_Diff_Item_Matnr view from BASIC
P_Stockmaterial view from COMPOSITE
P_SubscriptionProductPurpose view from BASIC
P_SubscrpnProdSpec view inner BASIC
P_SubscrpnProdWithoutSpec view from BASIC
P_Swlist view inner BASIC
P_TRDGCONTRITEMQUANTITYDATA view inner BASIC
P_VarConfignPlntSpcfcProdVar view inner BASIC
P_VarConfignXPlantProdVariant view from BASIC
Pir_Keyfigures_Read_For_Sum view inner Read PIR Keyfigures
Pir_Read_Aor_Heads view inner Read Header data in your area of responsibility
PlndIndepRqmtPlanIndSum view inner
PPH_DD_MAT_CTRL_0 view inner DD Materials
PPH_DDL_MAT_CTRL_0 view inner View for reading master data
Pphmrp_Error_Mats view inner Attributes for Displaying Materials with Issues in last MRP
R_DFS_ProductExternalNumber view from BASIC Defense Product External Number
R_PPDSMntrRcptProductUoM view_entity from BASIC Product and Unit of Measure
R_PPDSMntrRcptProductVH view_entity left_outer BASIC Product
R_PPDSMntrRqmtProductUoM view_entity from BASIC Product and Unit of Measure
R_PPDSMntrRqmtProductVH view_entity left_outer BASIC Product
rfm_mm_seasons_basic_view view inner RFM Stock Transport Seasons Basic View
RFM_PP_MBOMConstcyChkMaterial view from
RFM_PP_MBOMConstcyChkMBlkdkSt view from
rfm_psst_assign view inner PSST Assignment monitor view
rfm_scc_product_data view from Get Product data
rfm_scc_salesdata_basic_V view inner Salesdata basic view
rfm_scc_sd_season_assign view inner RFM Manage Season Completeness SD Assign
rfm_scc_sto_sea_assign view inner RFM Season Complete Check STO Assignment
rfm_scc_stocktransfer_basic_V view inner Get Stock Transfer order details
RFM_SD_SEASONS_BASIC_VIEW view inner RFM Sales Document Seasons Basic View
SBN_DRF_PACKING_INSTRUCTIONS view left_outer Get Packing Instruction by MATNR or MTART
SBN_DRF_PI_DETAILS view left_outer Get PI details
ScmPrd_Matexec view from Redirect for /SAPAPO/MATEXEC
ScmPrd_Matid_Map view from Redirect for /SCMB/MATID_MAP
ScmPrd_MatMap_Union view from Union of MARA and MATERIALID
ScmPrd_MatMap_Union view inner Union of MARA and MATERIALID
ScmPrd_Matpack view from Redirect for /SAPAPO/MATPACK
ScmPrd_Mattxt view left_outer Redirect for /SAPAPO/MATTXT
ScmPrd_Ndbsmatg16 view from Redirect for NDBSMATG16
UPO_INT_V_STD_VOL_DIM view_entity inner Standardized Measurement Volumes
UPOV_MEASURE_STD_UNIT view inner Standardized Measurement Units
v_ml_invacc_l2_view view inner Inventory stock - accounts
v_ml_mig_rc1a_l2_view view inner Check if configuration for account determination is missing
V_Mmim_DDL_Om_Param view left_outer Goods Movement Parameters
VC_INTEGRATION_MARA view from Extraction for MARA

Fields (262)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY 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

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.

-- General Material Data
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MARA (
    MANDT,                    -- Client [MANDT]
    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]
    PRIMARY KEY (MANDT, MATNR)
);

Learn More