Documents

71 views

lsmw

how to upload lsmw
of 7
All materials on our website are shared by users. If you have any questions about copyright issues, please report us to resolve them. We are always happy to assist you.
Share
Tags
Transcript
  Sales Documents upload using Standard Direct Input Program in LSMW Table of Contents  A.   OVERVIEW.. 5   LSMW using Direct Input Program.. 6   STEP-1: Maintain Object Attributes. 8   STEP-2: Maintain Source Structures. 9   STEP-3: Maintain Source Fields. 10   STEP-4: Maintain Structure Relationships. 11   STEP -5: Maintain Field Mapping. 11   STEP -6 :Maintain Fixed Values, translations, user Routines. 13   STEP -7: Specify Files. 14   STEP-8: Assign Files. 15   STEP- 9: Read Data. 16   STEP -10: Display Read Data. 17   STEP-11: Convert Data. 18   STEP-12: Display Converted Data. 18   STEP-13: Check Data against Customising. 19   STEP-14: Start Direct Input Program.. 20   STEP-15: Frame Program for Periodic Data Transfer   22   Appendix-A: Logical File Path and File Name Definition. 25   OVERVIEW   In most of the SAP Implementation / Support projects it is a common requirement to have a facility to upload sales documents to SAP. These Sales Documents may be the open sales orders during cutover stage or the documents generated in non-sap systems on a regular basis.   The challenge lies in the multiple line items of the documents to be uploaded. This makes it difficult to create a Recording in LSMW as the number of line items is not fixed. The general solution to this is to create a BDC program. This takes cares of the multiple line items in the documents to be uploaded.   However, the same can be done via SAP’s  Standard Direct Input Program. The SAP Program RVINB10 provides Eight Hierarchical Structures to capture Sales Documents data. The data that can be uploaded includes header data, item Data, Schedule Line data, Partner Data and Text data (Both header and line item texts).   All the sales documents can be processed by this direct Input Program. The sales Documents include Contracts, Scheduling Agreements, quotations, Inquires and sales orders.   In this document, we will see how to set up such a LSMW Project. The exported LSMW project is also attached in .TXT format. In Appendix-  A, the process of creating Logical File Path and Logical File names is also explained.   LSMW using Direct Input Program   In LSMW TCode, Create a Project, Sub project and Object.   Note: It is recommended to keep the names of the Project , sub project and Object short as the converted file name is a concatenation of the above three names. If names are of longer length, the converted file name may exceed the max file name length.   Now, We will look into each of the 15 Steps of the LSMW.   STEP-1: Maintain Object Attributes In Object Attributes, select Standard batch / Direct Input Option.   Select Object as 90: Sales Documents and method as 0000.   The program Name RVINB10 is automatically selected and Displayed.   STEP-2: Maintain Source Structures In Second Step create as many Source Structures as the data you want to supply.   The Program has following eight Structures :      BVBAKKOM : Sales Document Header      BVBPAKOM: Sales Document Partners      BVBAPKOM: Sales Document Items      BVBEPKOM: Sales Documents Schedule Lines      BTEXHKOM: Sales Documents: Text header      BTEXLKOM: Sales Documents: Text Lines   The Text Structures are available both at sales Documents Header and Item level, facilitating upload of both header and line item texts.    We need only create those many structures which we are going to upload data with.   In our example, we will be creating only three Structures for source Data:      ZVBAKKOM : Sales Document Header      ZVBPAKOM: Sales Document Partners      ZVBAPKOM: Sales Document Items   Note: Kindly create the source Structures as per the hierarchical relationship of the program structure.   STEP-3: Maintain Source Fields The Source Fields can be created using reference from the standard Structures   Note: It is mandatory to pass all the dates in the input structure.   It is recommended to use table Maintenance view [CTRL+F9] to create the source Fields.   STEP-4: Maintain Structure Relationships Assign the Source Structures to their Counterparts   STEP -5: Maintain Field Mapping For all the fields we want to pass to the program, map a corresponding field from the source Structure.    If the number of the fields to be mapped are more, it is recommended to use Auto Field Mapping Feature.   It is available at Extras -> Auto Field Mapping   STEP -6 : Maintain Fixed Values, translations, user Routines In this example we are not using any fixed values, translations or User Routines.   STEP -7: Specify Files Specify three Input files one each for each structure.   The Converted and Read File Names are automatically Created.   Double click on Converted Data.   In the Popup that opens, Enter Logical path and Logical File Name.   Note: For Creation of Logical Path and Logical File, Refer Appendix-A   STEP-8: Assign Files Assign a Input File to each of the Structures   Note: An Input File cannot be assigned to Multiple Structures   STEP- 9: Read Data Once you have placed the input data in the respective files in same format as the source structures, you can execute this step.   To get a sample input file you can execute Program: RVINVBT0.   It will give you a excel file with values for all fields in the standard Structures.  
We Need Your Support
Thank you for visiting our website and your interest in our free products and services. We are nonprofit website to share and download documents. To the running of this website, we need your help to support us.

Thanks to everyone for your continued support.

No, Thanks