268x 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.