PRICAT_K001 SAP (PRICAT: Catalog header) Table details
Description: PRICAT: Catalog header
Table field list including key, data, relationships and ABAP select examples
PRICAT_K001 is a standard SAP Table which is used to store PRICAT: Catalog header data and is available within R/3 SAP systems depending on the version and release level.
The PRICAT_K001 table consists of various fields, each holding specific information or linking keys about PRICAT: Catalog header data available in SAP. These include PRINBR (PRICAT: Unique internal catalog number), ILN_SENDER (PRICAT: International location number of sender (CHAR 35)), UNIQUE_REFERENCE (PRICAT: Unique catalog reference of the message sender), OUTBOUNDFLAG (PRICAT: Indicator for Outbound 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. .
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_K001 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 |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
PRINBR | PRICAT: Unique internal catalog number | PRINBR | CHAR | 10 | PRINBR | PRN | PRICAT_HEADER | ||
ILN_SENDER | PRICAT: International location number of sender (CHAR 35) | PRIILNS | CHAR | 35 | CHAR35 | ILN | |||
UNIQUE_REFERENCE | PRICAT: Unique catalog reference of the message sender | PRIUNIREF | CHAR | 35 | CHAR35 | ||||
OUTBOUNDFLAG | PRICAT: Indicator for Outbound Processing | PRIOUTBOUNDFLAG | CHAR | 1 | XFELD | ||||
PRISTATE | PRICAT: Catalog processing status | PRISTATE | CHAR | 3 | PRISTATE | ||||
PRIOUTSTATE | PRICAT: Status of a Price Catalog at Outbound | PRIOUTSTATE | CHAR | 1 | PRIOUTSTATE | ||||
TEST_INDICATOR | PRICAT: Produktive / test indicator | PRITEST | CHAR | 1 | PRITEST | ||||
ASSORTMENT | Assortment | ASORT | CHAR | 10 | WRS1 | ALPHA | ASORT | WST | WSOR |
CUSTOMER | Customer Numbers | KUNNR | CHAR | 10 | KNA1 | ALPHA | KUNNR | KUN | C_KUNNR |
DATEFROM | PRICAT: Valid from date of message | PRIDATAB | DATS | 8 | DATUM | ||||
DATETO | PRICAT: 'Valid to' date of message | PRIDATBI | DATS | 8 | DATUM | ||||
PRICEKEYDATE | PRICAT: Key date for price determination | PRISTICH | DATS | 8 | DATUM | ||||
PROFIL | PRICAT: Requirements profile | PRIPRF | CHAR | 4 | PRICAT_PRO | PRIPRF | PRIP | ||
PPROCEDURE | PRICAT: Calculation schema | PRIKSM | CHAR | 6 | Assigned to domain | KALSM | |||
SALESORG | Sales Organization | VKORG | CHAR | 4 | TVKO | VKORG | VKO | C_VKORG | |
DISTR_CHAN | Distribution Channel | VTWEG | CHAR | 2 | TVTW | VTWEG | VTW | C_VTWEG | |
DIVISION | Division | SPART | CHAR | 2 | TSPA | SPART | SPA | C_SPART | |
DETERMINATION | PRICAT: Price/tax/condition determination - yes/no | PRIPREISERM | CHAR | 1 | PRIPREI | ||||
PRICECUSTOMER | PRICAT: Template Customer for Price Determination | PRIMUSTERKUNDE | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | DEBI | |
DATEFROMPOSI | PRICAT: Valid-From Date for Items | PRIDATABPOSI | DATS | 8 | DATUM | ||||
WEB_STATE | PRICAT: Indicator for Internet Release | PRIWEBSTATE | CHAR | 1 | PRIWEBSTATE | ||||
WEB_CUSTOMER | PRICAT: Template Customer for the Internet | PRIWEBCUSTOMER | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | DEBI | |
VALIDITYDATE | PRICAT: Valid-From Date for Items in Engin. Change Managemnt | PRIVALIDITYCHMG | DATS | 8 | DATUM | ||||
HISTORY | PRICAT: History ID in engineering change management | PRICHMGHISTORY | CHAR | 1 | XFELD | ||||
USEDATE | PRICAT: ID - Use Valid-From Date | PRICHMGUSEDATE | CHAR | 1 | XFELD | ||||
CHMGINTERVAL | PRICAT: Interval for Engineering Change Management in Days | PRICHMGINTERVAL | NUMC | 3 | PRICHMGINTERVAL | ||||
LASTUPDATE | PRICAT: Date Engineering Change Management Last Executed | PRICHMGDATE | DATS | 8 | DATUM | ||||
STARTSENDING | PRICAT: ID for transferring error-free catalog | PRICHMGAUTO | CHAR | 1 | XFELD | ||||
LOGNR | Application Log: External ID | BALNREXT | CHAR | 100 | BALNREXT | BALEXT | |||
LIFNR | Vendor Account Number | ELIFN | CHAR | 10 | Assigned to domain | ALPHA | LIFNR | LIF | KRED_C |
EKGRP | Purchasing Group | BKGRP | CHAR | 3 | T024 | EKGRP | EKG | ||
ILN_RECIPIENT | PRICAT: Internation location number, recipient (char 35) | PRIILNR | CHAR | 35 | CHAR35 | ||||
DATE_MESSAGE | PRICAT: last transferred date (YYYYMMDD) | PRIDATE | CHAR | 8 | EDIDAT8 | ||||
TIME_MESSAGE | PRICAT: Last transferred time (HHMMSS) | PRITIME | CHAR | 6 | EDITIM6 | ||||
PRINAME | Name of Person who Created the Object | ERNAM | CHAR | 12 | USNAM | ||||
SYNTAX_IDENT | PRICAT: Syntax identifier | PRISYNTAX | CHAR | 4 | |||||
SYNTAX_VERSION | PRICAT: Syntax version number | PRISYNVER | CHAR | 1 | |||||
PASSWORD_RECIP | PRICAT: Reference or password of recipient | PRIPASSW | CHAR | 14 | |||||
ILN_PARTY_ID | PRICAT: ILN of the data source (char 35) | PRIPARTY | CHAR | 35 | CHAR35 | ||||
CURRENCY_SENDER | PRICAT: Currency of the sender in ISO | PRICURRS | CHAR | 3 | EDIF6345 | ||||
CURRENCY_RECIP | PRICAT: Currency of the recipient in ISO | PRICURRR | CHAR | 3 | EDIF6345 | ||||
KART | Customizing for Price Catalog: Catalog Type | KATALOGART | CHAR | 10 | PRICAT_KART | CHAR10 | |||
VIEW_PERIOD | Price Catalog: Display Time Period Planned Changes | PRI_VIEW_PERIOD | INT1 | 3 | KALENDERWOCHEN | ||||
WEEKLY_RECUR | Price Catalog: Deadline All (Week) | PRI_RECURRENCE | INT1 | 3 | KALENDERWOCHEN | ||||
PRI_MO | PRICAT: Planned Change - Monday | WRF_PRI_MO | CHAR | 1 | FLAG | ||||
PRI_DI | PRICAT: Planned Change - Tuesday | WRF_PRI_DI | CHAR | 1 | FLAG | ||||
PRI_MI | PRICAT: Planned Change - Wednesday | WRF_PRI_MI | CHAR | 1 | FLAG | ||||
PRI_DO | PRICAT: Planned Change - Thursday | WRF_PRI_DO | CHAR | 1 | FLAG | ||||
PRI_FR | PRICAT: Planned Change - Friday | WRF_PRI_FR | CHAR | 1 | FLAG | ||||
PRI_SA | PRICAT: Planned Change - Saturday | WRF_PRI_SA | CHAR | 1 | FLAG | ||||
PRI_SO | PRICAT: Planned Change - Sunday | WRF_PRI_SO | CHAR | 1 | FLAG | ||||
WGDS_TM_COUNTRY | Country Key | LAND1 | CHAR | 3 | T005 | LAND1 | LND | ||
WGDS_TM_SUBDIVIS | STATE (State, Province, County) | REGIO | CHAR | 3 | T005S | REGIO |
Key field | Non-key field |
How do I retrieve data from SAP table PRICAT_K001 using ABAP code
The following ABAP code Example will allow you to do a basic selection on PRICAT_K001 to SELECT all data from the tableDATA: WA_PRICAT_K001 TYPE PRICAT_K001.
SELECT SINGLE *
FROM PRICAT_K001
INTO CORRESPONDING FIELDS OF WA_PRICAT_K001
WHERE...
How to access SAP table PRICAT_K001
Within an ECC or HANA version of SAP you can also view further information about PRICAT_K001 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