SAP BAPI1171_K003 PRICAT: Transfer structure catalog line Pricat_K003 Table data and field list

BAPI1171_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 "PRICAT: Transfer structure catalog line Pricat_K003" 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_BAPI1171_K003 TYPE BAPI1171_K003.

The BAPI1171_K003 table consists of various fields, each holding specific information or linking keys about PRICAT: Transfer structure catalog line Pricat_K003 data available in SAP. These include EAN_UPC_BASE (PRICAT: EAN/UPC Code of Base Unit of Measure), VALIDITY_BASE (Price Catalog Inbound Start of Validity Period), EAN_UPC_TYPE (Type of material identification), STATE_OF_PROCES (PRICAT: Status of material/unit of measure processing)... 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. .

BAPI1171_K003 structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified


SAP BAPI1171_K003 structure fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the BAPI1171_K003 table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.
Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
PRODUCTGROUPPRICAT: PGI or assortment module from Pricat IDoc PRIPRODUCTGROUPCHAR18Assigned to domainPRIPRODUCTGROUP
EAN_UPC_BASEPRICAT: EAN/UPC Code of Base Unit of Measure PRIEANBASISCHAR35PRIEAN
VALIDITY_BASEPrice Catalog Inbound Start of Validity Period PRIVALIDITYDATS8DATUM
EAN_UPC_TYPEType of material identification PRIEANTYPCHAR2PRIEANTYP
STATE_OF_PROCESPRICAT: Status of material/unit of measure processing PRIBEARBSTATCHAR2PRIBEARBSTAT
PUR_GROUPPurchasing Group EKGRPCHAR3Assigned to domainEKGRPEKG
MATERIAL_GROUPPRICAT: Material Group from Message PRIMATKLCHAR35PRICHAR35
MAT_ID_SENDERPRICAT: Material Number of the Sender of the Message PRIMATLIEFCHAR35PRICHAR35
SHELF_LIFE_MSGPRICAT: Shelf life expiration in time unit from message PRIMHDCHAR6PRIPERIODE
SHELF_LIFE_QUALPRICAT: Qualifier for periods PRIQUALPERIODCHAR3PRIQUALPERIOD
COMPOSITIONPRICAT: Product Composition PRICOMPOSITIONCHAR3PRICHAR3
MATERIALMaterial Number MATNRCHAR18MARAMATN1MATNRMATS_MAT1
MATL_TYPEMaterial Type MTARTCHAR4T134MTARTMTA
MATL_GROUPMaterial Group MATKLCHAR9T023MATKLMKLS_WBWG
MATL_CATMaterial Category ATTYPCHAR2ATTYPMTY
DEL_FLAGFlag Material for Deletion at Client Level LVOMACHAR1XFELD
CONTAINERContainer requirements BEHVOCHAR2T144BEHVO
STOR_CONDSStorage conditions RAUBECHAR2T142RAUBE
TEMP_CONDSTemperature conditions indicator TEMPBCHAR2T143TEMPB
HAZ_MAT_NOHazardous material number STOFFCHAR18MGEFMATN1STOFFSTO
DIVISIONDivision SPARTCHAR2TSPASPARTSPAC_SPART
SEASONSeason Category SAISOCHAR4T6WSPSAISOSAISO
ALLOWED_WTAllowed packaging weight ERGEWQUAN13(3) MENG13
PACK_WT_UNUnit of weight (allowed packaging weight) ERGEIUNIT3T006CUNITMEINS
PACK_WT_UN_ISOUnit of weight (allowed packaging weight) in ISO code ERGEI_ISOCHAR3T006IISOCD_UNIT
ALLWD_VOLAllowed packaging volume ERVOLQUAN13(3) MENG13
PACK_VO_UNVolume unit (allowed packaging volume) ERVOEUNIT3T006CUNITMEINS
PACK_VO_UN_ISOVolume unit (allowed packaging volume) in ISO code ERVOE_ISOCHAR3T006IISOCD_UNIT
VAR_ORD_UNVariable Purchase Order Unit Active VABMECHAR1VABME
BATCH_MGMTBatch management requirement indicator XCHPFCHAR1XFELD
SH_MAT_TYPPackaging Material Type VHIARTCHAR4TVTYTRATY
FILL_LEVELMaximum level (by volume) FUELGDEC3DEC3
STACK_FACTStacking factor STFAKINT25INT2
MAT_GRP_SMMaterial Group: Packaging Materials MAGRVCHAR4TVEGRMAGRV
MINREMLIFEMinimum Remaining Shelf Life MHDRZDEC4DEC4
SHELF_LIFETotal shelf life MHDHBDEC4DEC4
STOR_PCTStorage percentage MHDLPDEC3DEC3
SEASON_YRSeason Year SAISJCHAR4GJAHRCJAHRWMSAISJ
PRICE_BANDPrice Band Category PLGTPCHAR2TWPTPLGTP
EMPTIESBOMEmpties Bill of Material W_MITLEERGCHAR1FLAG
EXTMATLGRPExternal Material Group EXTWGCHAR18Assigned to domainEXTWG
CONT_UNITContent unit INHMEUNIT3T006CUNITMEINS
CONT_UNIT_ISOContent unit in ISO code INHME_ISOCHAR3T006IISOCD_UNIT
NET_CONTNet contents INHALQUAN13(3) MENG13
COMPPRUNITComparison price unit VPREHDEC5PACK3
GROSS_CONTGross contents INHBRQUAN13(3) MENG13
ENVT_RLVTEnvironmentally Relevant KZUMWCHAR1XFELD
SEASMATCATRollout in a Season SAITYCHAR2T6WSASAITYWMSAITY
HAZMATPROFDangerous Goods Indicator Profile ADGE_PROFLCHAR3TDG41ADGD_PROFL
HIGH_VISCIndicator: Highly Viscous ADGE_IHIVICHAR1X
LOOSEORLIQIndicator: In Bulk/Liquid ADGE_ILOOSCHAR1X
CLOSED_BOXPackaging Material is Closed Packaging KZGVHCHAR1XFELD
APPD_B_RECIndicator: Approved batch record required XGCHPCHAR1XFELD
PERIOD_IND_EXPIRATION_DATEPeriod Indicator for Shelf Life Expiration Date DATTPCHAR1PERKZDATTPH_PERDKZ
ROUND_UP_RULE_EXPIRATION_DATERounding rule for calculation of SLED RDMHDCHAR1RDMHD
PROD_COMPOSITION_ON_PACKAGINGIndicator: Product composition printed on packaging PRZUSCHAR1XFELD
SALES_UNITSales unit VRKMEUNIT3T006CUNITMEINS
SALES_UNIT_ISOSales unit in ISO code VRKME_ISOCHAR3T006IISOCD_UNIT
ISSUE_UNITUnit of issue AUSMEUNIT3T006CUNITMEINS
ISSUE_UNIT_ISOUnit of issue in ISO code AUSME_ISOCHAR3T006IISOCD_UNIT
COUNTRYORICountry of origin of the material HERKLCHAR3T005LAND1LND
COUNTRYORI_ISOMaterial's country of origin in ISO code HERKL_ISOCHAR2INTCA
REGIONORIGRegion of origin of material (non-preferential origin) HERKRCHAR3T005SREGIO
COMM_CODECommodity Code/Import Code Number for Foreign Trade STAWNCHAR17T604STAWN
HAZ_MAT_NO_EXTERNALLong Material Number for HAZ_MAT_NO Field MGV_HAZ_MAT_NO_EXTERNALCHAR40MATNR_EXT
HAZ_MAT_NO_GUIDExternal GUID for HAZ_MAT_NO Field MGV_HAZ_MAT_NO_GUIDCHAR32MATNR_EGUID
HAZ_MAT_NO_VERSIONVersion Number for HAZ_MAT_NO Field MGV_HAZ_MAT_NO_VERSIONCHAR10MATNWMATNR_VERS
MATERIAL_EXTERNALLong Material Number for MATERIAL Field MGV_MATERIAL_EXTERNALCHAR40MATNR_EXT
MATERIAL_GUIDExternal GUID for MATERIAL Field MGV_MATERIAL_GUIDCHAR32MATNR_EGUID
MATERIAL_VERSIONVersion Number for MATERIAL Field MGV_MATERIAL_VERSIONCHAR10MATNWMATNR_VERS
STATEINDICATORPRICAT: Movement Indicator for the Item PRISTATEINDICATORCHAR2PRISTATEINDICATOR

Key field Non-key field



How do I retrieve data from SAP structure BAPI1171_K003 using ABAP code?

As BAPI1171_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 BAPI1171_K003 as there is no data to select.

How to access SAP table BAPI1171_K003

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

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