cancel
Showing results for 
Search instead for 
Did you mean: 

BOM Component data Dump from stpo table

Former Member
0 Kudos

Hi SAP Gurus,

I need to get the BOM Component data Dump as per the alternative BOM Wise. For this i am facing the issue in stpo table. i am not able to get the Component dat alternative BOM Wise. Suppose i am having alternative BOMs 1,2,3,

1BOM is having components as line items x,y,z,w,r

BOM   COMPONENTS item node

1         X,Y,Z,W,R        1,2,3,4

2         X,Y,Z,W,R,A     1,2,3,4,5

3         X,Y,Z,W,R,A,Q  1,2,3,4,5,6

while passing the data item node and BOM No into stpo table i am not getting the component data as per the alternative BOM Wise 1,2,3. I am not able to get the duplicate component line items as per the alternative BOM Wise. Only component line items showing as per the BOM No wise. But i need  as per the alternative wise. please guide me the way forward to me.

Thanks,

Mastan.

Accepted Solutions (0)

Answers (2)

Answers (2)

ArturoSenosain
Advisor
Advisor
0 Kudos

Hi.

Try this join:

MAST > STKO > STAS > STPO

WHERE


MAST-STLAL = STKO-STLAL
MAST-STLNR = STKO-STLNR

STKO-STLAL = STAS-STLAL
STKO-STLNR = STAS-STLNR
STKO-STLTY = STAS-STLTY


STAS-STLTY = STPO-STLTY

STAS-STLKN = STPO-STLKN

STAS-STLNR = STPO-STLNR



Arturo.

kiran_kumar179
Active Contributor
0 Kudos

Mastan,

You need to check the field Counter STPOZ among STKO and STPO tables you find out the alternative item details.

BR
KK