SAP table FIPR_PRODV (Version of a Prodcut, Master Data)

SAP table FIPR_PRODV has 4 primary key fields being MANDT,PRODINT,VERSION,XACTIVE.

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 T000 MANDT
PRODINT Internal Product ID CHAR 18 0 FIPR_PRODUCT FIPR_PRODINT
VERSION Version of a Product NUMC 3 0 FIPR_VERSION
XACTIVE ID Version is Active (Can Have Instances) CHAR 1 0 FIPR_XACTIVE
STATUS Status of a Version CHAR 2 0 FIPR_STATUSVERS
10 Parked/New Product
11 Parked/New Version
12 Parked/Revised
20 Flagged for Activation
30 Active
40 Flagged for Archiving
XISUSED Indicator: There Are Instances for Version CHAR 1 0 FIPR_XVERSUSED
VALID_FROM Valid from DATS 8 0 FIPR_VALID_FROM
VALID_TO Valid to DATS 8 0 FIPR_VALID_TO
CRUSER User who created the object CHAR 12 0 FIPR_CRUSER
CRDATE Date on which the object was created DATS 8 0 FIPR_CRDATE
CRTIME Time at which the object was created TIMS 6 0 FIPR_CRTIME
CHUSER Last user to change object CHAR 12 0 FIPR_CHUSER
CHDATE Date on which the object was last changed DATS 8 0 FIPR_CHDATE
CHTIME Time at Which the Object Was Last Changed TIMS 6 0 FIPR_CHTIME
RLUSER User who released object CHAR 12 0 FIPR_RLUSER
RLDATE Date on Which Object Was Released DATS 8 0 FIPR_RLDATE
RLTIME Time at Which Object Was Released TIMS 6 0 FIPR_RLTIME

FIPR_PRODV foreign key relationships

Table Field Check Table Check Field
0 FIPR_PRODV MANDT T000 Clients MANDT