SAP Table PRICAT_PRO

PRICAT Outbound: Requirements Profile (Customizing)

PRICAT_PRO (PRICAT Outbound: Requirements Profile (Customizing)) 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_PRO to other SAP tables.

Source: PRICAT_PRO (PRICAT Outbound: Requirements Profile (Customizing))

PRICAT_PRO table fields

Field

Data element

Checktable

Datatype

Length

Decimals

MANDT

Client

MANDT

T000

CLNT

PROFIL

PRICAT: Requirements profile

PRIPRF

CHAR

WERKS

PRICAT: Plant for material data determination

PRIWRK

T001W

CHAR

AUART

PRICAT: Sales document type for calc. schema determination

PRIAUA

TVAK

CHAR

BRUTTO_KA

PRICAT: Condition type for gross price determination

PRIKAB

T685

CHAR

BRUTTO_ZW

PRICAT: Condition subtotal

PRIZWI

CHAR

Possible values

NULL	No separate sub-totals
1	Carry over value to KOMP-KZWI1
2	Carry over value to KOMP-KZWI2
3	Carry over value to KOMP-KZWI3
4	Carry over value to KOMP-KZWI4
5	Carry over value to KOMP-KZWI5
6	Carry over value to KOMP-KZWI6
7	Carry over value to KOMP_BONBA (rebate basis 1)
8	Copy values according to KOMP-PREVA (preference value)
9	Copy values to KOMP-BRTWR (gross value)
A	Carry over price to KOMP-CMPRE (credit price)
B	Carry over value to KOMP-WAVWR (cost)
C	Carry over value to KOMP-GKWRT (statistical value)
D	Copy value to XWORKD
E	Copy value to XWORKE
F	Copy value to XWORKF
G	Copy value to XWORKG
H	Copy value to XWORKH
I	Copy value to XWORKI
J	Copy value to XWORKJ
K	Copy price to XWORKK
L	Copy price to XWORKL
M	Copy price to XWORKM
Q	VAT base amount for internally posted material (only IS-OIL)
S	Copy values to KOMP-EFFWR (effective value)
Y	Copy value to KOMP-OIIDC (IS-OIL/only JVA CRP Pricing)
Z	Copy value to KOMP-OIEBC (IS-OIL/only JVA CRP Pricing)
N	Value Transfer to KOMP-NRAB_VALUE (Free Goods)

NETTO_KA

PRICAT: Condition type for net price determination

PRIKAN

T685

CHAR

NETTO_ZW

PRICAT: Condition subtotal

PRIZWI

CHAR

Possible values

NULL	No separate sub-totals
1	Carry over value to KOMP-KZWI1
2	Carry over value to KOMP-KZWI2
3	Carry over value to KOMP-KZWI3
4	Carry over value to KOMP-KZWI4
5	Carry over value to KOMP-KZWI5
6	Carry over value to KOMP-KZWI6
7	Carry over value to KOMP_BONBA (rebate basis 1)
8	Copy values according to KOMP-PREVA (preference value)
9	Copy values to KOMP-BRTWR (gross value)
A	Carry over price to KOMP-CMPRE (credit price)
B	Carry over value to KOMP-WAVWR (cost)
C	Carry over value to KOMP-GKWRT (statistical value)
D	Copy value to XWORKD
E	Copy value to XWORKE
F	Copy value to XWORKF
G	Copy value to XWORKG
H	Copy value to XWORKH
I	Copy value to XWORKI
J	Copy value to XWORKJ
K	Copy price to XWORKK
L	Copy price to XWORKL
M	Copy price to XWORKM
Q	VAT base amount for internally posted material (only IS-OIL)
S	Copy values to KOMP-EFFWR (effective value)
Y	Copy value to KOMP-OIIDC (IS-OIL/only JVA CRP Pricing)
Z	Copy value to KOMP-OIEBC (IS-OIL/only JVA CRP Pricing)
N	Value Transfer to KOMP-NRAB_VALUE (Free Goods)

VKP_KA

PRICAT: Condition type for retail price determination

PRIKAV

T685

CHAR

VKP_ZW

PRICAT: Condition subtotal

PRIZWI

CHAR

Possible values

NULL	No separate sub-totals
1	Carry over value to KOMP-KZWI1
2	Carry over value to KOMP-KZWI2
3	Carry over value to KOMP-KZWI3
4	Carry over value to KOMP-KZWI4
5	Carry over value to KOMP-KZWI5
6	Carry over value to KOMP-KZWI6
7	Carry over value to KOMP_BONBA (rebate basis 1)
8	Copy values according to KOMP-PREVA (preference value)
9	Copy values to KOMP-BRTWR (gross value)
A	Carry over price to KOMP-CMPRE (credit price)
B	Carry over value to KOMP-WAVWR (cost)
C	Carry over value to KOMP-GKWRT (statistical value)
D	Copy value to XWORKD
E	Copy value to XWORKE
F	Copy value to XWORKF
G	Copy value to XWORKG
H	Copy value to XWORKH
I	Copy value to XWORKI
J	Copy value to XWORKJ
K	Copy price to XWORKK
L	Copy price to XWORKL
M	Copy price to XWORKM
Q	VAT base amount for internally posted material (only IS-OIL)
S	Copy values to KOMP-EFFWR (effective value)
Y	Copy value to KOMP-OIIDC (IS-OIL/only JVA CRP Pricing)
Z	Copy value to KOMP-OIEBC (IS-OIL/only JVA CRP Pricing)
N	Value Transfer to KOMP-NRAB_VALUE (Free Goods)

STAFFEL

PRICAT: Scales are to be Transferred

PRISTAF

CHAR

Possible values

NULL	Scales are not transferred
X	Scales are transferred

KONDIT

PRICAT: Additional condition data relating to price info.

PRIPREI

CHAR

Possible values

NULL	Prices are not transferred
X	Prices are transferred

KONDIT_1

PRICAT: Condition type to be transferred to message

PRIKSL

T685

CHAR

KONDIT_2

PRICAT: Condition type to be transferred to message

PRIKSL

T685

CHAR

KONDIT_3

PRICAT: Condition type to be transferred to message

PRIKSL

T685

CHAR

KONDIT_4

PRICAT: Condition type to be transferred to message

PRIKSL

T685

CHAR

STEUER_1

PRICAT: Condition type for tax determination

PRIKST

T685

CHAR

STEUER_2

PRICAT: Condition type for tax determination

PRIKST

T685

CHAR

STEUER_3

PRICAT: Condition type for tax determination

PRIKST

T685

CHAR

MWST_KZ

PRICAT: Which condition type is interpreted as VAT

PRIMWST

NUMC

Possible values

1

BOM_PLANT

PRICAT: Plant for BOM Determination

PRIBOMWERKS

T001W

CHAR

BOM_USAGE

PRICAT: BOM Usage for Catalog Creation

PRIBOMUSAGE

T416

CHAR

PRICAT_PRO foreign key relationships

Table	Field	Foreign key table	Foreign key field	Check table		Check field
PRICAT_PRO	AUART	PRICAT_PRO	AUART	TVAK	Sales Document Types	AUART
PRICAT_PRO	AUART	PRICAT_PRO	MANDT	TVAK	Sales Document Types	MANDT
PRICAT_PRO	BOM_PLANT	PRICAT_PRO	BOM_PLANT	T001W	Plants/Branches	WERKS
PRICAT_PRO	BOM_PLANT	PRICAT_PRO	MANDT	T001W	Plants/Branches	MANDT
PRICAT_PRO	BOM_USAGE	PRICAT_PRO	BOM_USAGE	T416	BOM Usage - Item Statuses	STLAN
PRICAT_PRO	BOM_USAGE	PRICAT_PRO	MANDT	T416	BOM Usage - Item Statuses	MANDT
PRICAT_PRO	BRUTTO_KA	'A'		T685	Conditions: Types	KVEWE
PRICAT_PRO	BRUTTO_KA	PRICAT_PRO	MANDT	T685	Conditions: Types	MANDT
PRICAT_PRO	BRUTTO_KA	'V '		T685	Conditions: Types	KAPPL
PRICAT_PRO	BRUTTO_KA	PRICAT_PRO	BRUTTO_KA	T685	Conditions: Types	KSCHL
PRICAT_PRO	KONDIT_1	PRICAT_PRO	KONDIT_1	T685	Conditions: Types	KSCHL
PRICAT_PRO	KONDIT_1	PRICAT_PRO	MANDT	T685	Conditions: Types	MANDT
PRICAT_PRO	KONDIT_1	'A'		T685	Conditions: Types	KVEWE
PRICAT_PRO	KONDIT_1	'V '		T685	Conditions: Types	KAPPL
PRICAT_PRO	KONDIT_2	PRICAT_PRO	MANDT	T685	Conditions: Types	MANDT
PRICAT_PRO	KONDIT_2	'A'		T685	Conditions: Types	KVEWE
PRICAT_PRO	KONDIT_2	'V '		T685	Conditions: Types	KAPPL
PRICAT_PRO	KONDIT_2	PRICAT_PRO	KONDIT_2	T685	Conditions: Types	KSCHL
PRICAT_PRO	KONDIT_3	PRICAT_PRO	KONDIT_3	T685	Conditions: Types	KSCHL
PRICAT_PRO	KONDIT_3	PRICAT_PRO	MANDT	T685	Conditions: Types	MANDT
PRICAT_PRO	KONDIT_3	'A'		T685	Conditions: Types	KVEWE
PRICAT_PRO	KONDIT_3	'V '		T685	Conditions: Types	KAPPL
PRICAT_PRO	KONDIT_4	PRICAT_PRO	MANDT	T685	Conditions: Types	MANDT
PRICAT_PRO	KONDIT_4	'A'		T685	Conditions: Types	KVEWE
PRICAT_PRO	KONDIT_4	'V '		T685	Conditions: Types	KAPPL
PRICAT_PRO	KONDIT_4	PRICAT_PRO	KONDIT_4	T685	Conditions: Types	KSCHL
PRICAT_PRO	MANDT	PRICAT_PRO	MANDT	T000	Clients	MANDT
PRICAT_PRO	NETTO_KA	PRICAT_PRO	NETTO_KA	T685	Conditions: Types	KSCHL
PRICAT_PRO	NETTO_KA	PRICAT_PRO	MANDT	T685	Conditions: Types	MANDT
PRICAT_PRO	NETTO_KA	'A'		T685	Conditions: Types	KVEWE
PRICAT_PRO	NETTO_KA	'V '		T685	Conditions: Types	KAPPL
PRICAT_PRO	STEUER_1	PRICAT_PRO	MANDT	T685	Conditions: Types	MANDT
PRICAT_PRO	STEUER_1	'A'		T685	Conditions: Types	KVEWE
PRICAT_PRO	STEUER_1	'V '		T685	Conditions: Types	KAPPL
PRICAT_PRO	STEUER_1	PRICAT_PRO	STEUER_1	T685	Conditions: Types	KSCHL
PRICAT_PRO	STEUER_2	PRICAT_PRO	STEUER_2	T685	Conditions: Types	KSCHL
PRICAT_PRO	STEUER_2	PRICAT_PRO	MANDT	T685	Conditions: Types	MANDT
PRICAT_PRO	STEUER_2	'A'		T685	Conditions: Types	KVEWE
PRICAT_PRO	STEUER_2	'V '		T685	Conditions: Types	KAPPL
PRICAT_PRO	STEUER_3	PRICAT_PRO	MANDT	T685	Conditions: Types	MANDT
PRICAT_PRO	STEUER_3	PRICAT_PRO	STEUER_3	T685	Conditions: Types	KSCHL
PRICAT_PRO	STEUER_3	'V '		T685	Conditions: Types	KAPPL
PRICAT_PRO	STEUER_3	'A'		T685	Conditions: Types	KVEWE
PRICAT_PRO	VKP_KA	PRICAT_PRO	VKP_KA	T685	Conditions: Types	KSCHL
PRICAT_PRO	VKP_KA	'V '		T685	Conditions: Types	KAPPL
PRICAT_PRO	VKP_KA	'A'		T685	Conditions: Types	KVEWE
PRICAT_PRO	VKP_KA	PRICAT_PRO	MANDT	T685	Conditions: Types	MANDT
PRICAT_PRO	WERKS	PRICAT_PRO	MANDT	T001W	Plants/Branches	MANDT
PRICAT_PRO	WERKS	PRICAT_PRO	WERKS	T001W	Plants/Branches	WERKS