/SAPAPO/MATKEY
Product
/SAPAPO/MATKEY is an SAP database table in S/4HANA. Product. It contains 93 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_EWM_Product | view | from | BASIC | Warehouse Product |
Fields (93)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | /SAPAPO/CLNTAPO_MANDT | Client | |||
| KEY | matid | /SAPAPO/MATID | Product ID | |||
| matnr | /SAPAPO/MATNR | Product | ||||
| product_type | /SAPAPO/PRODUCT_TYPE | Product Type | ||||
| lvorm | /SAPAPO/LVORM | Deletion flag | ||||
| flagclass | /SAPAPO/FLGCLASS | Classified | ||||
| flagpack | /SAPAPO/FLGPACK | Packg Data Exists | ||||
| disst | /SAPAPO/DISST | Low-Level Code | ||||
| meins | /SAPAPO/MEINS | Base Unit | ||||
| attyp | /SAPAPO/ATTYP | Trdg Goods Cat. | ||||
| logunit | /SCMB/DE_LOGUNIT | Logistics UoM | ||||
| cwrel | /SCMB/DE_CWREL | Catch weight product | ||||
| ty2tq | /SCMB/MDL_TY2TQ | UoM Category | ||||
| brgew | /SAPAPO/BRGEW | Gross Weight | ||||
| ntgew | NTGEW | Net Weight | ||||
| gewei | /SAPAPO/GEWEI | Unit | ||||
| volum | /SAPAPO/VOLUM | Volume | ||||
| voleh | /SAPAPO/VOLEH | Unit of Volume | ||||
| shelf_life_flag | /SAPAPO/SHELF_LIFE_FLAG | Plg w.Shlf Life | ||||
| shelf_life_dur | /SAPAPO/SHELF_LIFE_DUR | Shelf Life | ||||
| maturity_dur | /SAPAPO/MATURITY_DUR | Maturation Time | ||||
| shlf_lfe_req_min | /SAPAPO/SHELF_LIFE_REQ_MIN | Min. Shelf Life | ||||
| shlf_lfe_req_max | /SAPAPO/SHELF_LIFE_REQ_MAX | Req.Max.Sh.Life | ||||
| mhdlp | /SAPAPO/MHDLP | % Remaining SL | ||||
| iprkz | /SAPAPO/SHELF_LIFE_IPRKZ | PI Shelf Life | ||||
| sled_bbd | /SCMB/MDL_SLED_BBD | BBD/SLED | ||||
| sldrnd | /SCMB/MDL_SLDRND | Rounding Rule | ||||
| att01 | /SAPAPO/MAT_CHAR40 | Free Attribute 1 | ||||
| att02 | /SAPAPO/MAT_CHAR30 | Free Attribute 2 | ||||
| att03 | /SAPAPO/MAT_CHAR20 | Free Attribute 3 | ||||
| att04 | /SAPAPO/MAT_CHAR10 | Free Attribute | ||||
| att05 | /SAPAPO/MAT_CHAR10 | Free Attribute | ||||
| bod_deplvl | /SAPAPO/BODDEPLVL | PushDplnt from Suplr | ||||
| excl_expedite | /SAPAPO/EXCLEXP | No Express Shipment | ||||
| prod_paoopt | /SAPAPO/PAOOPT | Procure to Order | ||||
| restrict_invbal | /SAPAPO/RESTRICT_INVBAL | No Invtry Balancing | ||||
| drp_gl_stock | /SAPAPO/DRP_GL_STOCK | Glob Stk Entry Loc | ||||
| inv_pln_mode | ESPP_INV_PLN_MODE | Invent. Plan. Mode | ||||
| matkl | /SAPAPO/MATKL_P | Material Group | ||||
| compl | /SAPAPO/CTM_COMP_LVL | Completn Level | ||||
| stfac | /SAPAPO/STFAC | Stacking Factor | ||||
| tragr | /SAPAPO/TRAGR | Transport.Group | ||||
| ts_sdp_use | /SAPAPO/TS_SDP_USE | SDP Relevance | ||||
| prdha | /SAPAPO/PRDHA | Prod.Hierarchy | ||||
| gtin_ind | /SAPAPO/PRD_DET | Product Determ. | ||||
| display | /SAPAPO/DISP | Promotion Disp. | ||||
| herkl | /SCMB/MDL_HERKL | C/R of Origin | ||||
| batch_req | /SCMB/DE_BATCH_REQ | Batch Managemnt | ||||
| kitcomp | /SAPAPO/CMPKIT | Product for KITO | ||||
| prdset_ind | /SAPAPO/PRDSET_IND | Product Set | ||||
| serial | /SCWM/DE_SERIAL | Serial No.Prof. | ||||
| data_check_by | /SCMB/MDL_DATA_CHECKED_BY | Checked By | ||||
| data_check_at | /SCMB/MDL_DATA_CHECKED_AT | Checked On | ||||
| kosch | /SAPAPO/KOSCH | Alloc. Proced. | ||||
| kosch_grp | /SAPAPO/KOSCH_GRP | Procedure Seq. | ||||
| vmikosch | /SAPAPO/VMIKOSCH | VMI All. Proc. | ||||
| vmikosch_grp | /SAPAPO/VMIKOSCH_GRP | VMI Proc. Seq. | ||||
| packgr | /SCWM/DE_PACKGR | Packing Group | ||||
| rmatp | /SAPAPO/RMATID | RefProd. GUID | ||||
| hutyp_dflt | /SCWM/DE_HUTYP_DFLT | Std HU Type | ||||
| rmatid_pb | /SAPAPO/RMATID_PB | Reference Product ID | ||||
| 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. | ||||
| cuobj | /SAPAPO/CUOBJ_PR | Configuration (Internal Object Number) | ||||
| satid | /SAPAPO/SATID | Conf. Prod. ID | ||||
| kzkfg | /SAPAPO/KZKFG | Configurable | ||||
| matvers_head | /SAPAPO/MATVERS_HEAD | Header Product | ||||
| matvers_type | /SAPAPO/MATVERS_TYPE | Prod.Versn Type | ||||
| matvers_chnr | /SAPAPO/AENNR | Change Number | ||||
| temprpblock | /SAPAPO/TEMPRPBLOCK | Temp. Repl. Bl. | ||||
| temprpfrom | /SAPAPO/TEMPRPFROM | Blckg Start D/T | ||||
| temprpto | /SAPAPO/TEMPRPTO | Blckg End D/T | ||||
| dummy_prd_incl_eew_ps | PRD_INCL_EEW | Dummy Field | ||||
| likeid | abap.char | |||||
| phin_from | abap.dats | |||||
| phin_to | abap.dats | |||||
| phin_tsid | abap.char | |||||
| phout_from | abap.dats | |||||
| phout_to | abap.dats | |||||
| phout_tsid | abap.char | |||||
| life_cycle_locid | abap.char | |||||
| newprod_indi | /SAPAPO/NEWPROD_INDI | New Product | ||||
| prd_startdt | /SAPAPO/PRD_STARTDT | Prod. Start Date | ||||
| prd_enddt | /SAPAPO/PRD_ENDDT | Production End Date | ||||
| createuser | ERNAM | Created By | ||||
| createutc | /SAPAPO/TSUCR | Created On/At | ||||
| changeuser | AENAM | Changed By | ||||
| changeutc | /SAPAPO/TSUUP | Changed On/At |
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.
-- Product
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE /SAPAPO/MATKEY (
MANDT, -- Client [/SAPAPO/CLNTAPO_MANDT]
MATID, -- Product ID [/SAPAPO/MATID]
MATNR, -- Product [/SAPAPO/MATNR]
PRODUCT_TYPE, -- Product Type [/SAPAPO/PRODUCT_TYPE]
LVORM, -- Deletion flag [/SAPAPO/LVORM]
FLAGCLASS, -- Classified [/SAPAPO/FLGCLASS]
FLAGPACK, -- Packg Data Exists [/SAPAPO/FLGPACK]
DISST, -- Low-Level Code [/SAPAPO/DISST]
MEINS, -- Base Unit [/SAPAPO/MEINS]
ATTYP, -- Trdg Goods Cat. [/SAPAPO/ATTYP]
LOGUNIT, -- Logistics UoM [/SCMB/DE_LOGUNIT]
CWREL, -- Catch weight product [/SCMB/DE_CWREL]
TY2TQ, -- UoM Category [/SCMB/MDL_TY2TQ]
BRGEW, -- Gross Weight [/SAPAPO/BRGEW]
NTGEW, -- Net Weight [NTGEW]
GEWEI, -- Unit [/SAPAPO/GEWEI]
VOLUM, -- Volume [/SAPAPO/VOLUM]
VOLEH, -- Unit of Volume [/SAPAPO/VOLEH]
SHELF_LIFE_FLAG, -- Plg w.Shlf Life [/SAPAPO/SHELF_LIFE_FLAG]
SHELF_LIFE_DUR, -- Shelf Life [/SAPAPO/SHELF_LIFE_DUR]
MATURITY_DUR, -- Maturation Time [/SAPAPO/MATURITY_DUR]
SHLF_LFE_REQ_MIN, -- Min. Shelf Life [/SAPAPO/SHELF_LIFE_REQ_MIN]
SHLF_LFE_REQ_MAX, -- Req.Max.Sh.Life [/SAPAPO/SHELF_LIFE_REQ_MAX]
MHDLP, -- % Remaining SL [/SAPAPO/MHDLP]
IPRKZ, -- PI Shelf Life [/SAPAPO/SHELF_LIFE_IPRKZ]
SLED_BBD, -- BBD/SLED [/SCMB/MDL_SLED_BBD]
SLDRND, -- Rounding Rule [/SCMB/MDL_SLDRND]
ATT01, -- Free Attribute 1 [/SAPAPO/MAT_CHAR40]
ATT02, -- Free Attribute 2 [/SAPAPO/MAT_CHAR30]
ATT03, -- Free Attribute 3 [/SAPAPO/MAT_CHAR20]
ATT04, -- Free Attribute [/SAPAPO/MAT_CHAR10]
ATT05, -- Free Attribute [/SAPAPO/MAT_CHAR10]
BOD_DEPLVL, -- PushDplnt from Suplr [/SAPAPO/BODDEPLVL]
EXCL_EXPEDITE, -- No Express Shipment [/SAPAPO/EXCLEXP]
PROD_PAOOPT, -- Procure to Order [/SAPAPO/PAOOPT]
RESTRICT_INVBAL, -- No Invtry Balancing [/SAPAPO/RESTRICT_INVBAL]
DRP_GL_STOCK, -- Glob Stk Entry Loc [/SAPAPO/DRP_GL_STOCK]
INV_PLN_MODE, -- Invent. Plan. Mode [ESPP_INV_PLN_MODE]
MATKL, -- Material Group [/SAPAPO/MATKL_P]
COMPL, -- Completn Level [/SAPAPO/CTM_COMP_LVL]
STFAC, -- Stacking Factor [/SAPAPO/STFAC]
TRAGR, -- Transport.Group [/SAPAPO/TRAGR]
TS_SDP_USE, -- SDP Relevance [/SAPAPO/TS_SDP_USE]
PRDHA, -- Prod.Hierarchy [/SAPAPO/PRDHA]
GTIN_IND, -- Product Determ. [/SAPAPO/PRD_DET]
DISPLAY, -- Promotion Disp. [/SAPAPO/DISP]
HERKL, -- C/R of Origin [/SCMB/MDL_HERKL]
BATCH_REQ, -- Batch Managemnt [/SCMB/DE_BATCH_REQ]
KITCOMP, -- Product for KITO [/SAPAPO/CMPKIT]
PRDSET_IND, -- Product Set [/SAPAPO/PRDSET_IND]
SERIAL, -- Serial No.Prof. [/SCWM/DE_SERIAL]
DATA_CHECK_BY, -- Checked By [/SCMB/MDL_DATA_CHECKED_BY]
DATA_CHECK_AT, -- Checked On [/SCMB/MDL_DATA_CHECKED_AT]
KOSCH, -- Alloc. Proced. [/SAPAPO/KOSCH]
KOSCH_GRP, -- Procedure Seq. [/SAPAPO/KOSCH_GRP]
VMIKOSCH, -- VMI All. Proc. [/SAPAPO/VMIKOSCH]
VMIKOSCH_GRP, -- VMI Proc. Seq. [/SAPAPO/VMIKOSCH_GRP]
PACKGR, -- Packing Group [/SCWM/DE_PACKGR]
RMATP, -- RefProd. GUID [/SAPAPO/RMATID]
HUTYP_DFLT, -- Std HU Type [/SCWM/DE_HUTYP_DFLT]
RMATID_PB, -- Reference Product ID [/SAPAPO/RMATID_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]
CUOBJ, -- Configuration (Internal Object Number) [/SAPAPO/CUOBJ_PR]
SATID, -- Conf. Prod. ID [/SAPAPO/SATID]
KZKFG, -- Configurable [/SAPAPO/KZKFG]
MATVERS_HEAD, -- Header Product [/SAPAPO/MATVERS_HEAD]
MATVERS_TYPE, -- Prod.Versn Type [/SAPAPO/MATVERS_TYPE]
MATVERS_CHNR, -- Change Number [/SAPAPO/AENNR]
TEMPRPBLOCK, -- Temp. Repl. Bl. [/SAPAPO/TEMPRPBLOCK]
TEMPRPFROM, -- Blckg Start D/T [/SAPAPO/TEMPRPFROM]
TEMPRPTO, -- Blckg End D/T [/SAPAPO/TEMPRPTO]
DUMMY_PRD_INCL_EEW_PS, -- Dummy Field [PRD_INCL_EEW]
LIKEID, -- abap.char
PHIN_FROM, -- abap.dats
PHIN_TO, -- abap.dats
PHIN_TSID, -- abap.char
PHOUT_FROM, -- abap.dats
PHOUT_TO, -- abap.dats
PHOUT_TSID, -- abap.char
LIFE_CYCLE_LOCID, -- abap.char
NEWPROD_INDI, -- New Product [/SAPAPO/NEWPROD_INDI]
PRD_STARTDT, -- Prod. Start Date [/SAPAPO/PRD_STARTDT]
PRD_ENDDT, -- Production End Date [/SAPAPO/PRD_ENDDT]
CREATEUSER, -- Created By [ERNAM]
CREATEUTC, -- Created On/At [/SAPAPO/TSUCR]
CHANGEUSER, -- Changed By [AENAM]
CHANGEUTC, -- Changed On/At [/SAPAPO/TSUUP]
PRIMARY KEY (MANDT, MATID)
);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