topic Table For Material Document in Application Development and Automation Discussions

Table For Material Document

Former Member — Wed, 18 Jun 2008 10:45:02 GMT

Hi Guru,

My requirement is that I have to fetch Dmbtr field from MSEG table for the current period and movement type. But I dont have filed perios in MSEG table. But I have documnet number (MBLNR ) in MSEG. So is there any link so that I can fetch DMBTR for the particular period and movement type.

Maximum pts will be rewarded.

Thanks,

Sandeep Garg

Re: Table For Material Document

Former Member — Wed, 18 Jun 2008 10:50:10 GMT

Before reading the items (table MSEG) u should extract the header (MKPF) selecting for posting date: MKPF-BUDAT.

If you need to know which documents are posted in a certain period, it means to extract all documents posted in a certain range of day.

So u need to calculate the first and last day of the current period: these usually are the first and last day of the months.

So u can create a join beetween MKPF and MSEG in order to extract all items of a certain moviment type and posted in a certain period.

Max

Re: Table For Material Document

Former Member — Wed, 18 Jun 2008 10:53:53 GMT

pass mkpf-budat in function

' BAPI_COMPANYCODE_GET_PERIOD ' to get period.

Re: Table For Material Document

Former Member — Wed, 18 Jun 2008 10:55:40 GMT

Hi,

MKPF is the table for material document.

Regards,

Sharath

Re: Table For Material Document

Former Member — Wed, 18 Jun 2008 10:57:06 GMT

Hi,

MKPF we have date not the period ( month and year ).

Re: Table For Material Document

Former Member — Wed, 18 Jun 2008 11:00:52 GMT

hi,

u can find from table mkpf

fields - mblnr, budat,bldat

Rgds.,

subash

Re: Table For Material Document

GauthamV — Wed, 18 Jun 2008 11:01:20 GMT

hi,

check MBEW table.

field : LFMON - Current period (posting period)

reward points if hlpful.