| 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 | * | MANDT | Allow NULL? |
| 2 | REF_MODULE | Number of the Reference Module | nvarchar | 40 | 0 | CHAR | (N' ') | No | | WRF_REF_MODULE_NUMBER | Allow NULL? |
| 3 | DESCRIPTION | Description of the Reference Module | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | WRF_REF_MODULE_DESC | Allow NULL? |
| 4 | VALID_DATE | Valid-to Date of a Reference Module | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | WRF_REF_MODULE_VALID_DATE | Allow NULL? |
| 5 | HIST_BASE_FILTER | Filtering of Historical Basis | char | 1 | 0 | CHAR | (N' ') | Yes | | WRF_REF_HIST_BASE_FILTER | Allow NULL? |
| 6 | EXCLUSION_RANGE | Exclusion Period | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | WRF_REF_EXCLUSION_RANGE | Allow NULL? |
| 7 | NEW_COMP_RANGE | Recalculation Period | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | WRF_REF_NEW_COMPUTE_RANGE | Allow NULL? |
| 8 | INACTIVITY_RANGE | Time Period for Listing Check for References | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | WRF_REF_INACTIVITY_RANGE | Allow NULL? |
| 9 | REUSABLE | Indicator: Module Can Be Assigned Automatically | char | 1 | 0 | CHAR | (N' ') | Yes | | WRF_REF_MODULE_REUSABLE | Allow NULL? |
| 10 | WERKS | Plant | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | WERKS_D | Allow NULL? |
| 11 | REF_FIND_TYPE | Reference Determination Type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | WRF_REF_FIND_TYPE | Allow NULL? |
| 12 | GROUPING_ID | Identifier for Material Grouping in the reference module | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | WRF_REF_GROUPING_ID | Allow NULL? |
| 13 | GROUPING | Material Grouping of the Reference Module | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | WRF_REF_GROUP | Allow NULL? |
| 14 | LANGU | Language Key | char | 1 | 0 | LANG | (N' ') | Yes | * | LANGU | Allow NULL? |
| 15 | NEWTS | Flag: new construction of history necessary because of chang | char | 1 | 0 | CHAR | (N' ') | Yes | | WRF_REF_NEWTS | Allow NULL? |
| 16 | DESC_MOD | Indicator: Description of module modified | char | 1 | 0 | CHAR | (N' ') | Yes | | WRF_REF_DESC_MOD | Allow NULL? |
| 17 | FIRST_TRANSFER | Flag: new module (will be transferred for first time) | char | 1 | 0 | CHAR | (N' ') | Yes | | WRF_REF_FIRST_TRANSFER | Allow NULL? |
| 18 | MANUAL | Maintained Manually Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | WRF_REF_MODULE_MANUAL | Allow NULL? |
| 19 | CHECK_RELEVANCE | Check Relevance of references for F&R | char | 1 | 0 | CHAR | (N' ') | Yes | | WRF_REF_CHECK_RELEVANCE | Allow NULL? |
| 20 | CREATEUSER | Name of the User Who Created the object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | WRF_REF_CREATE_USER | Allow NULL? |
| 21 | CREATEUTC | Creation timestamp | decimal | 15 | 0 | DEC | ((0)) | Yes | | WRF_REF_CRE_TIMESTAMP | |
| 22 | CHANGEUSER | Last Changed by | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | WRF_REF_CHANGE_USER | Allow NULL? |
| 23 | CHANGEUTC | Change timestamp | decimal | 15 | 0 | DEC | ((0)) | Yes | | WRF_REF_CHA_TIMESTAMP | |
