SAP ABAP View BIW_NAE_K (Data Collection Activity / Item - Capacity Rqmts for BW)
Hierarchy
SAP_APPL (Software Component) Logistics and Accounting
   PS-IS (Application Component) Information System
     KAP8 (Package) Export from Projects into BIW
Basic Data
View Type D Database View 
Database View BIW_NAE_K  
Short Description Data Collection Activity / Item - Capacity Rqmts for BW    
Root table AUFK   Order master data 
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 AUFK AUFK
2 AFKO  
3 AFVC  
4 AFVV  
5 KBED  
Join Conditions
# Table Name Field Name Negation Operator Constants Cont. line AND/OR Offset F Length Mco Field
1 AUFK MANDT JL EQ 0 0
2 AFKO MANDT JR EQ AND 0 0
3 AUFK AUFNR JL EQ 0 0
4 AFKO AUFNR JR EQ AND 0 0
5 AFKO MANDT JL EQ 0 0
6 AFVC MANDT JR EQ AND 0 0
7 AFKO AUFPL JL EQ 0 0
8 AFVC AUFPL JR EQ AND 0 0
9 AFVC MANDT JL EQ 0 0
10 KBED MANDT JR EQ AND 0 0
11 AFVC BEDID JL EQ 0 0
12 KBED BEDID JR EQ AND 0 0
13 AFVC BEDZL JL EQ 0 0
14 KBED BEDZL JR EQ AND 0 0
15 AFVC MANDT JL EQ 0 0
16 AFVV MANDT JR EQ AND 0 0
17 AFVC AUFPL JL EQ 0 0
18 AFVV AUFPL JR EQ AND 0 0
19 AFVC APLZL JL EQ 0 0
20 AFVV APLZL JR EQ AND 0 0
21 AUFK AUTYP EQ '20' 0 0
                     
View Fields
# View field Table Field Maintenance Flag Key Data element Mod Short Description
1 MANDT AFKO MANDT   MANDT Client
2 AUFNR AFKO AUFNR   AUFNR Order Number
3 AUTYP AUFK AUTYP   AUFTYP Order category
4 VORNR AFVC VORNR   VORNR Operation/Activity Number
5 APLZL AFVC APLZL   CO_APLZL General counter for order
6 AUFPL AFVC AUFPL   CO_AUFPL Routing number of operations in the order
7 PSPID_NP_I AFKO PRONR   PS_PSP_PRO Project definition
8 POSID_NP_I AUFK PSPEL   PS_PSP_ELE Work breakdown structure element (WBS element)
9 POSID_NV_I AFVC PROJN   PS_PSP_ELE Work breakdown structure element (WBS element)
10 ERDAT AUFK ERDAT   AUFERFDAT Created on
11 AEDAT AUFK AEDAT   AUFAEDAT Change date for Order Master
12 WERKS AFVC WERKS   WERKS_D Plant
13 ARBID AFVC ARBID   CR_OBJID Object ID of the resource
14 KALID AFVC KALID   WFCID Factory Calendar
15 SUMNR AFVC SUMNR   SUMKNTNR Node number of the superior operation
16 KAPID KBED KAPID   KAPID Capacity ID
17 KBEASOLL KBED KBEASOLL   CY_KBEASOL Process target capacity requirements for operation segment
18 KBEAREST KBED KBEAREST   CY_KBEARES Remaining capacity rqmts.for operation segment "Processing"
19 ARBEH AFVV ARBEH   ARBEITE Unit for work
20 FSTAD AFVV FSAVD   FSAVD Earliest scheduled start: Execution (date)
21 FENDD AFVV FSEDD   FSEDD Earliest scheduled finish: Execution (date)
22 CANUM KBED CANUM   CY_COUNT Counters for cap. rqmts. records (various caps. + indiv.caps
23 OBJNR AFVC OBJNR   J_OBJNR Object number
                 
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