You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Unable to see the child inventory org in EGP_COMPONENTS_B table

edited Jun 20, 2025 4:37AM in Product Master Data Management 4 comments

Unable to see the child inventory org in EGP_COMPONENTS_B table.

We have a requirement to fetch item where used details in which we need to fetch the details of parent item if the child item is passed in the report.

we are using these below tables to derive the parent item for the each child item

EGP_SYSTEM_ITEMS_B ESIB_CHILD
EGP_COMPONENTS_B ECB
EGP_STRUCTURES_B ESB

I am linking the ESIB_CHILD Inventory_ITEM_ID of ESIB_CHILD item to PK1 VALUE OF ECB table but when trying to link the org id of ESIB_CHILD to PK2_VALUE of ECB table i can see MASTER ORG ID is present in all records instead required org id

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!