Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

PP Tables

Former Member
0 Kudos

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.................

1 ACCEPTED SOLUTION

Former Member
0 Kudos

Hi,

Check This tables

AFKO Order Header

AFPO Order Item Detail

AFVC Order Operations Detail

regards

ranga

6 REPLIES 6

Former Member
0 Kudos

Hi,

Check This tables

AFKO Order Header

AFPO Order Item Detail

AFVC Order Operations Detail

regards

ranga

former_member598013
Active Contributor
0 Kudos

Hi,

You can get the following fields from the table

AFPO

AFKO

AUFK

Thanks,

Chidanand

0 Kudos

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.........

0 Kudos

some more tables in PP enviroment:

AFVV, AFVC, RESB, PLKO, PLPO.

Former Member
0 Kudos

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.

raymond_giuseppi
Active Contributor
0 Kudos

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