| 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 | T000 | MANDT | Allow NULL? |
| 2 | VSNMR | Number or description of a version | nvarchar | 12 | 0 | CHAR | (N' ') | No | | VSNMR | Allow NULL? |
| 3 | PSPNR | WBS Element | nvarchar | 8 | 0 | NUMC | (N'00000000') | No | * | PS_POSNR | Allow NULL? |
| 4 | POSID | Work Breakdown Structure Element (WBS Element) | nvarchar | 24 | 0 | CHAR | (N' ') | No | | PS_POSID | Allow NULL? |
| 5 | POST1 | PS: Short description (1st text line) | nvarchar | 40 | 0 | CHAR | (N' ') | No | | PS_POST1 | Allow NULL? |
| 6 | OBJNR | Object number | nvarchar | 22 | 0 | CHAR | (N' ') | No | ONR00 | J_OBJNR | Allow NULL? |
| 7 | PSPHI | Current number of the appropriate project | nvarchar | 8 | 0 | NUMC | (N'00000000') | No | VSPROJ_CN | PS_PSPHI | Allow NULL? |
| 8 | POSKI | WBS element short identification | nvarchar | 16 | 0 | CHAR | (N' ') | No | | PS_POSKI | Allow NULL? |
| 9 | ERNAM | Name of Person who Created the Object | nvarchar | 12 | 0 | CHAR | (N' ') | No | | ERNAM | Allow NULL? |
| 10 | ERDAT | Date on Which Record Was Created | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | ERDAT | Allow NULL? |
| 11 | AENAM | Name of Person Who Changed Object | nvarchar | 12 | 0 | CHAR | (N' ') | No | | AENAM | Allow NULL? |
| 12 | AEDAT | Date on which object was last changed | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | UPDAT | Allow NULL? |
| 13 | VERNR | Number of the responsible person (project manager) | nvarchar | 8 | 0 | NUMC | (N'00000000') | No | TCJ04 | PS_VERNR | Allow NULL? |
| 14 | VERNA | Name of responsible person (Project manager) | nvarchar | 25 | 0 | CHAR | (N' ') | No | | PS_VERNA | Allow NULL? |
| 15 | ASTNR | Applicant number | nvarchar | 8 | 0 | NUMC | (N'00000000') | No | TCJ05 | PS_ASTNR | Allow NULL? |
| 16 | ASTNA | Applicant | nvarchar | 25 | 0 | CHAR | (N' ') | No | | PS_ASTNA | Allow NULL? |
| 17 | PBUKR | Company code for WBS element | nvarchar | 4 | 0 | CHAR | (N' ') | No | T001 | PS_PBUKR | Allow NULL? |
| 18 | PGSBR | Business area for WBS element | nvarchar | 4 | 0 | CHAR | (N' ') | No | TGSB | PS_PGSBR | Allow NULL? |
| 19 | PKOKR | Controlling area for WBS element | nvarchar | 4 | 0 | CHAR | (N' ') | No | TKA01 | PS_PKOKR | Allow NULL? |
| 20 | PRCTR | Profit Center | nvarchar | 10 | 0 | CHAR | (N' ') | No | CEPC | PRCTR | Allow NULL? |
| 21 | PRART | Project type | nvarchar | 2 | 0 | CHAR | (N' ') | No | TCJ1 | PS_PRART | Allow NULL? |
| 22 | STUFE | Level in Project Hierarchy | tinyint | 3 | 0 | INT1 | ((0)) | No | | PS_STUFE | |
| 23 | PLAKZ | Indicator: Planning element | char | 1 | 0 | CHAR | (N' ') | No | | PS_PLAKZ | Allow NULL? |
| 24 | BELKZ | Indicator: Account assignment element | char | 1 | 0 | CHAR | (N' ') | No | | PS_BELKZ | Allow NULL? |
| 25 | FAKKZ | Indicator: Billing element | char | 1 | 0 | CHAR | (N' ') | No | | PS_FAKKZ | Allow NULL? |
| 26 | NPFAZ | Relationship of network activity to production order | char | 1 | 0 | CHAR | (N' ') | No | | PS_NPFAR | Allow NULL? |
| 27 | ZUORD | Network assignment | char | 1 | 0 | NUMC | (N'0') | No | | PS_ZUORD | Allow NULL? |
| 28 | TRMEQ | Indicator: WBS dates detailed by activity dates | char | 1 | 0 | CHAR | (N' ') | No | | PS_TRMEQ | Allow NULL? |
| 29 | KVEWE | Usage of the condition table | char | 1 | 0 | CHAR | (N' ') | No | T681V | KVEWE | Allow NULL? |
| 30 | KAPPL | Application | nvarchar | 2 | 0 | CHAR | (N' ') | No | T681A | KAPPL | Allow NULL? |
| 31 | KALSM | Costing Sheet | nvarchar | 6 | 0 | CHAR | (N' ') | No | T683 | AUFKALSM | Allow NULL? |
| 32 | ZSCHL | Overhead key | nvarchar | 6 | 0 | CHAR | (N' ') | No | | AUFZSCHL | Allow NULL? |
| 33 | ABGSL | Results Analysis Key | nvarchar | 6 | 0 | CHAR | (N' ') | No | TKKAA | ABGR_SCHL | Allow NULL? |
| 34 | AKOKR | Controlling area of requesting cost center | nvarchar | 4 | 0 | CHAR | (N' ') | No | TKA01 | PS_AKOKR | Allow NULL? |
| 35 | AKSTL | Requesting cost center | nvarchar | 10 | 0 | CHAR | (N' ') | No | CSKS | PS_AKSTL | Allow NULL? |
| 36 | FKOKR | Controlling area of responsible cost center | nvarchar | 4 | 0 | CHAR | (N' ') | No | TKA01 | PS_FKOKR | Allow NULL? |
| 37 | FKSTL | Responsible cost center | nvarchar | 10 | 0 | CHAR | (N' ') | No | CSKS | PS_FKSTL | Allow NULL? |
| 38 | FABKL | Factory calendar key | nvarchar | 2 | 0 | CHAR | (N' ') | No | TFACD | FABKL | Allow NULL? |
| 39 | PSPRI | Priority | char | 1 | 0 | CHAR | (N' ') | No | TCN07 | NW_PRIO | Allow NULL? |
| 40 | EQUNR | Equipment Number | nvarchar | 18 | 0 | CHAR | (N' ') | No | EQUI | EQUNR | Allow NULL? |
| 41 | TPLNR | Functional Location | nvarchar | 30 | 0 | CHAR | (N' ') | No | IFLOT | TPLNR | Allow NULL? |
| 42 | PWPOS | WBS element currency | nvarchar | 5 | 0 | CUKY | (N' ') | No | TCURC | PS_PWPOS | Allow NULL? |
| 43 | WERKS | Plant | nvarchar | 4 | 0 | CHAR | (N' ') | No | T001W | WERKS_D | Allow NULL? |
| 44 | TXTSP | Language Key | char | 1 | 0 | LANG | (N' ') | No | T002 | SPRAS | Allow NULL? |
| 45 | SLWID | Key word ID for user-defined fields | nvarchar | 7 | 0 | CHAR | (N' ') | No | TCN00 | SLWID | Allow NULL? |
| 46 | USR00 | 1st user field for 20 characters - WBS element- | nvarchar | 20 | 0 | CHAR | (N' ') | No | | USR00PRPS | Allow NULL? |
| 47 | USR01 | 2nd user field 20 digits - WBS element | nvarchar | 20 | 0 | CHAR | (N' ') | No | | USR01PRPS | Allow NULL? |
| 48 | USR02 | 3rd user-defined field 10 digits -WBS element | nvarchar | 10 | 0 | CHAR | (N' ') | No | | USR02PRPS | Allow NULL? |
| 49 | USR03 | 4th user-defined field 10 digits -WBS element | nvarchar | 10 | 0 | CHAR | (N' ') | No | | USR03PRPS | Allow NULL? |
| 50 | USR04 | 1st user-defined field for quantity(length 10,3) WBS element | decimal | 13 | 3 | QUAN | ((0)) | No | | USR04PRPS | |
| 51 | USE04 | 1st user defined field for quantity field unit - WBS element | nvarchar | 3 | 0 | UNIT | (N' ') | No | T006 | USE04PRPS | Allow NULL? |
| 52 | USR05 | 2nd use field for quantity (length 10,3) WBS element | decimal | 13 | 3 | QUAN | ((0)) | No | | USR05PRPS | |
| 53 | USE05 | 2nd user defined field for quantity field unit - WBS element | nvarchar | 3 | 0 | UNIT | (N' ') | No | T006 | USE05PRPS | Allow NULL? |
| 54 | USR06 | 1st user field for values (length 10,3) WBS element | decimal | 13 | 3 | CURR | ((0)) | No | | USR06PRPS | |
| 55 | USE06 | 1st user defined field for value field unit - WBS element | nvarchar | 5 | 0 | CUKY | (N' ') | No | TCURC | USE06PRPS | Allow NULL? |
| 56 | USR07 | 2nd user field for values (length 10,3) -WBS element | decimal | 13 | 3 | CURR | ((0)) | No | | USR07PRPS | |
| 57 | USE07 | 2nd user defined field for value field unit - WBS element | nvarchar | 5 | 0 | CUKY | (N' ') | No | TCURC | USE07PRPS | Allow NULL? |
| 58 | USR08 | 1st user field for date -WBS element | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | USR08PRPS | Allow NULL? |
| 59 | USR09 | 2nd user field for date -WBS element | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | USR09PRPS | Allow NULL? |
| 60 | USR10 | 1st user field for 'Ind. for evaluations' WBS elem. | char | 1 | 0 | CHAR | (N' ') | No | | USR10PRPS | Allow NULL? |
| 61 | USR11 | 2nd user field for 'Indicator for eval.s' WBS elemnt | char | 1 | 0 | CHAR | (N' ') | No | | USR11PRPS | Allow NULL? |
| 62 | KOSTL | Cost center to which costs are actually posted | nvarchar | 10 | 0 | CHAR | (N' ') | No | CSKS | PS_KOSTL | Allow NULL? |
| 63 | KTRG | Cost Object | nvarchar | 12 | 0 | CHAR | (N' ') | No | CKPH | KSTRG | Allow NULL? |
| 64 | BERST | Authorization key for project master data | nvarchar | 16 | 0 | CHAR | (N' ') | No | | PS_BERST | Allow NULL? |
| 65 | BERTR | Authorization key for project dates (WBS) | nvarchar | 16 | 0 | CHAR | (N' ') | No | | PS_BERTR | Allow NULL? |
| 66 | BERKO | Authorization key for costs and revenues | nvarchar | 16 | 0 | CHAR | (N' ') | No | | PS_BERKO | Allow NULL? |
| 67 | BERBU | Authorization key for project budget | nvarchar | 16 | 0 | CHAR | (N' ') | No | | PS_BERBU | Allow NULL? |
| 68 | CLASF | Indicator: WBS element used in project summarization | char | 1 | 0 | CHAR | (N' ') | No | | PS_CLASF | Allow NULL? |
| 69 | SPSNR | Std WBS: Internal project item number (w/exit on ID) | nvarchar | 8 | 0 | NUMC | (N'00000000') | No | PRPSS | PS_SPSNR | Allow NULL? |
| 70 | SCOPE | Object Class | nvarchar | 2 | 0 | CHAR | (N' ') | No | | SCOPE_CV | Allow NULL? |
| 71 | XSTAT | Statistical WBS element | char | 1 | 0 | CHAR | (N' ') | No | | PS_XSTAT | Allow NULL? |
| 72 | TXJCD | Tax Jurisdiction | nvarchar | 15 | 0 | CHAR | (N' ') | No | TTXJ | TXJCD | Allow NULL? |
| 73 | ZSCHM | Interest Profile for Project/Order Interest Calculation | nvarchar | 7 | 0 | CHAR | (N' ') | No | TPI01 | PS_ZSCHM | Allow NULL? |
| 74 | IMPRF | Investment measure profile | nvarchar | 6 | 0 | CHAR | (N' ') | No | TAPRF | IM_PROFIL | Allow NULL? |
| 75 | EVGEW | Aggregation weight for POC (PS progress) | decimal | 8 | 0 | DEC | ((0)) | No | | EV_WEIGHTD | |
| 76 | AENNR | Change Number | nvarchar | 12 | 0 | CHAR | (N' ') | No | AENR | AENNR | Allow NULL? |
| 77 | SUBPR | Sub-project in work breakdown structure | nvarchar | 12 | 0 | CHAR | (N' ') | No | PRTP | PS_SUBPR | Allow NULL? |
| 78 | POSTU | PS: Short description (1st text line) in all caps | nvarchar | 40 | 0 | CHAR | (N' ') | No | | PS_POSTU | Allow NULL? |
| 79 | PLINT | Indicator for Integrated Planning | char | 1 | 0 | CHAR | (N' ') | No | | PLINT | Allow NULL? |
| 80 | LOEVM | Deletion Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | LOEVM | Allow NULL? |
| 81 | KZBWS | Valuation of Special Stock | char | 1 | 0 | CHAR | (N' ') | Yes | | KZBWS | Allow NULL? |
| 82 | FPLNR | Billing plan number / invoicing plan number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | FPLNR | Allow NULL? |
| 83 | TADAT | Technically complete date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | TABGDAT | Allow NULL? |
| 84 | IZWEK | Reason for investment | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T087I | IZWEK | Allow NULL? |
| 85 | ISIZE | Scale of investment objects | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TAIF5 | IM_SIZECL | Allow NULL? |
| 86 | IUMKZ | Reason for environmental investment | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | T087K | AM_UMWKZ | Allow NULL? |
| 87 | ABUKR | Requesting company code | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T001 | IM_ABUKRS | Allow NULL? |
| 88 | GRPKZ | Indicator: Grouping WBS element | char | 1 | 0 | CHAR | (N' ') | Yes | | GRPSPKZ | Allow NULL? |
| 89 | PGPRF | Distribution profile | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | TPGPRF | PGPROFID | Allow NULL? |
| 90 | LOGSYSTEM | Logical System | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | LOGSYSTEM | Allow NULL? |
| 91 | PSPNR_LOGS | Numeric field length 8 | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | | NUM08 | Allow NULL? |
| 92 | STORT | Location | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | T499S | PS_STORT | Allow NULL? |
| 93 | FUNC_AREA | Functional Area | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | TFKB | FKBER | Allow NULL? |
| 94 | KLVAR | Costing Variant | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | CK_KLVAR | Allow NULL? |
| 95 | KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | nvarchar | 12 | 0 | NUMC | (N'000000000000') | Yes | * | CK_KALNR | Allow NULL? |
| 96 | POSID_EDIT | Work Breakdown Structure Element (WBS Element) Edited | nvarchar | 24 | 0 | CHAR | (N' ') | Yes | | PS_POSID_EDIT | Allow NULL? |
| 97 | PSPKZ | Indicator: WBS element for production lot | char | 1 | 0 | CHAR | (N' ') | Yes | | PL_PSPKZ | Allow NULL? |
| 98 | MATNR | Material Number | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | * | MATNR | Allow NULL? |
| 99 | VLPSP | WBS: Reference work breakdown structure element | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | * | PL_PSP_PNR | Allow NULL? |
| 100 | VLPKZ | Indicator: Reference WBS element for production lot | char | 1 | 0 | CHAR | (N' ') | Yes | | PL_VLPKZ | Allow NULL? |
| 101 | SORT1 | Sort string 1 for production lot | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | PL_SORT1 | Allow NULL? |
| 102 | SORT2 | Sort string 2 for production lot | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | PL_SORT2 | Allow NULL? |
| 103 | SORT3 | Sort string 3 for production lot | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | PL_SORT3 | Allow NULL? |
| 104 | VNAME | Joint Venture | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | T8JV | JV_NAME | Allow NULL? |
| 105 | RECID | Recovery Indicator | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T8JJ | JV_RECIND | Allow NULL? |
| 106 | ETYPE | Equity type | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T8JE | JV_ETYPE | Allow NULL? |
| 107 | OTYPE | Joint Venture Object Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | JV_OTYPE | Allow NULL? |
| 108 | JIBCL | JIB/JIBE Class | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T8J6A | JV_JIBCL | Allow NULL? |
| 109 | JIBSA | JIB/JIBE Subclass A | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | T8J6C | JV_JIBSA | Allow NULL? |
| 110 | CGPL_GUID16 | Generic project planning: GUID from external R/3 system | varbinary | 16 | 0 | RAW | | Yes | | CGPL_GUID16_R3 | |
| 111 | CGPL_LOGSYS | Generic project planning: Log. system for CGPL_GUID16_R3 | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | CGPL_LOGSYS | Allow NULL? |
| 112 | CGPL_OBJTYPE | Generic project planning: object type from ext. R/3 system | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | CGPL_OBJECT_TYPE_R3 | Allow NULL? |
| 113 | ADPSP | Reference Element PM/PS | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | * | ADDCOMPARE_CORE | Allow NULL? |
| 114 | RFIPPNT | Reference Point for Relationship Between iPPE and PS | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | TCNRPIP | CN_RPIP | Allow NULL? |
| 115 | ZZPS01 | Industry | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | ZZZ_PS01 | ZZPS01 | Allow NULL? |
| 116 | ZZPS02 | Type of Work | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | ZZZ_PS02 | ZZPS02 | Allow NULL? |
| 117 | ZZPS03 | Overall Project Risk | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | ZZZ_PS03 | ZZPS03 | Allow NULL? |
| 118 | ZZPS04 | Financial Risk | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | ZZZ_PS04 | ZZPS04 | Allow NULL? |
| 119 | ZZPS05 | Technical Risk | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | ZZZ_PS05 | ZZPS05 | Allow NULL? |
| 120 | ORGKEY | Project definition (internal) | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | * | PS_INTNR | Allow NULL? |
| 121 | INCAT | Version inactive indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | VSINACT | Allow NULL? |
| 122 | PRPS_STATUS | Status Combination | tinyint | 3 | 0 | INT1 | ((0)) | Yes | ACTCMB_TAB | ACTCMB_DELE | |
| 123 | FERC_IND | Regulatory indicator | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | FERC_C7 | FE_IND | Allow NULL? |
