| 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 | PROFROLE | Profile allocation role | nvarchar | 4 | 0 | CHAR | (N' ') | No | | PROFROLE | Allow NULL? |
| 3 | ROLEFREQ | Frequency of allocation per role | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | ROLEFREQ | Allow NULL? |
| 4 | ROLETYPE | Role category for profile allocation | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | E_ROLETYPE | Allow NULL? |
| 5 | REGISTERASS | Role Used for Allocation of Profile to Register | char | 1 | 0 | CHAR | (N' ') | Yes | | E_REGISTERASS | Allow NULL? |
| 6 | INSTLASS | Role Used for Allocation of Profile to Installation | char | 1 | 0 | CHAR | (N' ') | Yes | | E_INSTLASS | Allow NULL? |
| 7 | DISPL_SUPPRESS | Role Not Displayed in Selection List | char | 1 | 0 | CHAR | (N' ') | Yes | | E_DISPL_SUPPRESS | Allow NULL? |
| 8 | UFCALC_SUPRESS | Usage Factor Not Updated Automatically | char | 1 | 0 | CHAR | (N' ') | Yes | | E_UFCALC_SUPRESS | Allow NULL? |
| 9 | UFEXTRP_SUPRESS | No Automatic Update of Forecasted Usage Factor | char | 1 | 0 | CHAR | (N' ') | Yes | | E_UFEXTRP_SUPRESS | Allow NULL? |
| 10 | SYNPROF_ONLY | Only Synthetic Profiles Can Be Allocated | char | 1 | 0 | CHAR | (N' ') | Yes | | E_SYNPROF_ONLY | Allow NULL? |
| 11 | USE_CRM | Role Used in CRM | char | 1 | 0 | CHAR | (N' ') | Yes | | E_ROLECRM | Allow NULL? |
| 12 | BILLCHECK | No Profile Changes in Billed Period | char | 1 | 0 | CHAR | (N' ') | Yes | | E_BILLCHECK | Allow NULL? |
| 13 | UFBILLUP_SUPRESS | No Automatic Update in Bill Period | char | 1 | 0 | CHAR | (N' ') | Yes | | E_UFBILLUP_SUPRESS | Allow NULL? |
| 14 | MDUS_LOCATED | Location of Original Profile Values | char | 1 | 0 | CHAR | (N' ') | Yes | | E_AMI_MDUS_LOCATED_PROFILE | Allow NULL? |