SAP ABAP View VIAOM_CPRO_AUFK (View Using Translator Table for cProjects and the AUFK)
Hierarchy
SAP_APPL (Software Component) Logistics and Accounting
   CO (Application Component) Controlling
     IAOM_CPROJECTS (Package) Cost and Revenue Controlling for cProjects
Basic Data
View Type D Database View 
Database View VIAOM_CPRO_AUFK  
Short Description View Using Translator Table for cProjects and the AUFK    
Root table AUFK   Order master data 
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 AUFK AUFK
2 IAOM_CPRO_EXAT  
3 IAOM_ASSIGNMENTS  
Join Conditions
# Table Name Field Name Negation Operator Constants Cont. line AND/OR Offset F Length Mco Field
1 IAOM_ASSIGNMENTS MANDT JL EQ 0 0
2 AUFK MANDT JR EQ AND 0 0
3 IAOM_ASSIGNMENTS OBJECT_NO JL EQ 0 0
4 AUFK OBJNR JR EQ AND 0 0
5 IAOM_ASSIGNMENTS MANDT JL EQ 0 0
6 IAOM_CPRO_EXAT MANDT JR EQ AND 0 0
7 IAOM_ASSIGNMENTS EXT_OBJECT_ID JL EQ 0 0
8 IAOM_CPRO_EXAT EXT_OBJECT_ID JR EQ AND 0 0
9 IAOM_ASSIGNMENTS BUS_SCENARIO_ID EQ 'CPROJECTS' 0 0
                     
View Fields
# View field Table Field Maintenance Flag Key Data element Mod Short Description
1 MANDT AUFK MANDT   MANDT Client
2 EXT_OBJECT_ID IAOM_CPRO_EXAT EXT_OBJECT_ID   IAOM_EXT_OBJECT_ID External Object Technical Key
3 AUFNR AUFK AUFNR   AUFNR Order Number
4 AUART AUFK AUART   AUFART Order Type
5 PROJECT_ID IAOM_CPRO_EXAT PROJECT_ID   DPR_TV_PROJECT_ID_CO Project Number in cProjects
6 BEZEICH IAOM_CPRO_EXAT BEZEICH   DPR_TV_BEZEICH_CO Description
7 RESP_ORG_UNIT IAOM_CPRO_EXAT RESP_ORG_UNIT   DPR_TV_RESP_ORGANIZATION_CO Organization Responsible
8 PRIORITY IAOM_CPRO_EXAT PRIORITY   DPR_TV_PRIORITY_CO Priority
9 PRO_TYPE IAOM_CPRO_EXAT PRO_TYPE   DPR_TV_PRO_TYPE_CO Project Type
10 CAUSE IAOM_CPRO_EXAT CAUSE   DPR_TV_CAUSE_CO Project Reason
11 GROUPING IAOM_CPRO_EXAT GROUPING   DPR_TV_GROUPING_CO Grouping
12 SEARCH_FIELD IAOM_CPRO_EXAT SEARCH_FIELD   DPR_TV_SEARCH_FIELD_CO Search Field
13 TEMP_EXTERNAL_ID IAOM_CPRO_EXAT TEMP_EXTERNAL_ID   DPR_TV_TEMP_EXTERNAL_ID_CO Template Number
14 CUSTOMER IAOM_CPRO_EXAT CUSTOMER   KUNAG Sold-to party
                 
Maintenance Status
Access
  read only
  read and change
  Time-dependent views: like U, validity data like ' '
  read, change, delete and insert
Delivery Class      
Data Browser/Table View Maintenance    Display/Maintenance Allowed with Restrictions  
History
Last changed by/on SAP  20130529 
SAP Release Created in 2002_1_46C