SAP ABAP Table V_AVCHANA_PR_JA (Generated Table for View)
Basic Data
Table Category VIEW    General view structure 
General view structure V_AVCHANA_PR_JA   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_POSNR PS_POSNR NUMC 8   0   WBS Element  
3 POSID PS_POSID PS_POSID CHAR 24   0   Work Breakdown Structure Element (WBS Element)  
4 POST1 PS_POST1 TEXT40 CHAR 40   0   PS: Short description (first text line)  
5 OBJNR J_OBJNR J_OBJNR CHAR 22   0   Object number ONR00
6 PSPHI PS_PSPHI PS_PSPNR NUMC 8   0   Current number of the appropriate project PROJ
7 POSKI PS_POSKI PS_PROKI CHAR 16   0   WBS element short identification  
8 ERNAM ERNAM USNAM CHAR 12   0   Name of Person who Created the Object  
9 ERDAT ERDAT DATUM DATS 8   0   Date on which the record was created  
10 AENAM AENAM USNAM CHAR 12   0   Name of Person Who Changed Object  
11 AEDAT UPDAT DATUM DATS 8   0   Date on which object was last changed  
12 VERNR PS_VERNR PS_VERNR NUMC 8   0   Number of the responsible person (project manager) TCJ04
13 VERNA PS_VERNA PS_VERNA CHAR 25   0   Name of responsible person (Project manager)  
14 ASTNR PS_ASTNR PS_ASTNR NUMC 8   0   Applicant number TCJ05
15 ASTNA PS_ASTNA PS_ASTNA CHAR 25   0   Applicant  
16 PBUKR PS_PBUKR BUKRS CHAR 4   0   Company code for WBS element T001
17 PGSBR PS_PGSBR GSBER CHAR 4   0   Business area for WBS element TGSB
18 PKOKR PS_PKOKR CACCD CHAR 4   0   Controlling area for WBS element TKA01
19 PRCTR PRCTR PRCTR CHAR 10   0   Profit Center CEPC
20 PRART PS_PRART PS_PRART CHAR 2   0   Project type TCJ1
21 STUFE PS_STUFE INT1 INT1 3   0   Level in project hierarchy  
22 PLAKZ PS_PLAKZ XFELD CHAR 1   0   Indicator: Planning element  
23 BELKZ PS_BELKZ XFELD CHAR 1   0   Indicator: Account assignment element  
24 FAKKZ PS_FAKKZ XFELD CHAR 1   0   Indicator: Billing element  
25 NPFAZ PS_NPFAR XFELD CHAR 1   0   Relationship of network activity to production order  
26 ZUORD PS_ZUORD PS_ZUORD NUMC 1   0   Network assignment  
27 TRMEQ PS_TRMEQ X CHAR 1   0   Indicator: WBS dates detailed by activity dates  
28 KVEWE KVEWE KVEWE CHAR 1   0   Usage of the Condition Table T681V
29 KAPPL KAPPL KAPPL CHAR 2   0   Application T681A
30 KALSM AUFKALSM KALSM CHAR 6   0   Costing Sheet T683
31 ZSCHL AUFZSCHL CHAR6 CHAR 6   0   Overhead key TKZSL
32 ABGSL ABGR_SCHL ABGR_SCHL CHAR 6   0   Results Analysis Key TKKAA
33 AKOKR PS_AKOKR CACCD CHAR 4   0   Controlling area of requesting cost center TKA01
34 AKSTL PS_AKSTL KOSTL CHAR 10   0   Requesting cost center CSKS
35 FKOKR PS_FKOKR CACCD CHAR 4   0   Controlling area of responsible cost center TKA01
36 FKSTL PS_FKSTL KOSTL CHAR 10   0   Responsible cost center CSKS
37 FABKL FABKL WFCID CHAR 2   0   Factory calendar key TFACD
38 PSPRI NW_PRIO NW_PRIO CHAR 1   0   Priority TCN07
39 EQUNR EQUNR EQUNR CHAR 18   0   Equipment Number EQUI
40 TPLNR TPLNR TPLNR CHAR 30   0   Functional Location IFLOT
41 PWPOS PS_PWPOS WAERS CUKY 5   0   WBS element currency TCURC
42 WERKS WERKS_D WERKS CHAR 4   0   Plant T001W
43 TXTSP SPRAS SPRAS LANG 1   0   Language Key T002
44 SLWID SLWID SLWID CHAR 7   0   Key word ID for user-defined fields TCN00
45 USR00 USR00PRPS USRCHAR20 CHAR 20   0   1st user field for 20 characters - WBS element-  
46 USR01 USR01PRPS USRCHAR20 CHAR 20   0   2nd user field 20 digits - WBS element  
47 USR02 USR02PRPS USRCHAR10 CHAR 10   0   3rd user-defined field 10 digits -WBS element  
48 USR03 USR03PRPS USRCHAR10 CHAR 10   0   4th user-defined field 10 digits -WBS element  
49 USR04 USR04PRPS USRQUAN13 QUAN 13   3   1st user-defined field for quantity(length 10,3) WBS element  
50 USE04 USE04PRPS MEINS UNIT 3   0   1st user defined field for quantity field unit - WBS element T006
51 USR05 USR05PRPS USRQUAN13 QUAN 13   3   2nd use field for quantity (length 10,3) WBS element  
52 USE05 USE05PRPS MEINS UNIT 3   0   2nd user defined field for quantity field unit - WBS element T006
53 USR06 USR06PRPS USRCURR13 CURR 13   3   1st user field for values (length 10,3) WBS element  
54 USE06 USE06PRPS WAERS CUKY 5   0   1st user defined field for value field unit - WBS element TCURC
55 USR07 USR07PRPS USRCURR13 CURR 13   3   2nd user field for values (length 10,3) -WBS element  
56 USE07 USE07PRPS WAERS CUKY 5   0   2nd user defined field for value field unit - WBS element TCURC
57 USR08 USR08PRPS USRDATE DATS 8   0   1st user field for date -WBS element  
58 USR09 USR09PRPS USRDATE DATS 8   0   2nd user field for date -WBS element  
59 USR10 USR10PRPS FLAG CHAR 1   0   1st user field for 'Ind. for evaluations' WBS elem.  
60 USR11 USR11PRPS FLAG CHAR 1   0   2nd user field for 'Indicator for eval.s' WBS elemnt  
61 KOSTL PS_KOSTL KOSTL CHAR 10   0   Cost center to which costs are actually posted CSKS
62 KTRG KSTRG KSTRG CHAR 12   0   Cost Object CKPH
63 BERST PS_BERST CHAR16 CHAR 16   0   Authorization key for project master data  
64 BERTR PS_BERTR CHAR16 CHAR 16   0   Authorization key for project dates (WBS)  
65 BERKO PS_BERKO CHAR16 CHAR 16   0   Authorization key for costs and revenues  
66 BERBU PS_BERBU CHAR16 CHAR 16   0   Authorization key for project budget  
67 CLASF PS_CLASF XFELD CHAR 1   0   Indicator: WBS element used in project summarization  
68 SPSNR PS_SPSNR PS_SPSNR NUMC 8   0   Std WBS: Internal project item number (w/exit on ID) PRPSS
69 SCOPE SCOPE_CV SCOPE_CV CHAR 2   0   Object Class  
70 XSTAT PS_XSTAT XFELD CHAR 1   0   Statistical WBS element  
71 TXJCD TXJCD TXJCD CHAR 15   0   Tax Jurisdiction TTXJ
72 ZSCHM PS_ZSCHM PS_ZSCHM CHAR 7   0   Interest Profile for Project/Order Interest Calculation TPI01
73 IMPRF IM_PROFIL IM_PROFIL CHAR 6   0   Investment measure profile TAPRF
74 EVGEW EV_WEIGHTD DEC8 DEC 8   0   Aggregation weight for POC (PS progress)  
75 AENNR AENNR AENNR CHAR 12   0   Change Number AENR
76 SUBPR PS_SUBPR PS_SUBPR CHAR 12   0   Sub-project in work breakdown structure PRTP
77 POSTU PS_POSTU CHAR40 CHAR 40   0   PS: Short description (1st text line) in all caps  
78 PLINT PLINT XFELD CHAR 1   0   Indicator for Integrated Planning  
79 LOEVM LOEVM XFELD CHAR 1   0   Deletion Indicator  
80 KZBWS KZBWS KZBWS CHAR 1   0   Valuation of Special Stock  
81 FPLNR FPLNR FPLNR CHAR 10   0   Billing plan number / invoicing plan number  
82 TADAT TABGDAT DATUM DATS 8   0   Technically complete date  
83 IZWEK IZWEK IZWEK CHAR 2   0   Reason for investment T087I
84 ISIZE IM_SIZECL SIZECL CHAR 2   0   Scale of investment objects TAIF5
85 IUMKZ AM_UMWKZ AM_UMWKZ CHAR 5   0   Reason for environmental investment T087K
86 ABUKR IM_ABUKRS BUKRS CHAR 4   0   Requesting company code T001
87 GRPKZ GRPSPKZ GRPSPKZ CHAR 1   0   Indicator: Grouping WBS element  
88 PGPRF PGPROFID PGPROFID CHAR 6   0   Distribution profile TPGPRF
89 LOGSYSTEM LOGSYSTEM LOGSYS CHAR 10   0   Logical System  
90 PSPNR_LOGS NUM08 NUM08 NUMC 8   0   Numeric field length 8  
91 STORT PS_STORT AP_STAND CHAR 10   0   Location T499S
92 FUNC_AREA FKBER FKBER CHAR 16   0   Functional Area TFKB
93 KLVAR CK_KLVAR KLVAR CHAR 4   0   Costing Variant  
94 KALNR CK_KALNR CK_KALNR NUMC 12   0   Cost Estimate Number for Cost Est. w/o Qty Structure  
95 POSID_EDIT PS_POSID_EDIT PS_POSID_EDIT CHAR 24   0   Work Breakdown Structure Element (WBS Element) Edited  
96 PSPKZ PL_PSPKZ XFELD CHAR 1   0   Indicator: WBS element for production lot  
97 MATNR MATNR MATNR CHAR 18   0   Material Number  
98 VLPSP PL_PSP_PNR PS_POSNR NUMC 8   0   WBS: Reference work breakdown structure element  
99 VLPKZ PL_VLPKZ XFELD CHAR 1   0   Indicator: Reference WBS element for production lot  
100 SORT1 PL_SORT1 CHAR10 CHAR 10   0   Sort string 1 for production lot  
101 SORT2 PL_SORT2 CHAR10 CHAR 10   0   Sort string 2 for production lot  
102 SORT3 PL_SORT3 CHAR10 CHAR 10   0   Sort string 3 for production lot  
103 VNAME JV_NAME JV_NAME CHAR 6   0   Joint venture T8JV
104 RECID JV_RECIND JV_RECIND CHAR 2   0   Recovery Indicator T8JJ
105 ETYPE JV_ETYPE JV_ETYPE CHAR 3   0   Equity type T8JE
106 OTYPE JV_OTYPE JV_OTYPE CHAR 4   0   Joint Venture Object Type  
107 JIBCL JV_JIBCL JV_JIBCL CHAR 3   0   JIB/JIBE Class T8J6A
108 JIBSA JV_JIBSA JV_JIBSA CHAR 5   0   JIB/JIBE Subclass A T8J6C
109 CGPL_GUID16 CGPL_GUID16_R3 SYSUUID RAW 16   0   Generic project planning: GUID from external R/3 system  
110 CGPL_LOGSYS CGPL_LOGSYS LOGSYS CHAR 10   0   Generic project planning: Log. system for CGPL_GUID16_R3  
111 CGPL_OBJTYPE CGPL_OBJECT_TYPE_R3 CHAR3 CHAR 3   0   Generic project planning: object type from ext. R/3 system  
112 ADPSP ADDCOMPARE_CORE ADDCOMPARE_CORE CHAR 40   0   Reference Element PM/PS  
113 RFIPPNT CN_RPIP CN_RFPNT CHAR 20   0   Reference Point for Relationship Between iPPE and PS TCNRPIP
114 LEDNR BP_LEDNR LEDNR_BP CHAR 4   0   Budget/Planning Ledger  
115 POSIT BP_POSIT BP_POSIT CHAR 8   0   Internal commitment item (8 chars)  
116 TRGKZ BP_TRGKZ BP_TRGKZ CHAR 1   0   Object indicator  
117 WRTTP CO_WRTTP CO_WRTTP CHAR 2   0   Value Type  
118 GJAHR GJAHR GJAHR NUMC 4   0   Fiscal Year  
119 GEBER BP_GEBER BP_GEBER CHAR 10   0   Fund FMFINCODE
120 VERSN BP_VERSION BP_VERSION CHAR 3   0   Planning/budgeting version  
121 VORGA BP_VORGANG ACTIVITY CHAR 4   0   Budget Type Budgeting/Planning T022
122 TWAER TWAER WAERS CUKY 5   0   Transaction Currency TCURC
123 SUBVO BP_SUBVO BP_SUBVO CHAR 4   0   Budget Subtype  
124 GNJHR GNJHR GJAHR NUMC 4   0   Year of Cash Effectivity  
125 FAREA FM_FAREA FKBER CHAR 16   0   Functional Area  
126 WTJHR BP_WJT WERTV8 CURR 15   2   Annual value in transaction currency  
127 WLJHR BP_WJL WERTV8 CURR 15   2   Annual value in ledger currency  
128 WTJHV BP_WJTV WERTV8 CURR 15   2   Distributed annual value in transaction currency  
129 WLJHV BP_WJLV WERTV8 CURR 15   2   Distributed annual value in ledger currency  
130 SPRED SPRED SPRED CHAR 4   0   Distribution Key T821S
131 BELTP BP_INOUT BP_INOUT NUMC 1   0   Debit type  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 V_AVCHANA_PR_JA ABGSL TKKAA ABGSL REF C CN
2 V_AVCHANA_PR_JA ABUKR T001 BUKRS 1 CN
3 V_AVCHANA_PR_JA AENNR AENR AENNR REF C CN
4 V_AVCHANA_PR_JA AKOKR TKA01 KOKRS REF C CN
5 V_AVCHANA_PR_JA AKSTL CSKS KOSTL REF C CN
6 V_AVCHANA_PR_JA ASTNR TCJ05 ASTNR REF C CN
7 V_AVCHANA_PR_JA EQUNR EQUI EQUNR REF C CN
8 V_AVCHANA_PR_JA ETYPE T8JE ETYPE REF C CN
9 V_AVCHANA_PR_JA FABKL TFACD IDENT REF 1 CN
10 V_AVCHANA_PR_JA FKOKR TKA01 KOKRS REF C CN
11 V_AVCHANA_PR_JA FKSTL CSKS KOSTL REF C CN
12 V_AVCHANA_PR_JA FUNC_AREA TFKB FKBER    
13 V_AVCHANA_PR_JA GEBER FMFINCODE FINCODE KEY 1 CN
14 V_AVCHANA_PR_JA IMPRF TAPRF IVPRO REF C CN
15 V_AVCHANA_PR_JA ISIZE TAIF5 SIZECL 1 CN
16 V_AVCHANA_PR_JA IUMKZ T087K UMWKZ 1 CN
17 V_AVCHANA_PR_JA IZWEK T087I IZWEK 1 CN
18 V_AVCHANA_PR_JA JIBCL T8J6A CLASS    
19 V_AVCHANA_PR_JA JIBSA T8J6C SUBCLASS    
20 V_AVCHANA_PR_JA KALSM T683 KALSM REF C CN
21 V_AVCHANA_PR_JA KAPPL T681A KAPPL REF C CN
22 V_AVCHANA_PR_JA KOSTL CSKS KOSTL REF C CN
23 V_AVCHANA_PR_JA KTRG CKPH KSTRG REF C CN
24 V_AVCHANA_PR_JA KVEWE T681V KVEWE REF C CN
25 V_AVCHANA_PR_JA MANDT T000 MANDT KEY 1 CN
26 V_AVCHANA_PR_JA OBJNR ONR00 OBJNR REF C C
27 V_AVCHANA_PR_JA PBUKR T001 BUKRS REF C CN
28 V_AVCHANA_PR_JA PGPRF TPGPRF PROFID 1 CN
29 V_AVCHANA_PR_JA PGSBR TGSB GSBER REF C CN
30 V_AVCHANA_PR_JA PKOKR TKA01 KOKRS REF C CN
31 V_AVCHANA_PR_JA PRART TCJ1 PRART REF C CN
32 V_AVCHANA_PR_JA PRCTR CEPC PRCTR REF C CN
33 V_AVCHANA_PR_JA PSPHI PROJ PSPNR REF 1 CN
34 V_AVCHANA_PR_JA PSPRI TCN07 NPRIO REF C CN
35 V_AVCHANA_PR_JA PWPOS TCURC WAERS REF C CN
36 V_AVCHANA_PR_JA RECID T8JJ RECID REF C CN
37 V_AVCHANA_PR_JA RFIPPNT TCNRPIP RFPNT C CN
38 V_AVCHANA_PR_JA SLWID TCN00 SLWID REF C CN
39 V_AVCHANA_PR_JA SPRED T821S SPRED REF 1 CN
40 V_AVCHANA_PR_JA SPSNR PRPSS PSPNR REF C C
41 V_AVCHANA_PR_JA STORT T499S STAND    
42 V_AVCHANA_PR_JA SUBPR PRTP SUBPR REF C CN
43 V_AVCHANA_PR_JA TPLNR IFLOT TPLNR REF C CN
44 V_AVCHANA_PR_JA TWAER TCURC WAERS KEY 1 CN
45 V_AVCHANA_PR_JA TXJCD TTXJ TXJCD REF C CN
46 V_AVCHANA_PR_JA TXTSP T002 SPRAS REF C CN
47 V_AVCHANA_PR_JA USE04 T006 MSEHI REF C CN
48 V_AVCHANA_PR_JA USE05 T006 MSEHI REF C CN
49 V_AVCHANA_PR_JA USE06 TCURC WAERS REF C CN
50 V_AVCHANA_PR_JA USE07 TCURC WAERS REF C CN
51 V_AVCHANA_PR_JA VERNR TCJ04 VERNR REF C CN
52 V_AVCHANA_PR_JA VNAME T8JV VNAME REF C CN
53 V_AVCHANA_PR_JA VORGA T022 ACTIVITY KEY 1 CN
54 V_AVCHANA_PR_JA WERKS T001W WERKS REF 1 CN
55 V_AVCHANA_PR_JA ZSCHL TKZSL ZSCHL    
56 V_AVCHANA_PR_JA ZSCHM TPI01 ZSCHM REF C CN
History
Last changed by/on SAP  20130529 
SAP Release Created in