jagomart
digital resources
picture1_Excel Sheet Download 31477 | 5 Sales Hdr And Item   Datasource Fields


 268x       Filetype XLSX       File size 0.31 MB       Source: hservers.org


File: Excel Sheet Download 31477 | 5 Sales Hdr And Item Datasource Fields
sheet 1 bw report sales order quantity and value customer month year order qty base unit order value currency slice amp dice chars variables abc jan2020 2020 83 kg 4887 ...

icon picture XLSX Filetype Excel XLSX | Posted on 08 Aug 2022 | 3 years ago
Partial file snippet.
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








Sheet 2: DS - Sales Header
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

Sheet 3: InfoSource - ZD_ISHDR
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





The words contained in this file might help you see if this file matches what you are looking for:

...Sheet bw report sales order quantity and value customer month year qty base unit currency slice amp dice chars variables abc jan kg usd material salesorg feb distr channel division company code exit hana amdp orders no of ds header fields infoobjects rocancel indicator cancel data record recordmode vbeln distribution document number doc auart type bukrs comp kunnr soldto party sold to augru reason ord land country key enhancement name periv fiscal variant fiscvarnt vbtyp sd category imodoccat vdatu requested delivery date req erdat on which the was created createdon vkorg organization spara for div head vtweg chan waerk currcy anzau so h cnt infosource zd ishdr storno...

no reviews yet
Please Login to review.