T134
Material TypesBekijk een andere tabel
Vul een tabelcode of zoekwoord in om verder te zoeken.
Bekijk de structuur, velden en relaties van SAP-tabel T134.
SAP-tabel T134 heeft 2 primaire sleutelvelden: MANDT,MTART.
Bij analyse van data uit één SAP-instance is MANDT normaal overal gelijk en kun je dit veld weglaten uit relaties. Combineer je meerdere instances, neem MANDT dan wel op.
T134 velden.
| Veld | Omschrijving | Datatype | Lengte | Decimalen | Checktabel | Data-element | |||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Sleutel MANDT | Client | CLNT | 3 | 0 | MANDT | ||||||||||||||||||
| Sleutel MTART | Material type | CHAR | 4 | 0 | MTART | ||||||||||||||||||
| MTREF | Reference material type | CHAR | 4 | 0 | MTREF | ||||||||||||||||||
| MBREF | Screen reference depending on the material type | CHAR | 4 | 0 | MBREF | ||||||||||||||||||
| FLREF | Field reference for material master | CHAR | 4 | 0 | T130A | FLREF_MG | |||||||||||||||||
| NUMKI | Number Range | CHAR | 2 | 0 | NUMKR | ||||||||||||||||||
| NUMKE | Number Range | CHAR | 2 | 0 | NUMKR | ||||||||||||||||||
| ENVOP | External Number Assignment Without Validation | CHAR | 1 | 0 | ENVOP | ||||||||||||||||||
| BSEXT | External Purchase Orders Allowed | CHAR | 1 | 0 | BSEXT | ||||||||||||||||||
| |||||||||||||||||||||||
| BSINT | Internal purchase orders allowed | CHAR | 1 | 0 | BSINT | ||||||||||||||||||
| |||||||||||||||||||||||
| PSTAT | Maintenance status | CHAR | 15 | 0 | PSTAT_D | ||||||||||||||||||
| KKREF | Account category reference | CHAR | 4 | 0 | T025K | KKREF | |||||||||||||||||
| VPRSV | Price control indicator | CHAR | 1 | 0 | VPRSV | ||||||||||||||||||
| |||||||||||||||||||||||
| KZVPR | Price Control Mandatory | CHAR | 1 | 0 | KZVPR | ||||||||||||||||||
| VMTPO | Default value for material item category group | CHAR | 4 | 0 | TPTM | VMTPO | |||||||||||||||||
| EKALR | Material Is Costed with Quantity Structure | CHAR | 1 | 0 | CK_EKALREL | ||||||||||||||||||
| KZGRP | Grouping indicator | CHAR | 1 | 0 | KZGRP | ||||||||||||||||||
| |||||||||||||||||||||||
| KZKFG | Configurable Material | CHAR | 1 | 0 | KZKFG | ||||||||||||||||||
| BEGRU | Authorization group in the material master | CHAR | 4 | 0 | BEGRM | ||||||||||||||||||
| KZPRC | Material Master Record for a Process | CHAR | 1 | 0 | KZPRC | ||||||||||||||||||
| KZPIP | Pipeline Handling Mandatory | CHAR | 1 | 0 | KZPIP | ||||||||||||||||||
| PRDRU | Display price on cash register display and print on receipt | CHAR | 1 | 0 | POSPRDRUCK | ||||||||||||||||||
| ARANZ | Display material on cash register display | CHAR | 1 | 0 | POSARTANZ | ||||||||||||||||||
| WMAKG | Material Type ID | CHAR | 1 | 0 | WMAK | ||||||||||||||||||
| |||||||||||||||||||||||
| IZUST | Initial status of a new batch | CHAR | 1 | 0 | IZUST | ||||||||||||||||||
| |||||||||||||||||||||||
| ARDEL | Time in days until a material is deleted | NUMC | 4 | 0 | ARDEL | ||||||||||||||||||
| KZMPN | Manufacturer Part | CHAR | 1 | 0 | MPNMTART | ||||||||||||||||||
| MSTAE | Cross-Plant Material Status | CHAR | 2 | 0 | T141 | MSTAE | |||||||||||||||||
| CCHIS | Control (time) of history requirement: Material | CHAR | 1 | 0 | CC_HIST_MAT | ||||||||||||||||||
| |||||||||||||||||||||||
| CTYPE | Class Type | CHAR | 3 | 0 | TCLA | KLASSENART_M | |||||||||||||||||
| CLASS | Class number | CHAR | 18 | 0 | KLASSE_M | ||||||||||||||||||
| CHNEU | Batch Creation Control (Automatic/Manual) | CHAR | 1 | 0 | CHNEU | ||||||||||||||||||
| |||||||||||||||||||||||
| PROD_TYPE_CODE | Product Type Group | CHAR | 2 | 0 | CMD_PRDTYPE | PRODUCT_TYPE | |||||||||||||||||
| CONCTD_MATNR | Concatenated Material No. | CHAR | 2 | 0 | CONCTD_MATNR | ||||||||||||||||||
| VTYPE | Version Category | CHAR | 10 | 0 | MGVTYPE | VERSIONTYPE | |||||||||||||||||
| VNUMKI | Number Range | CHAR | 2 | 0 | NUMKR | ||||||||||||||||||
| VNUMKE | Number Range | CHAR | 2 | 0 | NUMKR | ||||||||||||||||||
| KZFFF | Indicator: FFF class | CHAR | 1 | 0 | KZFFF | ||||||||||||||||||
| KZRAC | Returnable Packaging Logistics is mandatory | CHAR | 1 | 0 | KZRAC | ||||||||||||||||||
T134 relaties.
| Tabel | Veld | Checktabel | Omschrijving | Checkveld |
|---|---|---|---|---|
| T134 | CTYPE | TCLA | Class Types | MANDT |
| T134 | FLREF | T130A | Material master field selection | MANDT |
| T134 | KKREF | T025K | Account Category Reference | KKREF |
| T134 | MSTAE | T141 | Material Status from Materials Management/PPC View | MANDT |
| T134 | MSTAE | T141 | Material Status from Materials Management/PPC View | MMSTA |
| T134 | PROD_TYPE_CODE | CMD_PRDTYPE | Code List: Product Type Code | PROD_TYPE_CODE |
| T134 | VMTPO | TPTM | Materials: Item Category Groups in Material Master | MTPOS |
| T134 | VTYPE | MGVTYPE | Table of version categories | VTYPE |