| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | T000 | MANDT | Allow NULL? |
| 2 | PRODINT | Internal Product ID | nvarchar | 18 | 0 | CHAR | (N' ') | No | FIPR_PRODUCT | FIPR_PRODINT | Allow NULL? |
| 3 | VERSION | Version of a Product | nvarchar | 3 | 0 | NUMC | (N'000') | No | | FIPR_VERSION | Allow NULL? |
| 4 | XACTIVE | ID Version is Active (Can Have Instances) | char | 1 | 0 | CHAR | (N' ') | No | | FIPR_XACTIVE | Allow NULL? |
| 5 | STATUS | Status of a Version | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | FIPR_STATUSVERS | Allow NULL? |
| 6 | XISUSED | Indicator: There Are Instances for Version | char | 1 | 0 | CHAR | (N' ') | Yes | | FIPR_XVERSUSED | Allow NULL? |
| 7 | VALID_FROM | Valid from | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | FIPR_VALID_FROM | Allow NULL? |
| 8 | VALID_TO | Valid to | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | FIPR_VALID_TO | Allow NULL? |
| 9 | CRUSER | User who created the object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | FIPR_CRUSER | Allow NULL? |
| 10 | CRDATE | Date on which the object was created | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | FIPR_CRDATE | Allow NULL? |
| 11 | CRTIME | Time at which the object was created | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | FIPR_CRTIME | Allow NULL? |
| 12 | CHUSER | Last user to change object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | FIPR_CHUSER | Allow NULL? |
| 13 | CHDATE | Date on which the object was last changed | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | FIPR_CHDATE | Allow NULL? |
| 14 | CHTIME | Time at Which the Object Was Last Changed | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | FIPR_CHTIME | Allow NULL? |
| 15 | RLUSER | User who released object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | FIPR_RLUSER | Allow NULL? |
| 16 | RLDATE | Date on Which Object Was Released | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | FIPR_RLDATE | Allow NULL? |
| 17 | RLTIME | Time at Which Object Was Released | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | FIPR_RLTIME | Allow NULL? |
