Database tables of PP

Question:
Hi guys,
As i am new comer so can anybody let me know the std. tables generally used and commonly used fields in PP Module alongwith fields of table also whcih are most commonly used.
veyant
_________________
Veyant
Answer:
Hi...
For a quick search for PP std tables, you can search for tables
with name AF* and press F4 (available entries) in SE11 (ABAP Dictionary).
Most of PP's tables name are initiated by the 'AF*', such as :
- AFKO (Order header)
- AFPO (Order item)
- AFRU (Confirmation)
- etc
As for the fields, almost all the key fields on that tables above are important, such as AUFNR (order number), POSNR (order item number), etc.
As you try to write program in PP module, you'll find out what you need in your purposes by yourself.
Hope it helps,
yasin
Answer:
Yasim,
Can all tables (master + transaction) in PP start with AF.
thanks
veyant
_________________
Veyant
Answer:
can anybody help me on this...its ugent..
sandy
_________________
Veyant
Answer:
It's not necessary that all the tables will start with AF*. There are overall 1066 tables in PP modules as far as I know.
Regards
TandT
Yasim,
Can all tables (master + transaction) in PP start with AF.
thanks
veyant
Answer:
Hey sandy
Are you from scet ?
Its nimesh here.
Checkit out some table list as per your requirement
Production Planning (PP)
Work center
CRHH Work center hierarchy
CRHS Hierarchy structure
CRHD Work center header
CRTX Text for the Work Center or Production Resource/Tool
CRCO Assignment of Work Center to Cost Center
KAKO Capacity Header Segment
CRCA Work Center Capacity Allocation
TC24 Person responsible for the workcenter
Routings/operations
MAPL Allocation 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
PLPH Phases / suboperations
PLPO Task list operation / activity
PLPR Log collector for tasklists
PLMZ Allocation of BOM - items to operations
Bill of material
STKO BOM - header
STPO BOM - item
STAS BOMs - Item Selection
STPN BOMs - follow-up control
STPU BOM - sub-item
STZU Permanent BOM data
PLMZ Allocation of BOM - items to operations
MAST Material to BOM link
KDST Sales order to BOM link
Production orders
AUFK Production order headers
AFIH Maintenance order header
AUFM Goods movement for prod. order
AFKO Order header data PP orders
AFPO Order item
RESB Order componenten
AFVC Order operations
AFVV Quantities/dates/values in the operation
AFVU User fields of the operation
AFFL Work order sequence
AFFH PRT assignment data for the work order(routing)
JSTO Status profile
JEST Object status
AFRU Order completion confirmations
PRT's voor production orders
AFFH PRT assignment data for the work order
CRVD_A Link of PRT to Document
DRAW Document Info Record
TDWA Document Types
TDWD Data Carrier/Network Nodes
TDWE Data Carrier Type
Planned orders
PLAF Planned orders
KANBAN
PKPS Kanban identification, control cycle
PKHD Kanban control cycle (header data)
PKER Error log for Kanban containers
Reservations
RESB Material reservations
RKPF header
Capacity planning
KBKO Header record for capacity requirements
KBED Capacity requirements records
KBEZ Add. data for table KBED (for indiv. capacities/splits)
Planned independent requirements
PBIM Independent requirements for material
PBED Independent requirement data
PBHI Independent requirement history
PBIV Independent requirement index
PBIC Independent requirement index for customer req.
Project system (PS)
Basic data
PRHI Work Breakdown Structure, Edges (Hierarchy Pointer)
PROJ Project definition
PRPS WBS (Work Breakdown Structure) Element Master Data
RPSCO Project info database: Costs, revenues, finances
MSPR Project stock
Equipment
EQUI Equipment master data
EQKT Equipment short text
EQUZ Equipment time segment
Regards
Nimesh
Answer:
Hey sandy
Are you from scet ?
Its nimesh here.
Checkit out some table list as per your requirement
Production Planning (PP)
Work center
CRHH Work center hierarchy
CRHS Hierarchy structure
CRHD Work center header
CRTX Text for the Work Center or Production Resource/Tool
CRCO Assignment of Work Center to Cost Center
KAKO Capacity Header Segment
CRCA Work Center Capacity Allocation
TC24 Person responsible for the workcenter
Routings/operations
MAPL Allocation 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
PLPH Phases / suboperations
PLPO Task list operation / activity
PLPR Log collector for tasklists
PLMZ Allocation of BOM - items to operations
Bill of material
STKO BOM - header
STPO BOM - item
STAS BOMs - Item Selection
STPN BOMs - follow-up control
STPU BOM - sub-item
STZU Permanent BOM data
PLMZ Allocation of BOM - items to operations
MAST Material to BOM link
KDST Sales order to BOM link
Production orders
AUFK Production order headers
AFIH Maintenance order header
AUFM Goods movement for prod. order
AFKO Order header data PP orders
AFPO Order item
RESB Order componenten
AFVC Order operations
AFVV Quantities/dates/values in the operation
AFVU User fields of the operation
AFFL Work order sequence
AFFH PRT assignment data for the work order(routing)
JSTO Status profile
JEST Object status
AFRU Order completion confirmations
PRT's voor production orders
AFFH PRT assignment data for the work order
CRVD_A Link of PRT to Document
DRAW Document Info Record
TDWA Document Types
TDWD Data Carrier/Network Nodes
TDWE Data Carrier Type
Planned orders
PLAF Planned orders
KANBAN
PKPS Kanban identification, control cycle
PKHD Kanban control cycle (header data)
PKER Error log for Kanban containers
Reservations
RESB Material reservations
RKPF header
Capacity planning
KBKO Header record for capacity requirements
KBED Capacity requirements records
KBEZ Add. data for table KBED (for indiv. capacities/splits)
Planned independent requirements
PBIM Independent requirements for material
PBED Independent requirement data
PBHI Independent requirement history
PBIV Independent requirement index
PBIC Independent requirement index for customer req.
Project system (PS)
Basic data
PRHI Work Breakdown Structure, Edges (Hierarchy Pointer)
PROJ Project definition
PRPS WBS (Work Breakdown Structure) Element Master Data
RPSCO Project info database: Costs, revenues, finances
MSPR Project stock
Equipment
EQUI Equipment master data
EQKT Equipment short text
EQUZ Equipment time segment
Regards
Nimesh
Answer:
thanks nimesh..
i am from India.
sandy
_________________
Veyant
Answer:
nimesh,
can you help me in list of tables for S&D also.
Sandeep
Answer:
Here are some of them.
Now cheers
Sales and Distribution (SD) :
VBFA Document flow (alg.)
VTFA Flow shipping documents
Sales order :
VBAK Header data
VBAP Item data
VBPA Partners in sales order
VBKD Sales district data
VBEP Data related to line items, delivery lines
Billing document :
VBRK header data
VBRP Item data
Shipping :
VTTK Shipment header
VTTP Shipment item
VTTS Stage in transport
VTSP Stage in transport per shipment item
VTPA Shipment partners
VEKP Handling Unit - Header Table
VEPO Packing: Handling Unit Item (Contents)
Delivery :
LIKP Delivery header
LIPS Delivery item
Pricing :
KONH Conditions header
KONP Conditions items
KONV Procedure ( billing doc or sales order)
KOND
contracts :
VEDA Contract data
Answer:
thanks nimesh,
Can i have something on ALE / IDOCS/ EDI..Any documentation if you can provide me..
my email is sandeep_makan@hotmail.com
, veyant@indiatimes.com

i know i am little more demnading..
bye and thanks once again..
Sandy
_________________
Veyant

More Articles:

Screens: No further list processing possible.?
find Maximum document number in internal tabel?
List --> Save --> File --> unconverted?
Hidden Field - Please help?
Tree control, Report and Splitter?
BDC Problem?