10-30-2008 1:13 PM
Hi gurus,
can any one have any idea of the following fields.
matnr,process order no,cost center,date range (erdat)
I need to pullout the above from the tables.
I am new to PP process. can anyone help me out in this process.
thanks.................
10-30-2008 1:17 PM
Hi,
Check This tables
AFKO Order Header
AFPO Order Item Detail
AFVC Order Operations Detail
regards
ranga
10-30-2008 1:17 PM
Hi,
Check This tables
AFKO Order Header
AFPO Order Item Detail
AFVC Order Operations Detail
regards
ranga
10-30-2008 1:21 PM
Hi,
You can get the following fields from the table
AFPO
AFKO
AUFK
Thanks,
Chidanand
10-30-2008 1:53 PM
hi ,
I need to have two more fields standard labor hrs
and actual labor hrs along with the above fields.
Are there any other tables to pullout the above fields.
thanks,
sudha.........
10-30-2008 2:04 PM
10-30-2008 1:51 PM
Hi,
If you need to pull Process order data based on material,cost center and date range you can use the AUFK and AFPO.
You can also use the view CAUFV.
Thanks,
Venkat Kondapally.
10-30-2008 2:08 PM
Most important PP tables:
Appl. Development R/3 Plant Maintenance Order Processing
AFIH Maintenance order header
AUFM Goods movements for order
Application development R/3 inventory management
RESB Reservation/dependent requirements
RKPF Document Header: Reservation
Application development R/3 purchasing
PBED Independent requirements data
PBHI Independent requirements history
PBIC Ind. reqmts index for customer requirements (without RV)
PBIM Independent requirements for material
PBIV Ind. reqmts index for consump. of exter. non-variable parts
Application development R/3 requirements planning
PLAF Planned order
Cost Accounting, Orders
AUFK Order master data
Development Class KANBAN
PKER Error Log of the Kanban Containers
PKHD Control Cycle
PKPS Control Cycle Item / Kanban
Document Management
DRAW Document Info Record
TDWA Document Types
TDWD Data Carrier/Network Nodes
TDWE Data Carrier Type
General Status Management
JEST Object status
JSTO Status object information
R/3 Appl. development: PPS production resources/tools
AFFH PRT assignment data for the work order
CRVD_A Link of PRT to Document
R/3 Applic. development: PPS CAPP standard times calculation
PLPH CAPP: Sub-operations
R/3 Application development: PP Bills of Material
KDST Sales Order to BOM Link
MAST Material to BOM Link
STAS BOMs - Item Selection
STKO BOM Header
STPN BOM Follow-Up Control
STPO BOM item
STPU BOM Sub-Item
STZU Permanent BOM data
R/3 Application development: PP Confirmations
AFRU Order completion confirmations
R/3 Application development: PP Production orders
AFFL Work order sequence
AFKO Order header data PP orders
AFPO Order item
AFVC Operation within an order
AFVU DB structure of the user fields of the operation
AFVV DB structure of the quantities/dates/values in the operation
R/3 Application development: PP Resources
CRCA Work Center Capacity Allocation
CRCO Assignment of Work Center to Cost Center
CRHD Work Center Header
CRHH Hierarchy Header Data
CRHS Hierarchy Structure
CRTX Text for the Work Center or Production Resource/Tool
KAKO Capacity Header Segment
TC24 Person responsible for the work center
R/3 Application development: PP Task Lists
MAPL Assignment of Task Lists to Materials
PLAS Task list - selection of operations/activities
PLFH Task list - production resources/tools
PLFL Task list - sequences
PLKO Task list - header
PLKZ Task list: main header
PLMZ Allocation of bill of material items to operations
PLPO Task list - operation/activity
PLPR Log collector for task lists
R/3 Application development: R/3 Scheduling
KBED Capacity requirements records
KBEZ Add. data for table KBED (for indiv. capacities/splits)
KBKO Header record for capacity requirements
Regards