SAP TOTAL_K003 Table in S/4 HANA - Price Catalog
TOTAL_K003 is a standard SAP Table which is used to store Price Catalog data and is available within SAP S/4 HANA systems and previous ECC R/3 systems. Below is the technical details and the field list relevant for an SAP S/4 HANA system, see here for details and fields available within the SAP R/3 version of the TOTAL_K003 table(ECC)
Delivery Class:
Display/Maintenance via SM30: Display/Maintenance Allowed but with Restrictions
Enhancement category: Can Be Enhanced (Deep)
Dictionary Type: Structure
Database Table: TOTAL_K003
TOTAL_K003 table structure field list
Below is the full TOTAL_K003 field list that makes up the SAP database table structure, including key fields, description, data type and other technical details of each field
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP | SHLP Field |
MANDT | Client | MANDT | CLNT | 3(0) | T000 | MANDT | ||||
PRINBR | PRICAT: Unique internal catalog number | PRINBR | CHAR | 10(0) | PRICAT_K001 | PRINBR | PRN | PRICAT_HEADER | PRINBR | |
PRODUCTGROUP | PRICAT: PGI or assortment module from Pricat IDoc | PRIPRODUCTGROUP | CHAR | 18(0) | PRICAT_K002 | PRIPRODUCTGROUP | ||||
EAN_UPC_BASE | PRICAT: EAN/UPC Code of Base Unit of Measure | PRIEANBASIS | CHAR | 35(0) | PRIEAN | |||||
VALIDITY_BASE | Price Catalog Inbound Start of Validity Period | PRIVALIDITY | DATS | 8(0) | DATUM | |||||
EAN_UPC_TYPE | Type of material identification | PRIEANTYP | CHAR | 2(0) | PRIEANTYP | |||||
BEARB_STATUS | PRICAT: Status of material/unit of measure processing | PRIBEARBSTAT | CHAR | 2(0) | PRIBEARBSTAT | |||||
STATEINDICATOR | PRICAT: Movement Indicator for the Item | PRISTATEINDICATOR | CHAR | 2(0) | PRISTATEINDICATOR | |||||
PUR_GROUP | Purchasing Group | EKGRP | CHAR | 3(0) | T024 | EKGRP | EKG | |||
MATERIAL_GROUP | PRICAT: Material Group from Message | PRIMATKL | CHAR | 35(0) | PRICHAR35 | |||||
MAT_ID_SENDER | PRICAT: Material Number of the Sender of the Message | PRIMATLIEF | CHAR | 35(0) | PRICHAR35 | |||||
SHELF_LIFE_MSG | PRICAT: Shelf life expiration in time unit from message | PRIMHD | CHAR | 6(0) | PRIPERIODE | |||||
SHELF_LIFE_QUAL | PRICAT: Qualifier for periods | PRIQUALPERIOD | CHAR | 3(0) | PRIQUALPERIOD | |||||
COMPOSITION | PRICAT: Product Composition | PRICOMPOSITION | CHAR | 3(0) | PRICHAR3 | |||||
MATNR | Material Number | MATNR | CHAR | 40(0) | MARA | MATN1 | MATNR | MAT | S_MAT1 | MATNR |
MATL_TYPE | Material type | MTART | CHAR | 4(0) | T134 | MTART | MTA | |||
MATL_GROUP | Material Group | MATKL | CHAR | 9(0) | MATKL | MKL | S_WBWG | MATKL | ||
MATL_CAT | Material Category | ATTYP | CHAR | 2(0) | ATTYP | MTY | ||||
DEL_FLAG | Flag Material for Deletion at Client Level | LVOMA | CHAR | 1(0) | XFELD | |||||
CONTAINER | Container requirements | BEHVO | CHAR | 2(0) | T144 | BEHVO | ||||
STOR_CONDS | Storage conditions | RAUBE | CHAR | 2(0) | T142 | RAUBE | ||||
TEMP_CONDS | Temperature conditions indicator | TEMPB | CHAR | 2(0) | T143 | TEMPB | ||||
HAZ_MAT_NO | Hazardous material number | STOFF | CHAR | 40(0) | MGEF | MATN3 | STOFF | STO | ||
DIVISION | Division | SPART | CHAR | 2(0) | TSPA | SPART | SPA | C_SPART | SPART | |
SEASON | Season Category | SAISO | CHAR | 4(0) | T6WSP | SAISO | SAISO | |||
ALLOWED_WT | Allowed packaging weight | ERGEW | QUAN | 13(3) | MENG13 | |||||
PACK_WT_UN | Unit of weight (allowed packaging weight) | ERGEI | UNIT | 3(0) | T006 | CUNIT | MEINS | |||
PACK_WT_UN_ISO | Unit of weight (allowed packaging weight) in ISO code | ERGEI_ISO | CHAR | 3(0) | T006I | ISOCD_UNIT | ||||
ALLWD_VOL | Allowed packaging volume | ERVOL | QUAN | 13(3) | MENG13 | |||||
PACK_VO_UN | Volume unit (allowed packaging volume) | ERVOE | UNIT | 3(0) | T006 | CUNIT | MEINS | |||
PACK_VO_UN_ISO | Volume unit (allowed packaging volume) in ISO code | ERVOE_ISO | CHAR | 3(0) | T006I | ISOCD_UNIT | ||||
VAR_ORD_UN | Variable Purchase Order Unit Active | VABME | CHAR | 1(0) | VABME | |||||
BATCH_MGMT | Batch management requirement indicator | XCHPF | CHAR | 1(0) | XFELD | |||||
SH_MAT_TYP | Packaging Material Type | VHIART | CHAR | 4(0) | TVTY | TRATY | ||||
FILL_LEVEL | Maximum level (by volume) | FUELG | DEC | 3(0) | DEC3 | |||||
STACK_FACT | Stacking factor | STFAK | INT2 | 5(0) | INT2 | |||||
MAT_GRP_SM | Material Group: Packaging Materials | MAGRV | CHAR | 4(0) | TVEGR | MAGRV | ||||
MINREMLIFE | Minimum Remaining Shelf Life | MHDRZ | DEC | 4(0) | DEC4 | |||||
SHELF_LIFE | Total shelf life | MHDHB | DEC | 4(0) | DEC4 | |||||
STOR_PCT | Storage percentage | MHDLP | DEC | 3(0) | DEC3 | |||||
SAESON_YR | Season Year | SAISJ | CHAR | 4(0) | GJAHR | CJAHR | WMSAISJ | |||
PRICE_BAND | Price Band Category | PLGTP | CHAR | 2(0) | TWPT | PLGTP | ||||
EMPTIESBOM | Empties Bill of Material | W_MITLEERG | CHAR | 1(0) | FLAG | |||||
EXTMATLGRP | External Material Group | EXTWG | CHAR | 18(0) | Assigned to domain | EXTWG | ||||
CONT_UNIT | Content unit | INHME | UNIT | 3(0) | T006 | CUNIT | MEINS | |||
CONT_UNIT_ISO | Content unit in ISO code | INHME_ISO | CHAR | 3(0) | T006I | ISOCD_UNIT | ||||
NET_CONT | Net contents | INHAL | QUAN | 13(3) | MENG13 | |||||
COMPPRUNIT | Comparison price unit | VPREH | DEC | 5(0) | PACK3 | |||||
GROSS_CONT | Gross contents | INHBR | QUAN | 13(3) | MENG13 | |||||
ENVT_RLVT | Environmentally Relevant | KZUMW | CHAR | 1(0) | XFELD | |||||
SEASMATCAT | Rollout in a Season | SAITY | CHAR | 2(0) | T6WSA | SAITY | WMSAITY | |||
HAZMATPROF | Dangerous Goods Indicator Profile | ADGE_PROFL | CHAR | 3(0) | TDG41 | ADGD_PROFL | ||||
HIGH_VISC | Indicator: Highly Viscous | ADGE_IHIVI | CHAR | 1(0) | X | |||||
LOOSEORLIQ | Indicator: In Bulk/Liquid | ADGE_ILOOS | CHAR | 1(0) | X | |||||
CLOSED_BOX | Packaging Material is Closed Packaging | KZGVH | CHAR | 1(0) | XFELD | |||||
APPD_B_REC | Approved Batch Record Required | XGCHP | CHAR | 1(0) | XFELD | |||||
PERIOD_IND_EXPIR | Period Indicator for Shelf Life Expiration Date | DATTP | CHAR | 1(0) | PERKZ | DATTP | H_PERDKZ | EPRKZ | ||
ROUND_RULE_EXPIR | Rounding rule for calculation of SLED | RDMHD | CHAR | 1(0) | RDMHD | |||||
PROD_COMP_PACKAG | Indicator: Product composition printed on packaging | PRZUS | CHAR | 1(0) | XFELD | |||||
SALES_UNIT | Sales unit | VRKME | UNIT | 3(0) | T006 | CUNIT | MEINS | |||
SALES_UNIT_ISO | Sales unit in ISO code | VRKME_ISO | CHAR | 3(0) | T006I | ISOCD_UNIT | ||||
ISSUE_UNIT | Unit of issue | AUSME | UNIT | 3(0) | T006 | CUNIT | MEINS | |||
ISSUE_UNIT_ISO | Unit of issue in ISO code | AUSME_ISO | CHAR | 3(0) | T006I | ISOCD_UNIT | ||||
COUNTRYORI | Country of Origin of Material (Non-Preferential Origin) | HERKL | CHAR | 3(0) | T005 | LAND1 | LND | |||
COUNTRYORI_ISO | Material's country of origin in ISO code | HERKL_ISO | CHAR | 2(0) | INTCA | |||||
REGIONORIG | Region of Origin of Material (Non-Preferential Origin) | HERKR | CHAR | 3(0) | T005S | REGIO | ||||
COMM_CODE | Commodity Code | STAWN | CHAR | 17(0) | T604 | STAWN | ||||
.INCLU--AP | 0(0) | |||||||||
LOCK_STATUS | Lock Status (Yes or No) | WRF_LOCK_STATUS | CHAR | 1(0) | FLAG | |||||
SATNR | Cross-Plant Configurable Material | SATNR | CHAR | 40(0) | Assigned to domain | MATN1 | MATNR | |||
VENDOR_SATNR | Price Catalog: Grouping Field: Generic Article Assignment | WRF_VENDOR_SATNR | CHAR | 20(0) | WRF_VENDOR_SATNR | |||||
SATNR_HEAD_FLAG | Master Variant | WRF_MASTER_VARIANT | CHAR | 1(0) | CHAR1 | |||||
PROC_STATUS | Processing Status | WRF_PROCSTATUS | CHAR | 2(0) | WRF_PRICAT_PROC | WRF_PROCSTATUS | PROC_STATUS | WRF_PROCSTATUS | ||
TAKE_OVER_DATE | Transfer Date (in PRICAT Data Pool) | WRF_TAKE_OVER_DATE | DATS | 8(0) | DATUM | |||||
TRIGGER_DATE | Primary Update Date Set Online | WRF_TRIGGER_DATE | DATS | 8(0) | DATUM | |||||
MORE_MATNR | Price Catalog Indicator EAN for Mat. No. = 1..n | MORE_MATNR | CHAR | 1(0) | FLAG | |||||
REF_ARTICLE | Material group reference material | WWGDA | CHAR | 40(0) | MARA | MATN1 | MATNR | MAT | ||
HIER_ID | Hierarchy | WRF_HIER_CNT | CHAR | 2(0) | WRF_HIERCNT | RTHIER | WRF_HIERID_STATUS | HIER_ID | ||
HIER_NODE | Hierarchy Node | WRF_STRUC_NODE | CHAR | 18(0) | WRF_NODES | RTNODE | WRF_MATGRP_CSHLP | NODE | ||
MERKMALSPROFIL | Characteristic Profile | WRF_PROFIL | CHAR | 18(0) | KLASSE | KLA | WMPR | CLASS | ||
MANUAL_CHANGE | Manual Change | MANUAL_CHANGE | CHAR | 1(0) | FLAG | |||||
PROFILENAME | Profile Name | WRF_PROFILENAME | CHAR | 40(0) | TEXT40 | |||||
CONFIG_KLART | Configuration Class Type | KLART_VAR | CHAR | 3(0) | Assigned to domain | KLASSENART | KAR | |||
CONFIG_CLASS | Configuration Class | CLASS_VAR | CHAR | 18(0) | KLASSE | KLA | ||||
.INCLU--AP | 0(0) | |||||||||
CAT_GROUP_1 | KATALOG_GRUPPE | CATALOGUE_GROUP | CHAR | 12(0) | WRF_CAT_GROUP | CATALOGUE_GROUP | ||||
CAT_GROUP_2 | KATALOG_GRUPPE | CATALOGUE_GROUP | CHAR | 12(0) | WRF_CAT_GROUP | CATALOGUE_GROUP | ||||
CAT_GROUP_3 | KATALOG_GRUPPE | CATALOGUE_GROUP | CHAR | 12(0) | WRF_CAT_GROUP | CATALOGUE_GROUP | ||||
IV_OLD | General Flag | FLAG | CHAR | 1(0) | FLAG | |||||
REF_EAN_LINE | REF | 0(0) |
Search for further information about these or an SAP related objects