how to identify Dealer vendor and manufacturing vendor ?

[Former Member]

Hello all,

          i would like to identify the dealer vendor and normal manufacturing vendor,

how can i differentiate them from each other,and where i can found them?

[kailas_ugale]

HI<

1) Legal in India if Dealer vendor has excise registration  number then you can find in ECC number ,if there is D in that number then its dealer and IF M then manufacturer.

check in J1ID t-code

2) Technically separate then by Number range of Vendor group number range.

Regards

Kailas Ugale

[Former Member]

these are not useful answers frnds,

i found an indicatour in J_1IEXCDTL table which differentiates from vendor n dealer vendor,

but how can i found the po amount related to particular dealer vendor...!!!

[Sijin_Chandran]

Hi Amit ,

You can find PO Amount by fetching the corresponding PO related documents.

From EKKO and EKPO based on the LIFNR

[Former Member]

Hi Amit,

  Use Table j_1iexchdr.fatch data on basis of internal document number and year.You can also find material document number for further use.

Regards

Ajit tiwari

[Sijin_Chandran]

Hi Amit ,

In J_1IEXCDTL there is a field RDOC1 , which is PO ( EBELN ) number pass it to EKKO to get PO amount.

Don't forget to set J_1IEXCDTL-TRNTYP = 'GRPO'          " Excise document for Purchasing

[Former Member]

i have alrdy done this,its not a big issue.i knw wher can i found po related documnts..the problem here is of dealer vendor n manf. vendors po amount differntiation....u r nt gettng the right requisition frd...

[Former Member]

it doesnt fetch the taxes amount applicable for po..it shoukd b gt fetchd from ekpo only...!!!

[Sijin_Chandran]

Have you checked in KONV based on Condition Document number ?

[Sijin_Chandran]

EKKO-KNUMV = KONV-KNUMV.

[Former Member]

Hi Amit,

     Debopriya Is right.you can identify it by account Group.

Regards

Ajit tiwari

[Former Member]

you can not differntitate it by account group...

[Former Member]

Hello Amit,

Kindly check similar post.

http://scn.sap.com/thread/2016027

http://scn.sap.com/thread/3194076

rgds,

Deepti

[reachdebopriya]

Hi Amit,

Dealer Vendor and Manufacturing Vendor both are in table LFA1.

It can be differentiate by Vendor Account Group (KTOKK).

0001 - Vendor

0002 - Goods Supplier

MNFR - Manufacturer

Regards,

Debopriya Ghosh