cancel
Showing results for 
Search instead for 
Did you mean: 

details of vendor master data

Former Member
0 Kudos

Dear All ,

Can u help me that my user wants a dump of all newly added supplier in last three months , along with the dump of any changes done in supplier master data , i.e he want to have data for newly added supplier & dump of those supplier in which some changes are done .pl .

Rgds ,

sap11

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

hi,

goto SE16 put table name LFA1

take the dump of list of LIFNR naving the ERDAT in ur slected range.

for this u can creat the query through SQVI also.

regards,

sujit

Answers (7)

Answers (7)

Former Member
0 Kudos

thanx to all for valuable efforts

sap11

Former Member
0 Kudos

use abap skill to pull data joining below tables to get the changes made in general data, company code segment and purchasing data.

LFA1 Vendor master

LFB1 Vendor per company code

LFB5 Vendor dunning data

LFM1 Purchasing organisation data

LFM2 Purchasing data

LFBK Bank details

Former Member
0 Kudos

thanx for this , my user says that this report should have some newly added vendors , how i can know that these are new created vendors or old one .

sap11

Former Member
0 Kudos

Please check whether this may be of ur help

1. S_ALR_87012089 or XK04 or MK04

or.

  • get vendor change records for dates

CALL FUNCTION 'CHANGEDOCUMENT_READ_HEADERS'

EXPORTING

date_of_change = l_from

objectclass = 'KRED'

username = ' '

date_until = l_to

TABLES

i_cdhdr = it_hdr

EXCEPTIONS

no_position_found = 1

wrong_access_to_archive = 2

time_zone_conversion_error = 3

OTHERS = 4.

IF it_hdr IS INITIAL.

MESSAGE i099(zf) WITH 'No Master changes -'

'CHANGEDOCUMENT_READ_HEADERS result' sy-subrc.

RETURN.

ENDIF.

SORT it_hdr.

  • look for vendor name changes

SELECT * INTO TABLE it_pos

FROM cdpos

FOR ALL ENTRIES IN it_hdr

WHERE objectclas = it_hdr-objectclas

AND objectid = it_hdr-objectid

AND changenr = it_hdr-changenr

AND fname = 'NAME1'.

IF sy-subrc NE 0.

MESSAGE i099(zf) WITH 'No vendor master names have changed.'.

RETURN.

ELSE.

MESSAGE i099(zf) WITH 'Vendor master names have changed.'.

ENDIF.

Former Member
0 Kudos

hi

Use SE11 table- LFA1 once excuted, you will not find the date field, for that in the menu level go to setting in the drop down in that select the field for selection, select the field ERDAT-created on field you will find the filed for entry. Now give from to date for selection output and execute(F8).

Best Regards

Former Member
0 Kudos

Hi,

use T-Code se16 or se11

Enter table lfa1.This will provide info as per your need related to vendor.

Thanks

Abhinav

former_member433442
Active Contributor
0 Kudos

Hi,

Use T.CODE: AUT10, enter start date and t.code then execute, you will get the required report.

Regards,

Prabu

Former Member
0 Kudos

For finding out the vendors created in certain period, check in table LFA1 .

SE16 - TABLE LFA1- Check for field u2018ERDATu2019. Give the range of dates.

Former Member
0 Kudos

Hi

In transaction SE11, you may use CDHDR table with input for field Transaction as MK02, XK02, FK02 (which are used to change Vendor Master by Purchasing & Finance teams) and under field Object value you will see the Vendor Master number.

Thanks

Prashanth