427x Filetype XLSX File size 0.31 MB Source: hservers.org
Sheet 1: BW Report
| Sales Order Quantity and Value | |||||||||||
| Customer | Month | Year | Order Qty | Base Unit | Order Value | Currency | Slice & Dice Chars | Variables | |||
| ABC | Jan.2020 | 2020 | 83 | KG | 4887 | USD | Material | SalesOrg | |||
| ABC | Feb.2021 | 2021 | 142 | KG | 8127 | USD | SalesOrg | Distr Channel | |||
| ABC | Feb.2020 | 2020 | 61 | KG | 7794 | USD | Distr Channel | Division | |||
| ABC | Jan.2021 | 2021 | 171 | KG | 14474 | USD | Division | Company Code | |||
| ABC | Feb.2019 | 2019 | 118 | KG | 7284 | USD | Company Code | ||||
| ABC | Feb.2018 | 2018 | 117 | KG | 12730 | USD | Customer Exit Variables | ||||
| ABC | Jan.2022 | 2022 | 53 | KG | 17102 | USD | HANA Exit Variables | AMDP | |||
| ABC | Feb.2017 | 2017 | 160 | KG | 10559 | USD | |||||
| ABC | Feb.2016 | 2016 | 55 | KG | 9446 | USD | |||||
| ABC | Jan.2023 | 2023 | 194 | KG | 5596 | USD | |||||
| Sales Orders | Slice & Dice Chars | Variables | |||||||||
| Customer | Month | Year | No of Orders | Material | SalesOrg | ||||||
| ABC | Jan.2020 | 2020 | 83 | SalesOrg | Distr Channel | ||||||
| ABC | Feb.2021 | 2021 | 142 | Distr Channel | Division | ||||||
| ABC | Feb.2020 | 2020 | 61 | Division | Company Code | ||||||
| ABC | Jan.2021 | 2021 | 171 | Company Code | |||||||
| ABC | Feb.2019 | 2019 | 118 | ||||||||
| ABC | Feb.2018 | 2018 | 117 | ||||||||
| ABC | Jan.2022 | 2022 | 53 | ||||||||
| ABC | Feb.2017 | 2017 | 160 | ||||||||
| ABC | Feb.2016 | 2016 | 55 | ||||||||
| ABC | Jan.2023 | 2023 | 194 | ||||||||
| Sales Header - Fields | InfoObjects | ||
| ROCANCEL | Indicator: Cancel Data Record | 0RECORDMODE | |
| VBELN | Sales and Distribution Document Number | 0DOC_NUMBER | |
| AUART | Sales Document Type | 0DOC_TYPE | |
| BUKRS | Company Code | 0COMP_CODE | |
| KUNNR | Sold-To Party | 0SOLD_TO | |
| AUGRU | Order Reason | 0ORD_REASON | |
| LAND1 | Country Key | 0COUNTRY | Enhancement |
| NAME1 | Name | 0NAME1 | Enhancement |
| PERIV | Fiscal Year Variant | 0FISCVARNT | |
| VBTYP | SD Document Category | 0IMODOCCAT | |
| VDATU | Requested Delivery Date | 0REQ_DATE | |
| ERDAT | Date on which the record was created | 0CREATEDON | |
| VKORG | Sales Organization | 0SALESORG | |
| SPARA | Division for order header | 0DIV_HEAD | |
| VTWEG | Distribution Channel | 0DISTR_CHAN | |
| WAERK | SD document currency | 0DOC_CURRCY | |
| ANZAU | Number of Orders | 0SO_H_CNT | |
| ZD_ISHDR | ||||||||||
| 0RECORDMODE | ||||||||||
| 0STORNO | ||||||||||
| 0DOC_NUMBER | ||||||||||
| 0DOC_TYPE | ||||||||||
| 0COMP_CODE | ||||||||||
| 0SOLD_TO | ||||||||||
| 0ORD_REASON | ||||||||||
| 0COUNTRY | ||||||||||
| 0NAME | ||||||||||
| 0FISCVARNT | ||||||||||
| 0IMODOCCAT | ||||||||||
| 0REQ_DATE | ||||||||||
| 0CREATEDON | ||||||||||
| 0SALESORG | ||||||||||
| 0DIV_HEAD | ||||||||||
| 0DISTR_CHAN | ||||||||||
| 0DOC_CURRCY | ||||||||||
| 0SO_H_CNT | ||||||||||
no reviews yet
Please Login to review.