Sunday, June 21, 2009

Multi Org Structure Table


Name :Business Group
Table :HRFV_BUSINESS_GROUPS
Profile:HR:Business Group ID
Column: BUSINESS_GROUP_ID

Name :Set Of Books
Table :GL_SET_OF_BOOKS
Profile:GL: Set of books name
Column: Set_of_book_id

Name :Legal Entity
Table :HR_LEGAL_ENTITIES
Profile:
Column:

Name :Operating Unit
Table :HR_OPERATING_UNITS
Profile:MO:Operating Unit
Column:ORG_ID

Name:Inventroy Organization
Table:ORG_ORGANIZATION_DEFINITIONS
Profile:
Column:ORGANIZATION_ID

Name:Sub Inventory
Table:MTL_SECONDARY_INVENTORIES
Profile:
Column:

Name:Stock Locations
Table:MTL_ITEM_LOCATIONSQ
Profile:
Column:

Name:MTL_SYSTEM_ITEMS
Table:
Profile:
Column:Requisition,RFQ,Quotations,PO,PO Receipts

Business Group ID Tables

  • PER_ALL_PEOPLE_F
  • PER_JOBS
  • PER_GRADES
  • PER_POSITIONS

ORG ID Tables

  • PO_REQUESITION_HEADERS_ALL
  • PO_HEADERS_ALL
  • PO_DISTRIBUTION_ALL

ORGANIZATION ID Tables

  • MTL_SYSTEM_ITES_B
  • WIP_ENTITITES
  • BOM_RESOURCES
  • BOM_DEPARTMENT

Note : PO_Vendors not having _ALL Table
But PO_vendor_sites_all having _ALL table

4 comments:

what is sap ecc 6.0 said...

This post includes list of multi-organizational tables. You will get detail of all the tables. This information is very useful of different organization. This is brilliant work. I am very impressed with you idea. Thanks for writing this wonderful post.

Rao said...

Hi rama , Very thanks for the information..........

Rao said...

Hi rama , Very thanks for the information..........

Rao said...

Hi rama , Very thanks for the information..........