PRICAT_K003Z SAP (PRICAT: Catalog item basic data extras) Table details

Dictionary Type: Table
Description: PRICAT: Catalog item basic data extras




ABAP Code to SELECT data from PRICAT_K003Z
Related tables to PRICAT_K003Z
Access table PRICAT_K003Z




Table field list including key, data, relationships and ABAP select examples

PRICAT_K003Z is a standard SAP Table which is used to store PRICAT: Catalog item basic data extras data and is available within R/3 SAP systems depending on the version and release level.

The PRICAT_K003Z table consists of various fields, each holding specific information or linking keys about PRICAT: Catalog item basic data extras data available in SAP. These include 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), VALIDITY_BASE (Price Catalog Inbound Start of Validity Period).. 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: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP PRICAT_K003Z table 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
MANDTClient MANDTCLNT3T000MANDT
PRINBRPRICAT: Unique internal catalog number PRINBRCHAR10PRICAT_K001PRINBRPRNPRICAT_HEADER
PRODUCTGROUPPRICAT: PGI or assortment module from Pricat IDoc PRIPRODUCTGROUPCHAR18PRICAT_K002PRIPRODUCTGROUP
EAN_UPC_BASEPRICAT: EAN/UPC Code of Base Unit of Measure PRIEANBASISCHAR35PRIEAN
VALIDITY_BASEPrice Catalog Inbound Start of Validity Period PRIVALIDITYDATS8DATUM
SIZE_DIMSize/dimensions GROESCHAR32CHAR32
BASIC_MATLBasic Material WRKSTCHAR48Assigned to domainWRKST
STD_DESCRIndustry Standard Description (such as ANSI or ISO) NORMTCHAR18NORMT
DSN_OFFICELaboratory/design office LABORCHAR3Assigned to domainLABOR
COMPETITORCompetitor WETTBCHAR10Assigned to domainALPHAKUNNRKUN
MANUFACTURPRICAT: International Location No. Manufacturer (CHAR 35) PRIILNMCHAR35PRICHAR35
GENETIC_INFOPRICAT: Information on genetic modification PRIGENETICCHAR18PRICHAR18
ALCOHOL_PERC_VOLPRICAT: Alcohol volume as percentage (measured value) PRIALCVOLCHAR18PRICHAR18
FAT_CONTENTPRICAT: Fat content PRIFATCONTCHAR18PRICHAR18
KEEP_REFRIGPRICAT: Keep refrigerated PRIKEEPREFRIGCHAR3PRICHAR3
KEEP_FROZENPRICAT: Keep frozen PRIKEEPFROZENCHAR3PRICHAR3
GREEN_DOTPRICAT: Recyling indicator on goods PRIGREENDOTCHAR3PRICHAR3
EXPIR_MARKINGPRICAT: Expiration date shown on goods PRIEXPIRDATECHAR3PRICHAR3
PRICE_MARKINGPRICAT: Price marked on goods PRIPRICEMARKCHAR3PRICHAR3
KEEP_DRYPRICAT: Keep dry PRIKEEPDRYCHAR3PRICHAR3
HEAT_SENSITIVEPRICAT: Heat-sensitive PRIHEATSENSCHAR3PRICHAR3
COMM_CODEPRICAT: Customs tariff number PRICOMMCODECHAR35PRICHAR35
PREDECES_MAT_IDPRICAT: Preceding EAN/UPC PRIPREDECCHAR35PRICHAR35
FOLLOW_UPFollow-Up Material NFMATCHAR18Assigned to domainMATN1MATNRMAT
HAZARD_CLASSPRICAT: Dangerous Goods Classification PRIHAZCLASSCHAR4PRICHAR4
HAZARD_DESCRIPTPRICAT: Dangerous goods general description PRIHAZDESCHAR35PRICHAR35
HAZARD_DESCR_2PRICAT: Dangerous goods general description field 2 PRIHAZDES2CHAR35PRICHAR35
HAZARD_DESCR_3PRICAT: Dangerous goods general description field 3 PRIHAZDES3CHAR35PRICHAR35
SAISON_PERIODPRICAT: Seasonal ordering (from to) PRISAISONCHAR35PRICHAR35
.INCLU--AP 0
BASE_UOMBase Unit of Measure MEINSUNIT3T006CUNITMEINS
TAX_TYPETax category (sales tax, federal sales tax,...) TATYPCHAR4T685KSCHL
TAX_CLASSTax classification of the material TAKLVCHAR1TSKMTAXKM
VAL_CLASSValuation Class BKLASCHAR4T025BKLAS
MWSKZTax on sales/purchases code MWSKZCHAR2T007AMWSKZ

Key field Non-key field



How do I retrieve data from SAP table PRICAT_K003Z using ABAP code

The following ABAP code Example will allow you to do a basic selection on PRICAT_K003Z to SELECT all data from the table
DATA: WA_PRICAT_K003Z TYPE PRICAT_K003Z.

SELECT SINGLE *
FROM PRICAT_K003Z
INTO CORRESPONDING FIELDS OF WA_PRICAT_K003Z
WHERE...

How to access SAP table PRICAT_K003Z

Within an ECC or HANA version of SAP you can also view further information about PRICAT_K003Z and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!