SAP HANA Information Models for Master Data ( Attribute View) Series_1
This Blog covers the technical steps to create Attribute Views ( Highlighted one in the below Model ).
Few Blogs on Attribute Views
http://scn.sap.com/community/hana-in-memory/blog/2013/04/19/sap-hana-information-models-for-fianance
SAP HANA Information Model for Master Data
Attribute View for COMPANY CODE DATA FOR VENDOR
This attribute view provides company code data for a vendor, It also supplies the corresponding descriptions.
Below are SAP tables are used to create this attribute.
1. Select your package. Right Click à New Attribute View & Give name details.
2. Drag & drop below tables in to Data Foundation.
LFB1
LFA1
T001
3. In the details screen, select below listed columns, Right Click > Add to Output.
LIFNR
Vendor, MANDT, BUKRS, SPERR, ZTERM, VZSKZ, ZWELS, EIKTO, FDGRV, DATLZ, ZINRT,
ZINDT, ZGRUP (LFB1 Tables)
NAME1 (LFA1 Table)
WAERS, BUTXT ( T001 Table)
4. Connect MANDT & BUKRS (LFB1) to MANDT & BUKRS (T001), In the properties select join type as Inner Join, & Cardinality as N:1.
Continue for below join,
LFA1 |
inner |
LIFNR MANDT |
|
LFB1 |
LIFNR MANDT |
5. Final Steps.
———————————————————————————
Attribute View for VENDOR PURCHASE ORGANISATION
This attribute view provides purchasing organization data for a vendor. It also supplies the corresponding descriptions
Below are SAP tables are used to create this attribute.
1. Select your package, Right Click , New Attribute View & Give name details.
2. As a result you will see below screen.
3. Drag & drop below tables in to Data Foundation.
LFA1
LFM1
T024E
4. In the details screen, select NAME1(LFA1) & Right Click > Add to Output.
Continue for below columns from the respective tables.
INCO1, XNBWY , BOPNR , WEBRE, BSTAE, LEBRE, LIND, WAERS,EIKTO, SPERM, PRFRE, MEGRU, RDPRF, LISER ,
XERSY, VERKF, KZAUT, INCO2, EXPVZ, VSBED, PAPRF, LFRHY, NRGEW (LFM1 Table).
5. Connect MANDT & LIFNR (LFA1) to MANDT & LIFNT (LFM1), In the properties select join type as Left Outer Join, & Cardinality as N:1.
6.Connect MANDT & EKORG (LFA1) to MANDT & EKORG (T024E), In the properties select join type as Left Outer Join, & Cardinality as N:1.
7. Final Steps.
Series 2 :