This Blog covers the technical steps to create Analytic Views ( Highlighted one in the below Model ).
Series 1:
Series 2 :
This analytic view provides line item amount data and valuation differences for accounting documents.
The analytic view provides an aggregated view on purchase volume per vendor, country, business year, company code, and purchase organization.
1. Select package, Click NEW -Create New Analytical View & give technical name details.
2. As a result you should see below screen.
3. Drag & drop BSIK table in to Data Foundation.
Navigate to your package, expand the folder and select the attribute views for Vendor , Vendor Company Code & Vendor Purchase ORG drop in to Logical Join.
4. Select Data Foundation, In the details screen, select below listed columns, Right Click > Add to Output.
MANDT
BUKRS
LIFNR
GJAHR
WAERS
ZTERM
DMBTR
5. Join below Columns from Data foundation to Attribute Views.
6. Final Steps.
--------------------------------------------------------------
This analytic view is used to select materials that are supplied by vendors.
1. Select package, Click NEW - Create New Analytical View.
2. As a result you should see below screen.
3. Drag & drop EINA table in to Data Foundation.
Navigate to your package, expand the folder and select the attribute views for Material and Vendor and drop in to Logical Join.
4. Select Data Foundation , In the details screen, select below listed columns, Right Click > Add to Output.
MANDT
LIFNR
MATNR
IDNLF
WGLIF
LTSNR
MFRNR
5. As a result you should see Data Foundation Filled with Columns.
6. Join below Columns from Data foundation to Attribute Views.
Another Blog on Analytic Views.
Thanks for you time..
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
37 | |
10 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
2 | |
2 |