| 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 | TDPR_PRODUCT | TB_PR_PRODINT | Allow NULL? |
| 3 | VERSION | Product Version | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | TB_PR_VERSION | Allow NULL? |
| 4 | XACTIVE | Indicator: Version Is Active (Can Have Characteristic Vals) | char | 1 | 0 | CHAR | (N' ') | No | | TB_PR_XACTIVE | Allow NULL? |
| 5 | STATUSVERS | Status of Product Version | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | TB_PR_STATUSVERS | Allow NULL? |
| 6 | XVERSUSED | Indicator: Version Is in Use | char | 1 | 0 | CHAR | (N' ') | Yes | | TB_PR_XVERSUSED | Allow NULL? |
| 7 | VALID_FROM | Effective from | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | TB_PR_VALID_FROM | Allow NULL? |
| 8 | VALID_TO | Effective to | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | TB_PR_VALID_TO | Allow NULL? |
| 9 | CRUSER | User Who Created the Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | TB_PR_CRUSER | Allow NULL? |
| 10 | CRDATE | Date on Which the Object Was Created | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | TB_PR_CRDATE | Allow NULL? |
| 11 | CRTIME | Time at Which the Object Was Created | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | TB_PR_CRTIME | Allow NULL? |
| 12 | CHUSER | Last User to Change the Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | TB_PR_CHUSER | Allow NULL? |
| 13 | CHDATE | Date on Which the Object Was Last Changed | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | TB_PR_CHDATE | Allow NULL? |
| 14 | CHTIME | Time at Which the Object Was Last Changed | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | TB_PR_CHTIME | Allow NULL? |
| 15 | RLUSER | User Who Released Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | TB_PR_RLUSER | Allow NULL? |
| 16 | RLDATE | Date on Which Object Was Released | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | TB_PR_RLDATE | Allow NULL? |
| 17 | RLTIME | Time at Which Object Was Released | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | TB_PR_RLTIME | Allow NULL? |