STEP 1

Start the report Z1K_CONS_ESTO in PF1


Z1K_CONS_ESTO : initial screen





STEP 2

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 



STEP 3

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


Click 



STEP 4

The report is displayed 




STEP 5

Open excel and look for the file you saved 


Click "yes" to open the file now



STEP 6

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




STEP 7

The file is ready to use