SAP table WCAT_PROFILE (Cost allocation profile)
SAP table WCAT_PROFILE has 2 primary key fields being MANDT,CAT_PROF.
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
Client
CLNT
3
0
*
MANDT
Cost allocation profile
CHAR
4
0
WCAT_PROF
CAT_TYPE
Type of cost allocation
CHAR
1
0
WCAT_TYPE
Possible values
1
BI Info Cube
2
Equal distribution across site
3
Custom
CAT_ACCOUNT
Target account (bucket) of cost allocation
CHAR
1
0
WCAT_ACCOUNT
Possible values
RMA inventory adjustment account (separate bucket)
1
RMA inventory adjustment account (receipts bucket)
2
RMA COGS adjustment account
CAT_SITE
Distribution by site
CHAR
1
0
WCAT_SITE
Possible values
Do not distribute by site
1
Distribute by site
CAT_OBJECT
Distribution by object
CHAR
1
0
WCAT_OBJECT
Possible values
1
Distribute automatically undistributed items
2
Allow manual distribution of undistributed items
RFCDEST
Logical destination (specified in function call)
CHAR
32
0
RFCDES
RFCDEST
REF_CUBE
Info provider with reference data for cost allocation
CHAR
30
0
WCAT_CUBE
KYFNM
Key figure
CHAR
30
0
RSKYFNM
KYFNM2
Second key figure
CHAR
30
0
WCAT_KYFNM
UNINM
Unit InfoObject (currency/unit)
CHAR
30
0
RSUNINM
CHANM
Account characteristic of cost allocation reference data
CHAR
30
0
WCAT_ACCNM
CHAVL
Account value of cost allocation reference data
CHAR
21
0
WCAT_ACCVL
SEL_AGGR
Preaggregate Selection
CHAR
1
0
WCAT_SEL_AGGR
Possible values
Preaggregate selection by objects
1
Do not preaggregate selection
SEL_PER
Period for selection of cumulative reference data
CHAR
1
0
WCAT_SEL_PER
Possible values
Current period
1
Previous period
2
Previous fiscal year
3
Custom
PURORG
Take purchasing organization into account
CHAR
1
0
WCAT_PURORG
VENDOR
Take supplier into account
CHAR
1
0
WCAT_VENDOR
VENDSUB
Take supplier sub-range into account
CHAR
1
0
WCAT_VENDSUB
PURGRP
Take purchasing group into account
CHAR
1
0
WCAT_PURGRP
USE_NEG_BAL_CHK
Flag: Use reference data cube for negative balance check
CHAR
1
0
WCAT_USE_CUBE_FOR_NEG_BAL_CHK