SAP ABAP Table PRICAT_K001 (PRICAT: Catalog header)

Hierarchy

☛ EA-RETAIL (Software Component) SAP Enterprise Extension Retail
   ⤷ SD-EDI (Application Component) Electronic Data Interchange
     ⤷ VPRI (Package) Application Development R/3 Retail/CP EDI messages

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	PRICAT_K001	Table Relationship Diagram
Short Description	PRICAT: Catalog header

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	PRINBR	☑	PRINBR	PRINBR	CHAR	10	0	PRICAT: Unique internal catalog number
3	ILN_SENDER	☐	PRIILNS	CHAR35	CHAR	35	0	PRICAT: International location number of sender (CHAR 35)
4	UNIQUE_REFERENCE	☐	PRIUNIREF	CHAR35	CHAR	35	0	PRICAT: Unique catalog reference of the message sender
5	OUTBOUNDFLAG	☐	PRIOUTBOUNDFLAG	XFELD	CHAR	1	0	PRICAT: Indicator for Outbound Processing
6	PRISTATE	☐	PRISTATE	PRISTATE	CHAR	3	0	PRICAT: Catalog processing status
7	PRIOUTSTATE	☐	PRIOUTSTATE	PRIOUTSTATE	CHAR	1	0	PRICAT: Status of a Price Catalog at Outbound
8	TEST_INDICATOR	☐	PRITEST	PRITEST	CHAR	1	0	PRICAT: Produktive / test indicator
9	.INCLUDE	☐				0	0	PRICAT: Catalog Header Data for Outbound Processing
10	.INCLUDE	☐				0	0	PRICAT: Structure for Creating a Price Catalog
11	ASSORTMENT	☐	ASORT	ASORT	CHAR	10	0	Assortment	WRS1
12	CUSTOMER	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	KNA1
13	DATEFROM	☐	PRIDATAB	DATUM	DATS	8	0	PRICAT: Valid from date of message
14	DATETO	☐	PRIDATBI	DATUM	DATS	8	0	PRICAT: "Valid to" date of message
15	PRICEKEYDATE	☐	PRISTICH	DATUM	DATS	8	0	PRICAT: Key date for price determination
16	PROFIL	☐	PRIPRF	PRIPRF	CHAR	4	0	PRICAT: Requirements profile	PRICAT_PRO
17	PPROCEDURE	☐	PRIKSM	KALSM	CHAR	6	0	PRICAT: Calculation schema	*
18	SALESORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
19	DISTR_CHAN	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
20	DIVISION	☐	SPART	SPART	CHAR	2	0	Division	TSPA
21	DETERMINATION	☐	PRIPREISERM	PRIPREI	CHAR	1	0	PRICAT: Price/tax/condition determination - yes/no
22	PRICECUSTOMER	☐	PRIMUSTERKUNDE	KUNNR	CHAR	10	0	PRICAT: Template Customer for Price Determination	*
23	DATEFROMPOSI	☐	PRIDATABPOSI	DATUM	DATS	8	0	PRICAT: Valid-From Date for Items
24	.INCLUDE	☐				0	0	PRICAT: Settings for the Internet
25	.INCLUDE	☐				0	0	PRICAT: Price Catalog Settings for the Internet
26	WEB_STATE	☐	PRIWEBSTATE	PRIWEBSTATE	CHAR	1	0	PRICAT: Indicator for Internet Release
27	WEB_CUSTOMER	☐	PRIWEBCUSTOMER	KUNNR	CHAR	10	0	PRICAT: Template Customer for the Internet	*
28	.INCLUDE	☐				0	0	PRICAT: Engineering Change Management
29	.INCLUDE	☐				0	0	PRICAT: Parameters for Engineering Change Management
30	VALIDITYDATE	☐	PRIVALIDITYCHMG	DATUM	DATS	8	0	PRICAT: Valid-From Date for Items in Engin. Change Managemnt
31	HISTORY	☐	PRICHMGHISTORY	XFELD	CHAR	1	0	PRICAT: History ID in engineering change management
32	USEDATE	☐	PRICHMGUSEDATE	XFELD	CHAR	1	0	PRICAT: ID - Use Valid-From Date
33	CHMGINTERVAL	☐	PRICHMGINTERVAL	PRICHMGINTERVAL	NUMC	3	0	PRICAT: Interval for Engineering Change Management in Days
34	LASTUPDATE	☐	PRICHMGDATE	DATUM	DATS	8	0	PRICAT: Date Engineering Change Management Last Executed
35	STARTSENDING	☐	PRICHMGAUTO	XFELD	CHAR	1	0	PRICAT: ID for transferring error-free catalog
36	LOGNR	☐	BALNREXT	BALNREXT	CHAR	100	0	Application Log: External ID
37	LIFNR	☐	ELIFN	LIFNR	CHAR	10	0	Vendor's account number	*
38	EKGRP	☐	BKGRP	EKGRP	CHAR	3	0	Purchasing Group	T024
39	ILN_RECIPIENT	☐	PRIILNR	CHAR35	CHAR	35	0	PRICAT: Internation location number, recipient (char 35)
40	DATE_MESSAGE	☐	PRIDATE	EDIDAT8	CHAR	8	0	PRICAT: last transferred date (YYYYMMDD)
41	TIME_MESSAGE	☐	PRITIME	EDITIM6	CHAR	6	0	PRICAT: Last transferred time (HHMMSS)
42	PRINAME	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
43	SYNTAX_IDENT	☐	PRISYNTAX		CHAR	4	0	PRICAT: Syntax identifier
44	SYNTAX_VERSION	☐	PRISYNVER		CHAR	1	0	PRICAT: Syntax version number
45	PASSWORD_RECIP	☐	PRIPASSW		CHAR	14	0	PRICAT: Reference or password of recipient
46	ILN_PARTY_ID	☐	PRIPARTY	CHAR35	CHAR	35	0	PRICAT: ILN of the data source (char 35)
47	CURRENCY_SENDER	☐	PRICURRS	EDIF6345	CHAR	3	0	PRICAT: Currency of the sender in ISO
48	CURRENCY_RECIP	☐	PRICURRR	EDIF6345	CHAR	3	0	PRICAT: Currency of the recipient in ISO
49	KART	☐	KATALOGART	CHAR10	CHAR	10	0	Customizing for Price Catalog: Catalog Type	PRICAT_KART
50	.INCLUDE	☐				0	0	Price Catalog Change Management: Planned Changes
51	VIEW_PERIOD	☐	PRI_VIEW_PERIOD	KALENDERWOCHEN	INT1	3	0	Price Catalog: Display Time Period Planned Changes
52	WEEKLY_RECUR	☐	PRI_RECURRENCE	KALENDERWOCHEN	INT1	3	0	Price Catalog: Deadline All (Week)
53	PRI_MO	☐	WRF_PRI_MO	FLAG	CHAR	1	0	PRICAT: Planned Change - Monday
54	PRI_DI	☐	WRF_PRI_DI	FLAG	CHAR	1	0	PRICAT: Planned Change - Tuesday
55	PRI_MI	☐	WRF_PRI_MI	FLAG	CHAR	1	0	PRICAT: Planned Change - Wednesday
56	PRI_DO	☐	WRF_PRI_DO	FLAG	CHAR	1	0	PRICAT: Planned Change - Thursday
57	PRI_FR	☐	WRF_PRI_FR	FLAG	CHAR	1	0	PRICAT: Planned Change - Friday
58	PRI_SA	☐	WRF_PRI_SA	FLAG	CHAR	1	0	PRICAT: Planned Change - Saturday
59	PRI_SO	☐	WRF_PRI_SO	FLAG	CHAR	1	0	PRICAT: Planned Change - Sunday

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PRICAT_K001	ASSORTMENT	WRS1	ASORT
2	PRICAT_K001	CUSTOMER	KNA1	KUNNR
3	PRICAT_K001	DISTR_CHAN	TVTW	VTWEG
4	PRICAT_K001	DIVISION	TSPA	SPART
5	PRICAT_K001	EKGRP	T024	EKGRP	REF	1	1
6	PRICAT_K001	KART	PRICAT_KART	KATALOGART	KEY
7	PRICAT_K001	MANDT	T000	MANDT	KEY	1	1
8	PRICAT_K001	PROFIL	PRICAT_PRO	PROFIL
9	PRICAT_K001	SALESORG	TVKO	VKORG

History

Last changed by/on	SAP	20130529
SAP Release Created in