TOTAL_K003 SAP (Price Catalog) Structure details
Description: Price Catalog
Structure field list including key, data, relationships and ABAP select examples
TOTAL_K003 is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Price Catalog" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_TOTAL_K003 TYPE TOTAL_K003.
The TOTAL_K003 table consists of various fields, each holding specific information or linking keys about Price Catalog data available in SAP. These include MANDT (Client), PRINBR (PRICAT: Unique internal catalog number), PRODUCTGROUP (PRICAT: PGI or assortment module from Pricat IDoc), EAN_UPC_BASE (PRICAT: EAN/UPC Code of Base Unit of Measure).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can Be Enhanced (Deep)
SAP TOTAL_K003 structure fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
PRINBR | PRICAT: Unique internal catalog number | PRINBR | CHAR | 10 | PRICAT_K001 | PRINBR | PRN | PRICAT_HEADER | |
PRODUCTGROUP | PRICAT: PGI or assortment module from Pricat IDoc | PRIPRODUCTGROUP | CHAR | 18 | PRICAT_K002 | PRIPRODUCTGROUP | |||
EAN_UPC_BASE | PRICAT: EAN/UPC Code of Base Unit of Measure | PRIEANBASIS | CHAR | 35 | PRIEAN | ||||
VALIDITY_BASE | Price Catalog Inbound Start of Validity Period | PRIVALIDITY | DATS | 8 | DATUM | ||||
EAN_UPC_TYPE | Type of material identification | PRIEANTYP | CHAR | 2 | PRIEANTYP | ||||
BEARB_STATUS | PRICAT: Status of material/unit of measure processing | PRIBEARBSTAT | CHAR | 2 | PRIBEARBSTAT | ||||
STATEINDICATOR | PRICAT: Movement Indicator for the Item | PRISTATEINDICATOR | CHAR | 2 | PRISTATEINDICATOR | ||||
PUR_GROUP | Purchasing Group | EKGRP | CHAR | 3 | T024 | EKGRP | EKG | ||
MATERIAL_GROUP | PRICAT: Material Group from Message | PRIMATKL | CHAR | 35 | PRICHAR35 | ||||
MAT_ID_SENDER | PRICAT: Material Number of the Sender of the Message | PRIMATLIEF | CHAR | 35 | PRICHAR35 | ||||
SHELF_LIFE_MSG | PRICAT: Shelf life expiration in time unit from message | PRIMHD | CHAR | 6 | PRIPERIODE | ||||
SHELF_LIFE_QUAL | PRICAT: Qualifier for periods | PRIQUALPERIOD | CHAR | 3 | PRIQUALPERIOD | ||||
COMPOSITION | PRICAT: Product Composition | PRICOMPOSITION | CHAR | 3 | PRICHAR3 | ||||
MATNR | Material Number | MATNR | CHAR | 18 | MARA | MATN1 | MATNR | MAT | S_MAT1 |
MATL_TYPE | Material Type | MTART | CHAR | 4 | T134 | MTART | MTA | ||
MATL_GROUP | Material Group | MATKL | CHAR | 9 | Assigned to domain | MATKL | MKL | S_WBWG | |
MATL_CAT | Material Category | ATTYP | CHAR | 2 | ATTYP | MTY | |||
DEL_FLAG | Flag Material for Deletion at Client Level | LVOMA | CHAR | 1 | XFELD | ||||
CONTAINER | Container requirements | BEHVO | CHAR | 2 | T144 | BEHVO | |||
STOR_CONDS | Storage conditions | RAUBE | CHAR | 2 | T142 | RAUBE | |||
TEMP_CONDS | Temperature conditions indicator | TEMPB | CHAR | 2 | T143 | TEMPB | |||
HAZ_MAT_NO | Hazardous material number | STOFF | CHAR | 18 | MGEF | MATN1 | STOFF | STO | |
DIVISION | Division | SPART | CHAR | 2 | TSPA | SPART | SPA | C_SPART | |
SEASON | Season Category | SAISO | CHAR | 4 | 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 | T006 | CUNIT | MEINS | ||
PACK_WT_UN_ISO | Unit of weight (allowed packaging weight) in ISO code | ERGEI_ISO | CHAR | 3 | T006I | ISOCD_UNIT | |||
ALLWD_VOL | Allowed packaging volume | ERVOL | QUAN | 13(3) | MENG13 | ||||
PACK_VO_UN | Volume unit (allowed packaging volume) | ERVOE | UNIT | 3 | T006 | CUNIT | MEINS | ||
PACK_VO_UN_ISO | Volume unit (allowed packaging volume) in ISO code | ERVOE_ISO | CHAR | 3 | T006I | ISOCD_UNIT | |||
VAR_ORD_UN | Variable Purchase Order Unit Active | VABME | CHAR | 1 | VABME | ||||
BATCH_MGMT | Batch management requirement indicator | XCHPF | CHAR | 1 | XFELD | ||||
SH_MAT_TYP | Packaging Material Type | VHIART | CHAR | 4 | TVTY | TRATY | |||
FILL_LEVEL | Maximum level (by volume) | FUELG | DEC | 3 | DEC3 | ||||
STACK_FACT | Stacking factor | STFAK | INT2 | 5 | INT2 | ||||
MAT_GRP_SM | Material Group: Packaging Materials | MAGRV | CHAR | 4 | TVEGR | MAGRV | |||
MINREMLIFE | Minimum Remaining Shelf Life | MHDRZ | DEC | 4 | DEC4 | ||||
SHELF_LIFE | Total shelf life | MHDHB | DEC | 4 | DEC4 | ||||
STOR_PCT | Storage percentage | MHDLP | DEC | 3 | DEC3 | ||||
SAESON_YR | Season Year | SAISJ | CHAR | 4 | GJAHR | CJAHR | WMSAISJ | ||
PRICE_BAND | Price Band Category | PLGTP | CHAR | 2 | TWPT | PLGTP | |||
EMPTIESBOM | Empties Bill of Material | W_MITLEERG | CHAR | 1 | FLAG | ||||
EXTMATLGRP | External Material Group | EXTWG | CHAR | 18 | Assigned to domain | EXTWG | |||
CONT_UNIT | Content unit | INHME | UNIT | 3 | T006 | CUNIT | MEINS | ||
CONT_UNIT_ISO | Content unit in ISO code | INHME_ISO | CHAR | 3 | T006I | ISOCD_UNIT | |||
NET_CONT | Net contents | INHAL | QUAN | 13(3) | MENG13 | ||||
COMPPRUNIT | Comparison price unit | VPREH | DEC | 5 | PACK3 | ||||
GROSS_CONT | Gross contents | INHBR | QUAN | 13(3) | MENG13 | ||||
ENVT_RLVT | Environmentally Relevant | KZUMW | CHAR | 1 | XFELD | ||||
SEASMATCAT | Rollout in a Season | SAITY | CHAR | 2 | T6WSA | SAITY | WMSAITY | ||
HAZMATPROF | Dangerous Goods Indicator Profile | ADGE_PROFL | CHAR | 3 | TDG41 | ADGD_PROFL | |||
HIGH_VISC | Indicator: Highly Viscous | ADGE_IHIVI | CHAR | 1 | X | ||||
LOOSEORLIQ | Indicator: In Bulk/Liquid | ADGE_ILOOS | CHAR | 1 | X | ||||
CLOSED_BOX | Packaging Material is Closed Packaging | KZGVH | CHAR | 1 | XFELD | ||||
APPD_B_REC | Indicator: Approved batch record required | XGCHP | CHAR | 1 | XFELD | ||||
PERIOD_IND_EXPIR | Period Indicator for Shelf Life Expiration Date | DATTP | CHAR | 1 | PERKZ | DATTP | H_PERDKZ | ||
ROUND_RULE_EXPIR | Rounding rule for calculation of SLED | RDMHD | CHAR | 1 | RDMHD | ||||
PROD_COMP_PACKAG | Indicator: Product composition printed on packaging | PRZUS | CHAR | 1 | XFELD | ||||
SALES_UNIT | Sales unit | VRKME | UNIT | 3 | T006 | CUNIT | MEINS | ||
SALES_UNIT_ISO | Sales unit in ISO code | VRKME_ISO | CHAR | 3 | T006I | ISOCD_UNIT | |||
ISSUE_UNIT | Unit of issue | AUSME | UNIT | 3 | T006 | CUNIT | MEINS | ||
ISSUE_UNIT_ISO | Unit of issue in ISO code | AUSME_ISO | CHAR | 3 | T006I | ISOCD_UNIT | |||
COUNTRYORI | Country of origin of the material | HERKL | CHAR | 3 | T005 | LAND1 | LND | ||
COUNTRYORI_ISO | Material's country of origin in ISO code | HERKL_ISO | CHAR | 2 | INTCA | ||||
REGIONORIG | Region of origin of material (non-preferential origin) | HERKR | CHAR | 3 | T005S | REGIO | |||
COMM_CODE | Commodity Code/Import Code Number for Foreign Trade | STAWN | CHAR | 17 | T604 | STAWN | |||
.INCLU--AP | 0 | ||||||||
LOCK_STATUS | Lock Status (Yes or No) | WRF_LOCK_STATUS | CHAR | 1 | FLAG | ||||
SATNR | Cross-Plant Configurable Material | SATNR | CHAR | 18 | Assigned to domain | MATN1 | MATNR | ||
VENDOR_SATNR | Price Catalog: Grouping Field: Generic Article Assignment | WRF_VENDOR_SATNR | CHAR | 20 | WRF_VENDOR_SATNR | ||||
SATNR_HEAD_FLAG | Master Variant | WRF_MASTER_VARIANT | CHAR | 1 | CHAR1 | ||||
PROC_STATUS | Processing Status | WRF_PROCSTATUS | CHAR | 2 | WRF_PRICAT_PROC | WRF_PROCSTATUS | PROC_STATUS | ||
TAKE_OVER_DATE | Transfer Date (in PRICAT Data Pool) | WRF_TAKE_OVER_DATE | DATS | 8 | DATUM | ||||
TRIGGER_DATE | Primary Update Date Set Online | WRF_TRIGGER_DATE | DATS | 8 | DATUM | ||||
MORE_MATNR | Price Catalog Indicator EAN for Mat. No. = 1..n | MORE_MATNR | CHAR | 1 | FLAG | ||||
REF_ARTICLE | Material group reference material | WWGDA | CHAR | 18 | MARA | MATN1 | MATNR | MAT | |
HIER_ID | Hierarchy | WRF_HIER_CNT | CHAR | 2 | WRF_HIERCNT | RTHIER | WRF_HIERID_STATUS | ||
HIER_NODE | Hierarchy Node | WRF_STRUC_NODE | CHAR | 18 | WRF_NODES | RTNODE | WRF_MATGRP_CSHLP | ||
MERKMALSPROFIL | Characteristic Profile | WRF_PROFIL | CHAR | 18 | KLASSE | KLA | WMPR | ||
MANUAL_CHANGE | Manual Change | MANUAL_CHANGE | CHAR | 1 | FLAG | ||||
PROFILENAME | Profile Name | WRF_PROFILENAME | CHAR | 40 | TEXT40 | ||||
.INCLU--AP | 0 | ||||||||
CAT_GROUP_1 | KATALOG_GRUPPE | CATALOGUE_GROUP | CHAR | 12 | WRF_CAT_GROUP | CATALOGUE_GROUP | |||
CAT_GROUP_2 | KATALOG_GRUPPE | CATALOGUE_GROUP | CHAR | 12 | WRF_CAT_GROUP | CATALOGUE_GROUP | |||
CAT_GROUP_3 | KATALOG_GRUPPE | CATALOGUE_GROUP | CHAR | 12 | WRF_CAT_GROUP | CATALOGUE_GROUP | |||
IV_OLD | General Flag | FLAG | CHAR | 1 | FLAG | ||||
REF_EAN_LINE | 0 |
Key field | Non-key field |
How do I retrieve data from SAP structure TOTAL_K003 using ABAP code?
As TOTAL_K003 is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on TOTAL_K003 as there is no data to select.How to access SAP table TOTAL_K003
Within an ECC or HANA version of SAP you can also view further information about TOTAL_K003 and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects