| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | ATTRNO | Attribute ID | nvarchar | 16 | 0 | CHAR | (N' ') | No | TDPR_ATTRIBUTE | TB_PR_ATTRNO | Allow NULL? |
| 2 | TABNAME | Table/Structure Name | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | DD02L | TB_PR_TABNAME | Allow NULL? |
| 3 | FLDNAME | Field Name | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | DD03L | TB_PR_FLDNAME | Allow NULL? |
| 4 | XFIXED | Indicator for Closed/Open Lock for an Attribute | char | 1 | 0 | CHAR | (N' ') | Yes | | TB_PR_FIXEDATTR | Allow NULL? |
| 5 | XFIXEDCHG | Indicator: Key Can Be Modified | char | 1 | 0 | CHAR | (N' ') | Yes | | TB_PR_XFIXEDCHG | Allow NULL? |
| 6 | XMULT | Indicator: Multiple-Value Field | char | 1 | 0 | CHAR | (N' ') | Yes | | TB_PR_XMULT | Allow NULL? |
| 7 | XDEFAULT | Allow Default Value | char | 1 | 0 | CHAR | (N' ') | Yes | | TB_PR_XDEFAULT | Allow NULL? |
| 8 | XFLDVAL | Indicator: Value Set Can Be Modified | char | 1 | 0 | CHAR | (N' ') | Yes | | TB_PR_XFLDVAL | Allow NULL? |
| 9 | XDEF_ONLY_PROD | Indicator: Fixed Values Only Exist for the Product | char | 1 | 0 | CHAR | (N' ') | Yes | | TB_PR_XDEF_ONLY_PROD | Allow NULL? |
| 10 | FMREQ_ALLOWED | Status as Required Entry Field | char | 1 | 0 | NUMC | (N'0') | Yes | | TB_PR_FMREQ_ALLOWED | Allow NULL? |
| 11 | FMOPT_ALLOWED | Status as Optional Entry Field | char | 1 | 0 | NUMC | (N'0') | Yes | | TB_PR_FMOPT_ALLOWED | Allow NULL? |
| 12 | FMDIS_ALLOWED | Status as Display Field | char | 1 | 0 | NUMC | (N'0') | Yes | | TB_PR_FMDIS_ALLOWED | Allow NULL? |
| 13 | FMSUP_ALLOWED | Status as Hidden field | char | 1 | 0 | NUMC | (N'0') | Yes | | TB_PR_FMSUP_ALLOWED | Allow NULL? |
| 14 | ATTRLIM | Set Limit Values for an Attribute | char | 1 | 0 | CHAR | (N' ') | Yes | | TB_PR_ATTRLIM | Allow NULL? |
| 15 | XINHERIT_TO | Can Pass on | char | 1 | 0 | CHAR | (N' ') | Yes | | TB_PR_XINHERIT_TO | Allow NULL? |
| 16 | INHERIT_FROM | Inherits from | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | TDPR_ATTRIBUTE | TB_PR_INHERIT_FROM | Allow NULL? |
| 17 | DERIVATION_TYPE | Derivation Types | char | 1 | 0 | CHAR | (N' ') | Yes | | TB_PR_DERIVATION_TYPE | Allow NULL? |
| 18 | DERIV_FUNC_GET | Function Module: Read Attribute Derivation | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | TB_PR_FUNCNAME_GET_DERIV | Allow NULL? |
| 19 | DERIV_FUNC_SET | Function Module: Write Attribute Derivation | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | TB_PR_FUNCNAME_SET_DERIV | Allow NULL? |
| 20 | XDELETE | Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | TB_PR_DELETE | Allow NULL? |
| 21 | CHG_DATE | System Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | SYDATUM | Allow NULL? |
| 22 | CHG_TIME | TIME Data Element for SYST | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | SYTIME | Allow NULL? |
| 23 | CHG_SYSID | Name of SAP System | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | SYSYSID | Allow NULL? |
| 24 | CHG_CLIENT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | Yes | * | MANDT | Allow NULL? |
| 25 | CHG_CPROG | Calling Program | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | * | SYCPROG | Allow NULL? |
| 26 | CHG_USER | User Name | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | SYUNAME | Allow NULL? |
