SAP table PRICAT_K001 (PRICAT: Catalog header)

SAP table PRICAT_K001 has 2 primary key fields being MANDT,PRINBR.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
PRINBR PRICAT: Unique internal catalog number CHAR 10 0 PRINBR
ILN_SENDER PRICAT: International location number of sender (CHAR 35) CHAR 35 0 PRIILNS
UNIQUE_REFERENCE PRICAT: Unique catalog reference of the message sender CHAR 35 0 PRIUNIREF
OUTBOUNDFLAG PRICAT: Indicator for Outbound Processing CHAR 1 0 PRIOUTBOUNDFLAG
PRISTATE PRICAT: Catalog processing status CHAR 3 0 PRISTATE
001 Open
002 Processed
003 Closed
PRIOUTSTATE PRICAT: Status of a Price Catalog at Outbound CHAR 1 0 PRIOUTSTATE
1 Open
2 Transferred
3 Completed
4 Errors
TEST_INDICATOR PRICAT: Produktive / test indicator CHAR 1 0 PRITEST
The PRICAT message comes from a productive transfer
X The PRICAT message comes from a test transfer
ASSORTMENT Assortment CHAR 10 0 WRS1 ASORT
CUSTOMER Customer Number CHAR 10 0 KNA1 KUNNR
DATEFROM PRICAT: Valid from date of message DATS 8 0 PRIDATAB
DATETO PRICAT: "Valid to" date of message DATS 8 0 PRIDATBI
PRICEKEYDATE PRICAT: Key date for price determination DATS 8 0 PRISTICH
PROFIL PRICAT: Requirements profile CHAR 4 0 PRICAT_PRO PRIPRF
PPROCEDURE PRICAT: Calculation schema CHAR 6 0 * PRIKSM
SALESORG Sales Organization CHAR 4 0 TVKO VKORG
DISTR_CHAN Distribution Channel CHAR 2 0 TVTW VTWEG
DIVISION Division CHAR 2 0 TSPA SPART
DETERMINATION PRICAT: Price/tax/condition determination - yes/no CHAR 1 0 PRIPREISERM
PRICECUSTOMER PRICAT: Template Customer for Price Determination CHAR 10 0 PRIMUSTERKUNDE
DATEFROMPOSI PRICAT: Valid-From Date for Items DATS 8 0 PRIDATABPOSI
WEB_STATE PRICAT: Indicator for Internet Release CHAR 1 0 PRIWEBSTATE
No release
1 Only for known customers
2 Only for assigned customers
3 General release
WEB_CUSTOMER PRICAT: Template Customer for the Internet CHAR 10 0 PRIWEBCUSTOMER
VALIDITYDATE PRICAT: Valid-From Date for Items in Engin. Change Managemnt DATS 8 0 PRIVALIDITYCHMG
HISTORY PRICAT: History ID in engineering change management CHAR 1 0 PRICHMGHISTORY
USEDATE PRICAT: ID - Use Valid-From Date CHAR 1 0 PRICHMGUSEDATE
CHMGINTERVAL PRICAT: Interval for Engineering Change Management in Days NUMC 3 0 PRICHMGINTERVAL
LASTUPDATE PRICAT: Date Engineering Change Management Last Executed DATS 8 0 PRICHMGDATE
STARTSENDING PRICAT: ID for transferring error-free catalog CHAR 1 0 PRICHMGAUTO
LOGNR Application Log: External ID CHAR 100 0 BALNREXT
LIFNR Vendor's account number CHAR 10 0 LFA1 ELIFN
EKGRP Purchasing Group CHAR 3 0 T024 BKGRP
ILN_RECIPIENT PRICAT: Internation location number, recipient (char 35) CHAR 35 0 PRIILNR
DATE_MESSAGE PRICAT: last transferred date (YYYYMMDD) CHAR 8 0 PRIDATE
TIME_MESSAGE PRICAT: Last transferred time (HHMMSS) CHAR 6 0 PRITIME
PRINAME Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
SYNTAX_IDENT PRICAT: Syntax identifier CHAR 4 0 PRISYNTAX
SYNTAX_VERSION PRICAT: Syntax version number CHAR 1 0 PRISYNVER
PASSWORD_RECIP PRICAT: Reference or password of recipient CHAR 14 0 PRIPASSW
ILN_PARTY_ID PRICAT: ILN of the data source (char 35) CHAR 35 0 PRIPARTY
CURRENCY_SENDER PRICAT: Currency of the sender in ISO CHAR 3 0 PRICURRS
CURRENCY_RECIP PRICAT: Currency of the recipient in ISO CHAR 3 0 PRICURRR
KART Customizing for Price Catalog: Catalog Type CHAR 10 0 PRICAT_KART KATALOGART
VIEW_PERIOD Price Catalog: Display Time Period Planned Changes INT1 3 0 PRI_VIEW_PERIOD
WEEKLY_RECUR Price Catalog: Deadline All (Week) INT1 3 0 PRI_RECURRENCE
PRI_MO PRICAT: Planned Change - Monday CHAR 1 0 WRF_PRI_MO
PRI_DI PRICAT: Planned Change - Tuesday CHAR 1 0 WRF_PRI_DI
PRI_MI PRICAT: Planned Change - Wednesday CHAR 1 0 WRF_PRI_MI
PRI_DO PRICAT: Planned Change - Thursday CHAR 1 0 WRF_PRI_DO
PRI_FR PRICAT: Planned Change - Friday CHAR 1 0 WRF_PRI_FR
PRI_SA PRICAT: Planned Change - Saturday CHAR 1 0 WRF_PRI_SA
PRI_SO PRICAT: Planned Change - Sunday CHAR 1 0 WRF_PRI_SO
WGDS_TM_COUNTRY Country/Region Key CHAR 3 0 T005 LAND1
WGDS_TM_SUBDIVIS Region (State, Province, County) CHAR 3 0 T005S REGIO
BEGRU Authorization Group CHAR 4 0 BEGRU

PRICAT_K001 foreign key relationships

Table Field Check Table Check Field
0 PRICAT_K001 ASSORTMENT WRS1 Assortment MANDT
0 PRICAT_K001 ASSORTMENT WRS1 Assortment ASORT
1 PRICAT_K001 CUSTOMER KNA1 General Data in Customer Master MANDT
1 PRICAT_K001 CUSTOMER KNA1 General Data in Customer Master KUNNR
0 PRICAT_K001 DISTR_CHAN TVTW Organizational Unit: Distribution Channels MANDT
0 PRICAT_K001 DISTR_CHAN TVTW Organizational Unit: Distribution Channels VTWEG
1 PRICAT_K001 DIVISION TSPA Organizational Unit: Sales Divisions MANDT
1 PRICAT_K001 DIVISION TSPA Organizational Unit: Sales Divisions SPART
0 PRICAT_K001 EKGRP T024 Purchasing Groups EKGRP
1 PRICAT_K001 KART PRICAT_KART Price Catalog Customizing: Definition of Catlog Type MANDT
1 PRICAT_K001 KART PRICAT_KART Price Catalog Customizing: Definition of Catlog Type KATALOGART
0 PRICAT_K001 LIFNR LFA1 Supplier Master (General Section) MANDT
0 PRICAT_K001 LIFNR LFA1 Supplier Master (General Section) LIFNR
1 PRICAT_K001 PROFIL PRICAT_PRO PRICAT Outbound: Requirements Profile (Customizing) MANDT
1 PRICAT_K001 PROFIL PRICAT_PRO PRICAT Outbound: Requirements Profile (Customizing) PROFIL
0 PRICAT_K001 SALESORG TVKO Organizational Unit: Sales Organizations MANDT
0 PRICAT_K001 SALESORG TVKO Organizational Unit: Sales Organizations VKORG
1 PRICAT_K001 WGDS_TM_COUNTRY T005 Countries MANDT
1 PRICAT_K001 WGDS_TM_COUNTRY T005 Countries LAND1
0 PRICAT_K001 WGDS_TM_SUBDIVIS T005S Taxes: Region (Province) Key LAND1