Issue in MB1B(301) using LSMW.

[former_member276017]

Hi experts,

                      >removed by moderator<

                       I have tried to upload the file for 301 mvt type using lsmw.

                       i want to  upload 100 data from a file...it should generate one material document number..while recording i have used f8 key then only  it will back  to material field. but when i run batch input session, first data it is taking but when it comes to secomd data, it s displaying a message as "Field DKACB_fmore does not exist in screen SAPMM07M"............

how it will take continuous data one by one .

any looping method is required for this??

plz help me out.

Thanks & Regards,

Deepika.

Message was edited by: Jürgen L

[bisweswar_sahu · Accepted solution]

Hi,

As per requirement, AKPT given solution is recommended.

Check BMSEG (Batch Input Structure: Material Movements) field details in SE11.

In addition to that, in LSMW steps, during "Create Batch Input Session",

Enter "Max. Number of items" : <100> as per need

System will post documents with line items as u mentioned in last step.

Note: System will split documents, if your document reference (XBLNR) will differ.

e.g.

Total line items: 100 & Unique reference (XBLNR) is 5

It'll Post 5 Material Documents.

Regards,

Bisweswar

[former_member276017 · Accepted solution]

HI biswwskar,

                      Is it necessary to include all the standard fields in the file or only  desired fields which we require?

Thanks,

Deepika

[bisweswar_sahu · Accepted solution]

Hi,

The structure(BMSEG) having all fields for all types of material movements (e.g. 301, 309, 311 etc).

As per requirement, use desired fields in your source field to input.

For TP: 301, you must keep BUDAT, BWART WERKS, LGORT, MATNR, ERFMG, ERFME, CHARG (if Batch Managed), UMWRK, UMLGO, UMCHA(if Batch Managed).

Other fields can be used as desired.

Regards,

Bisweswar

[former_member276017 · Accepted solution]

HI ,

    Thanks for your information.

     It was Helpful.

    As you mentioned that ,

    Note: System will split documents, if your document reference (XBLNR) will differ.

    Plz explain me...

    One material doc should generate for one excel file...file may contains even 1000 items also..

    Is it possible?

   Thanks & Regards,

    Deepika.

[JL23 · Accepted solution]

The accounting document limits this desire. It can only have 999 items.

Check in your test system how many items an accounting document has for just 1 of your Excel lines, then you can calculate how much you can maximum enter into one material document. SAP restricts e.g. the physical inventory document to 333 items for that reason.

[former_member276017 · Accepted solution]

Hi Experts ,

                 I want to post 470 line items for 301 (plant-plant transfer) in lsmw,but it's got splitted into two documents.

                      But I want one document number should be generated for all line items..

can i do it? plz provide solution.

Thanks & Regards,

Deepika

[JL23 · Accepted solution]

Each movement creates one or more accounting documents, and a accounting document can only have 999 items, hence the maximum materials in a material document is limited. e.g. in case of a physical inventory it is 333

[bisweswar_sahu]

Hi,

As Jurgen inform about A/C document limit, don't use huge lines per document.

I'll suggest to use Max:300 ( myself use mostly.)

It'll help you to keep track & validate on need.

Regards,

Bisweswar

[former_member276017]

Hi,

    Ya ok .i will maintain as per your suggestion.

    Thanks for your reply.

   Regards,

   Deepika.

[former_member183424]

Hi,

Check you recording, You have deleted this line..

Please re-record the recording, and don't delete this.

Thanks

DEV

[former_member276017]

Hi Dev,

               Thanks for your reply.I didnt delete that  field.but still that message is displaying...............

Thanks,

Deepika

[former_member183424]

Okay,

I am sharing the screen shot of recording for transfer posting movement type 301.

Plant and storage location were repeated, please delete it for second tome.

And also the field DKACB-FMORE is repeated, please delete the last one.

Try it and revert me back.

Thanks

DEV

[Prasoon]

Hi,

   If you want to post a single material document for number of materials, I would suggest to use the standard program RM07MMBL in lsmw or MBBM transaction.

   Go to SE38 and enter the program RM07MMBL and check the documentation. It will guide you how to proceed.

Regards,

AKPT