SAP ABAP Table JPVWBS_BW_B (Generated Table for View)
Basic Data
Table Category | VIEW | General view structure |
General view structure | JPVWBS_BW_B | Table Relationship Diagram |
Short Description | Generated Table for View |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
2 | PSPNR_PS | PS_INTNR | PS_PSPNR | NUMC | 8 | 0 | Current number for project or project item | ||
3 | PSPID | PS_PSPID | PS_PSPID | CHAR | 24 | 0 | Project definition | ||
4 | VBUKR | PS_VBUKR | BUKRS | CHAR | 4 | 0 | Company code for the project | T001 | |
5 | VGSBR | PS_VGSBR | GSBER | CHAR | 4 | 0 | Business area for the project | TGSB | |
6 | VKOKR | PS_VKOKR | CACCD | CHAR | 4 | 0 | Controlling area for the project | TKA01 | |
7 | PRCTR_PS | PRCTR | PRCTR | CHAR | 10 | 0 | Profit Center | CEPC | |
8 | PLFAZ | PS_PLFAZ | DATUM | DATS | 8 | 0 | Project planned start date | ||
9 | PLSEZ | PS_PLSEZ | DATUM | DATS | 8 | 0 | Project planned finish date | ||
10 | WERKS_PS | WERKS_D | WERKS | CHAR | 4 | 0 | Plant | T001W | |
11 | VKORG | VKORG | VKORG | CHAR | 4 | 0 | Sales Organization | TVKO | |
12 | VTWEG | VTWEG | VTWEG | CHAR | 2 | 0 | Distribution Channel | TVKOV | |
13 | SPART | SPART | SPART | CHAR | 2 | 0 | Division | TVTA | |
14 | OBJNR | J_OBJNR | J_OBJNR | CHAR | 22 | 0 | Object number | ONR00 | |
15 | USR00 | USR00PRPS | USRCHAR20 | CHAR | 20 | 0 | 1st user field for 20 characters - WBS element- | ||
16 | USR01 | USR01PRPS | USRCHAR20 | CHAR | 20 | 0 | 2nd user field 20 digits - WBS element | ||
17 | USR02 | USR02PRPS | USRCHAR10 | CHAR | 10 | 0 | 3rd user-defined field 10 digits -WBS element | ||
18 | USR03 | USR03PRPS | USRCHAR10 | CHAR | 10 | 0 | 4th user-defined field 10 digits -WBS element | ||
19 | USR04 | USR04PRPS | USRQUAN13 | QUAN | 13 | 3 | 1st user-defined field for quantity(length 10,3) WBS element | ||
20 | USE04 | USE04PRPS | MEINS | UNIT | 3 | 0 | 1st user defined field for quantity field unit - WBS element | T006 | |
21 | USR05 | USR05PRPS | USRQUAN13 | QUAN | 13 | 3 | 2nd use field for quantity (length 10,3) WBS element | ||
22 | USE05 | USE05PRPS | MEINS | UNIT | 3 | 0 | 2nd user defined field for quantity field unit - WBS element | T006 | |
23 | USR06 | USR06PRPS | USRCURR13 | CURR | 13 | 3 | 1st user field for values (length 10,3) WBS element | ||
24 | USE06 | USE06PRPS | WAERS | CUKY | 5 | 0 | 1st user defined field for value field unit - WBS element | TCURC | |
25 | USR07 | USR07PRPS | USRCURR13 | CURR | 13 | 3 | 2nd user field for values (length 10,3) -WBS element | ||
26 | USE07 | USE07PRPS | WAERS | CUKY | 5 | 0 | 2nd user defined field for value field unit - WBS element | TCURC | |
27 | USR08 | USR08PRPS | USRDATE | DATS | 8 | 0 | 1st user field for date -WBS element | ||
28 | USR09 | USR09PRPS | USRDATE | DATS | 8 | 0 | 2nd user field for date -WBS element | ||
29 | USR10 | USR10PRPS | FLAG | CHAR | 1 | 0 | 1st user field for 'Ind. for evaluations' WBS elem. | ||
30 | USR11 | USR11PRPS | FLAG | CHAR | 1 | 0 | 2nd user field for 'Indicator for eval.s' WBS elemnt | ||
31 | PSPHI | PS_PSPHI | PS_PSPNR | NUMC | 8 | 0 | Current number of the appropriate project | PROJ | |
32 | KALNR | CK_KALNR | CK_KALNR | NUMC | 12 | 0 | Cost Estimate Number for Cost Est. w/o Qty Structure |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | JPVWBS_BW_B | MANDT | T000 | MANDT | KEY | 1 | CN |
2 | JPVWBS_BW_B | OBJNR | ONR00 | OBJNR | REF | C | C |
3 | JPVWBS_BW_B | PRCTR_PS | CEPC | PRCTR | REF | C | CN |
4 | JPVWBS_BW_B | PSPHI | PROJ | PSPNR | REF | 1 | CN |
5 | JPVWBS_BW_B | SPART | TVTA | SPART | |||
6 | JPVWBS_BW_B | USE04 | T006 | MSEHI | REF | C | CN |
7 | JPVWBS_BW_B | USE05 | T006 | MSEHI | REF | C | CN |
8 | JPVWBS_BW_B | USE06 | TCURC | WAERS | REF | C | CN |
9 | JPVWBS_BW_B | USE07 | TCURC | WAERS | REF | C | CN |
10 | JPVWBS_BW_B | VBUKR | T001 | BUKRS | REF | C | CN |
11 | JPVWBS_BW_B | VGSBR | TGSB | GSBER | REF | C | CN |
12 | JPVWBS_BW_B | VKOKR | TKA01 | KOKRS | REF | C | CN |
13 | JPVWBS_BW_B | VKORG | TVKO | VKORG | |||
14 | JPVWBS_BW_B | VTWEG | TVKOV | VTWEG | |||
15 | JPVWBS_BW_B | WERKS_PS | T001W | WERKS | REF | C | CN |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |