BOM DISTRIBUTION TABLE

[swabunn]

Please help, Any body knows BOM distribution history tables as GP have IV30500 for inventory

Thanks
-g

 

[BobSchleicher]

Could you give a little more explaination? Do you want to know where each component goes into?

BobSchleicher

 

[swabunn]

I am trying to pull debit and credit distributon for BOM transactions in inventory for example assembly distributions.

For examaple, I am pulling inventory distribution by following query:

select IV30500.DOCNUMBR AS DocNo, IV30500.CRDTAMNT AS Credit, IV30500.DEBITAMT AS Debit,
IV30200.DOCDATE as DocDate, IV30200.GLPOSTDT as GLDate, '' AS MASTERID,
GL00105.ACTNUMST,GL00105.ACTNUMBR_1 as Main,GL00105.ACTNUMBR_2 as Location,'INV' as Origin, IV30500.ACTINDX
FROM IV30500 INNER JOIN
IV30200 ON IV30500.DOCNUMBR=IV30200.DOCNUMBR AND
IV30500.IVDOCTYP=IV30200.IVDOCTYP INNER JOIN
GL00105 on IV30500.ACTINDX = GL00105.ACTINDX
WHERE IV30500.IVDOCTYP <=3

and I want to pull same way debit and credit distribution of assembly in BOM ( Bill of Materials)

Thanks

-g

 

[BobSchleicher]

I don't know about the distributions but here is a table that will give you historical standard cost activity.

CT00200

I know this isn't what you want but this is all I have to offer.

BobSchleicher

 

[swabunn]

I am having hard time to find BOM distribution table. In IV30500, The distribution for Inventory Transacitons are stored like wise table POP30390 and sop10102 have distribution for puchasing and sales transactions. does any body where BOM Distribution are stored. Without this table I am not able make query to reconcile inventory

Thanks all

-swabunn