SAP table PRICAT_K00C (PRICAT: Customer of a Price Catalog)

SAP table PRICAT_K00C has 3 primary key fields being MANDT,PRINBR,CUSTOMER.

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 MANDT
PRINBR PRICAT: Unique internal catalog number CHAR 10 0 PRINBR
CUSTOMER Customer Number CHAR 10 0 KNA1 KUNNR
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
STATE PRICAT: Status of the Catalog for a Customer CHAR 2 0 PRIBEARBSTATKUNDE
00 To be transferred
01 Transferred
02 Postprocessing Required
03 Deleted
TRANSPORT PRICAT: ID for Transfer CHAR 1 0 PRIKZUEBERTRAGUNG
SNDPRT Partner type of sender CHAR 2 0 TEDST EDIUSNDPRT
SNDPFC Partner function of sender CHAR 2 0 EDIUSNDPFC
PARNUM Partner number CHAR 10 0 EDPP1 EDIPPARNUM
USEOLDFORMAT PRICAT: ID for whether the PRICAT IDoc is to be used CHAR 1 0 PRIUSEOLDFORMAT
USEOLDCONDSEGS PRICAT: Indicator for Old Condition Segment in PRICAT02 CHAR 1 0 PRIUSEOLDCONDSEGS
WEBFLAG PRICAT: Indicator for Internet Release for Customers CHAR 1 0 PRIWEBCUSTFLAG
ILN_PARTY_ID PRICAT: ILN of the data source (char 35) CHAR 35 0 PRIPARTY
PASSWORD_RECIP PRICAT: Reference or password of recipient CHAR 14 0 PRIPASSW
CURRENCY_RECIP PRICAT: Currency of the recipient in ISO CHAR 3 0 PRICURRR
BEGRU Authorization Group CHAR 4 0 BEGRU

PRICAT_K00C foreign key relationships

Table Field Check Table Check Field
0 PRICAT_K00C CUSTOMER KNA1 General Data in Customer Master MANDT
0 PRICAT_K00C CUSTOMER KNA1 General Data in Customer Master KUNNR
1 PRICAT_K00C PARNUM EDPP1 EDI Partner (general partner profiles - inb. and outb.) MANDT
1 PRICAT_K00C PARNUM EDPP1 EDI Partner (general partner profiles - inb. and outb.) PARNUM
0 PRICAT_K00C SNDPRT TEDST SAP EDI Form routines for reading master data RCVPRT