SAP Table PRICAT_K001

PRICAT: Catalog header

PRICAT_K001 (PRICAT: Catalog header) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link PRICAT_K001 to other SAP tables.

Source: PRICAT_K001 (PRICAT: Catalog header)

PRICAT_K001 table fields

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

PRICAT_K001 foreign key relationships

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