SAP Table FIPR_PRODV
Version of a Prodcut, Master Data
FIPR_PRODV (Version of a Prodcut, Master Data) 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 FIPR_PRODV to other SAP tables.
Source: FIPR_PRODV (Version of a Prodcut, Master Data)
FIPR_PRODV table fields
Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||||||||||
PRODINT | Internal Product ID | FIPR_PRODINT | FIPR_PRODUCT | CHAR | 18 | 0 | ||||||||||||||
VERSION | Version of a Product | FIPR_VERSION | NUMC | 3 | 0 | |||||||||||||||
XACTIVE | ID Version is Active (Can Have Instances) | FIPR_XACTIVE | CHAR | 1 | 0 | |||||||||||||||
STATUS | Status of a Version | FIPR_STATUSVERS | CHAR | 2 | 0 |
Possible values
|
||||||||||||||
XISUSED | Indicator: There Are Instances for Version | FIPR_XVERSUSED | CHAR | 1 | 0 | |||||||||||||||
VALID_FROM | Valid from | FIPR_VALID_FROM | DATS | 8 | 0 | |||||||||||||||
VALID_TO | Valid to | FIPR_VALID_TO | DATS | 8 | 0 | |||||||||||||||
CRUSER | User who created the object | FIPR_CRUSER | CHAR | 12 | 0 | |||||||||||||||
CRDATE | Date on which the object was created | FIPR_CRDATE | DATS | 8 | 0 | |||||||||||||||
CRTIME | Time at which the object was created | FIPR_CRTIME | TIMS | 6 | 0 | |||||||||||||||
CHUSER | Last user to change object | FIPR_CHUSER | CHAR | 12 | 0 | |||||||||||||||
CHDATE | Date on which the object was last changed | FIPR_CHDATE | DATS | 8 | 0 | |||||||||||||||
CHTIME | Time at Which the Object Was Last Changed | FIPR_CHTIME | TIMS | 6 | 0 | |||||||||||||||
RLUSER | User who released object | FIPR_RLUSER | CHAR | 12 | 0 | |||||||||||||||
RLDATE | Date on Which Object Was Released | FIPR_RLDATE | DATS | 8 | 0 | |||||||||||||||
RLTIME | Time at Which Object Was Released | FIPR_RLTIME | TIMS | 6 | 0 |
FIPR_PRODV foreign key relationships
Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
---|---|---|---|---|---|---|
FIPR_PRODV | MANDT | FIPR_PRODV | MANDT | T000 | Clients | MANDT |
FIPR_PRODV | PRODINT | FIPR_PRODV | MANDT | FIPR_PRODUCT | Product, Master Data | MANDT |
FIPR_PRODV | PRODINT | FIPR_PRODV | PRODINT | FIPR_PRODUCT | Product, Master Data | PRODINT |