| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | PROFILE | Number of EDM Profile | nvarchar | 18 | 0 | | | | Allow NULL? |
| 3 | SPARTE | Division | nvarchar | 2 | 0 | | | | Allow NULL? |
| 4 | PROFTYPE | Profile type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 5 | PROFVALCAT | Profile value category | nvarchar | 2 | 0 | | | | Allow NULL? |
| 6 | VALUECUM | Cumulative values | char | 1 | 0 | | | | Allow NULL? |
| 7 | INTSIZEID | Interval Length ID | nvarchar | 4 | 0 | | | | Allow NULL? |
| 8 | MASS | Unit of Measurement | nvarchar | 3 | 0 | | | | Allow NULL? |
| 9 | PROFDECIMALS | Number of decimal places in a profile value | nvarchar | 2 | 0 | | | | Allow NULL? |
| 10 | SOURCE | Source of object | nvarchar | 18 | 0 | | | | Allow NULL? |
| 11 | OBJNR | Object number | nvarchar | 22 | 0 | | | | Allow NULL? |
| 12 | PROFOFFSET | Profile value offset | nvarchar | 6 | 0 | | | | Allow NULL? |
| 13 | CONCHECKGRP | Consistency check group | nvarchar | 10 | 0 | | | | Allow NULL? |
| 14 | FORWARD_ORIENTED | Profile values have forward orientation | char | 1 | 0 | | | | Allow NULL? |
| 15 | LASTVERSNO | Consecutive number of version | nvarchar | 6 | 0 | | | | Allow NULL? |
| 16 | DATEFROM | From-Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 17 | TIMEFROM | From-time | nvarchar | 6 | 0 | | | | Allow NULL? |
| 18 | DATETO | To-Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 19 | TIMETO | To-Time | nvarchar | 6 | 0 | | | | Allow NULL? |
| 20 | ERDAT | Date on Which Record Was Created | nvarchar | 8 | 0 | | | | Allow NULL? |
| 21 | ERNAM | Name of Person who Created the Object | nvarchar | 12 | 0 | | | | Allow NULL? |
| 22 | AEDAT | Changed On | nvarchar | 8 | 0 | | | | Allow NULL? |
| 23 | AENAM | Name of Person Who Changed Object | nvarchar | 12 | 0 | | | | Allow NULL? |
| 24 | BEGRU | Authorization Group | nvarchar | 4 | 0 | | | | Allow NULL? |
| 25 | LOEVM | Deletion Indicator | char | 1 | 0 | | | | Allow NULL? |
| 26 | WAERS | Currency Key | nvarchar | 5 | 0 | | | | Allow NULL? |
| 27 | ARCH_DATEFROM | Date, up to Which Profile Values Have Been Archived | nvarchar | 8 | 0 | | | | Allow NULL? |
| 28 | ARCH_TIMEFROM | Time until which, profile values are archived. | nvarchar | 6 | 0 | | | | Allow NULL? |
| 29 | ARCH_DATETO | Date, up to Which Profile Values Have Been Archived | nvarchar | 8 | 0 | | | | Allow NULL? |
| 30 | ARCH_TIMETO | Time until which, profile values are archived. | nvarchar | 6 | 0 | | | | Allow NULL? |
| 31 | REF_PROFILE | Profile Referenced During Settlement | nvarchar | 18 | 0 | | | | Allow NULL? |
| 32 | REPLACEMETHODGRP | Replacement Value Procedure Group | nvarchar | 10 | 0 | | | | Allow NULL? |
| 33 | DAY_OFFSET | Day Offset | nvarchar | 6 | 0 | | | | Allow NULL? |
| 34 | TIME_ZONE | Time Zone for EDM Objects | nvarchar | 6 | 0 | | | | Allow NULL? |
| 35 | SRCPROFILE | Source Profile for Copy Profile | nvarchar | 18 | 0 | | | | Allow NULL? |
| 36 | MDUS_LOCATED | Location of Original Profile Values | char | 1 | 0 | | | | Allow NULL? |
| 37 | TOU_BILLABLE | Profile Can Be Billed with TOU Interface | char | 1 | 0 | | | | Allow NULL? |