Start the report Z1K_CONS_ESTO in PF1

 

Z1K_CONS_ESTO : initial screen

 

 

Select a variant or enter: 

  1. Company code
  2. Plant code
  3. Material code (materials linked to Material ledger)

  4. Material type : Z700 and Z707

  5. Valuation class : Z100, Z101, Z061 and Z053
  6. View : 

      • BEGINNING INVENTORY

      • CONSUMP

      • CONSUMP PRODUCTION

      • FINAL INVENTORY

      • PRODUCTION

      • RECEIPTS

      • RECEIPTS – PURCHASES

      • TRANSFER (ISSUE)

      • OTHERS RCPTS/CONSUMP
      • NOT ALLOCATED

Execute 

Enter the path & the name of the file to be created and click 

 

Click 

The report is displayed 

 

Open excel and look for the file you saved 

 

Click "yes" to open the file now

1. Choose Delimited

 2. Click next to get the next screen

 

 

 

 

 

3. Select Tab 

4. Select "Other" and enter “ | “

 5. Click finish to get the excel correctly align

 

The file is ready to use