| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | /B631/S_WBSELMT | Work Breakdown Structure Element (WBS Element) | nvarchar | 24 | 0 | CHAR | (N' ') | No | * | /B631/OIWBSELMT | Allow NULL? |
| 2 | OBJVERS | Object version | char | 1 | 0 | CHAR | (N' ') | No | | RSOBJVERS | Allow NULL? |
| 3 | CHANGED | Change flag ( I inserted / D deleted ) | char | 1 | 0 | CHAR | (N' ') | No | | RSRCHANGEFLAG | Allow NULL? |
| 4 | /B631/S_BUSAREA | Business Area | nvarchar | 4 | 0 | CHAR | (N' ') | No | * | /B631/OIBUSAREA | Allow NULL? |
| 5 | /B631/S_CH_ON | Last changed on | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | /B631/OICH_ON | Allow NULL? |
| 6 | /B631/S_COMPCODE | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | No | * | /B631/OICOMPCODE | Allow NULL? |
| 7 | /B631/S_CO_AREA | Controlling Area | nvarchar | 4 | 0 | CHAR | (N' ') | No | * | /B631/OICO_AREA | Allow NULL? |
| 8 | /B631/S_COSTCNTR | Cost Center | nvarchar | 10 | 0 | CHAR | (N' ') | No | * | /B631/OICOSTCNTR | Allow NULL? |
| 9 | /B631/S_CREATEON | Date on which the record was created | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | /B631/OICREATEON | Allow NULL? |
| 10 | /B631/S_INVREAS | Reason for Investment | nvarchar | 2 | 0 | CHAR | (N' ') | No | * | /B631/OIINVREAS | Allow NULL? |
| 11 | /B631/S_OBJCURR | Object currency for CO object | nvarchar | 5 | 0 | CUKY | (N' ') | No | * | /B631/OIOBJCURR | Allow NULL? |
| 12 | /B631/S_PLANT | Plant | nvarchar | 4 | 0 | CHAR | (N' ') | No | * | /B631/OIPLANT | Allow NULL? |
| 13 | /B631/S_PROFTCTR | Profit Center | nvarchar | 10 | 0 | CHAR | (N' ') | No | * | /B631/OIPROFTCTR | Allow NULL? |
| 14 | /B631/S_PROJECT | Project Definition | nvarchar | 24 | 0 | CHAR | (N' ') | No | * | /B631/OIPROJECT | Allow NULL? |
| 15 | /B631/S_PSAPPLNO | Applicant | nvarchar | 8 | 0 | NUMC | (N'00000000') | No | * | /B631/OIPSAPPLNO | Allow NULL? |
| 16 | /B631/S_PS_LEVEL | Level in Project Hierarchy | nvarchar | 3 | 0 | NUMC | (N'000') | No | * | /B631/OIPS_LEVEL | Allow NULL? |
| 17 | /B631/S_PRJTYPE | Project Type | nvarchar | 2 | 0 | CHAR | (N' ') | No | * | /B631/OIPRJTYPE | Allow NULL? |
| 18 | /B631/S_RESPNO | Person responsible | nvarchar | 8 | 0 | NUMC | (N'00000000') | No | * | /B631/OIRESPNO | Allow NULL? |
| 19 | /B631/S_PS_XSTAT | Statistical WBS element | char | 1 | 0 | CHAR | (N' ') | No | * | /B631/OIPS_XSTAT | Allow NULL? |
| 20 | /B631/S_REQUCCTR | Requesting Cost Center | nvarchar | 10 | 0 | CHAR | (N' ') | No | * | /B631/OIREQUCCTR | Allow NULL? |
| 21 | /B631/S_RESPCCTR | Responsible Cost Center | nvarchar | 10 | 0 | CHAR | (N' ') | No | * | /B631/OIRESPCCTR | Allow NULL? |
| 22 | /B631/S_SCOPE | Object Class | nvarchar | 2 | 0 | CHAR | (N' ') | No | * | /B631/OISCOPE | Allow NULL? |
| 23 | /B631/S_STATSYS0 | System Status | nvarchar | 2 | 0 | NUMC | (N'00') | No | * | /B631/OISTATSYS0 | Allow NULL? |
| 24 | /B631/S_FIELDKEY | Keyword Id for User Defined Fields | nvarchar | 7 | 0 | CHAR | (N' ') | No | * | /B631/OIFIELDKEY | Allow NULL? |
| 25 | /B631/S_PS_USR12 | User Field 12 as Indicator | char | 1 | 0 | CHAR | (N' ') | No | * | /B631/OIPS_USR12 | Allow NULL? |
| 26 | /B631/S_PS_USR11 | User Field 11 as Indicator | char | 1 | 0 | CHAR | (N' ') | No | * | /B631/OIPS_USR11 | Allow NULL? |
| 27 | /B631/S_PS_USR10 | User Field 10 for Date | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | /B631/OIPS_USR10 | Allow NULL? |
| 28 | /B631/S_PS_USR9 | User Field 9 for Date | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | /B631/OIPS_USR9 | Allow NULL? |
| 29 | /B631/S_PS_USR8C | User Field 8 Currency for Value | nvarchar | 5 | 0 | CUKY | (N' ') | No | * | /B631/OIPS_USR8C | Allow NULL? |
| 30 | /B631/S_PS_USR8 | User Field 8 Amount | decimal | 17 | 2 | CURR | ((0)) | No | | /B631/OIPS_USR8 | |
| 31 | /B631/S_PS_USR7C | User Field 7 Currency for Value | nvarchar | 5 | 0 | CUKY | (N' ') | No | * | /B631/OIPS_USR7C | Allow NULL? |
| 32 | /B631/S_PS_USR7 | User Field 7 for Value | decimal | 17 | 2 | CURR | ((0)) | No | | /B631/OIPS_USR7 | |
| 33 | /B631/S_PS_USR6U | User Field 6 Unit for Quantity | nvarchar | 3 | 0 | UNIT | (N' ') | No | | /B631/OIPS_USR6U | Allow NULL? |
| 34 | /B631/S_PS_USR6 | User Field 6 for Quantity | decimal | 17 | 3 | QUAN | ((0)) | No | | /B631/OIPS_USR6 | |
| 35 | /B631/S_PS_USR5U | User Field 5 Unit for Quantity | nvarchar | 3 | 0 | UNIT | (N' ') | No | | /B631/OIPS_USR5U | Allow NULL? |
| 36 | /B631/S_PS_USR5 | User field 5 for Quantity | decimal | 17 | 3 | QUAN | ((0)) | No | | /B631/OIPS_USR5 | |
| 37 | /B631/S_PS_USR4 | User Field 4 for 10 Characters | nvarchar | 10 | 0 | CHAR | (N' ') | No | * | /B631/OIPS_USR4 | Allow NULL? |
| 38 | /B631/S_PS_USR3 | User Field 3 for 10 Characters | nvarchar | 10 | 0 | CHAR | (N' ') | No | * | /B631/OIPS_USR3 | Allow NULL? |
| 39 | /B631/S_PS_USR2 | User Field 2 for 20 Characters | nvarchar | 20 | 0 | CHAR | (N' ') | No | * | /B631/OIPS_USR2 | Allow NULL? |
| 40 | /B631/S_PS_USR1 | User Field 1 for 20 Characters | nvarchar | 20 | 0 | CHAR | (N' ') | No | * | /B631/OIPS_USR1 | Allow NULL? |
