SAP HANA Information Models for Master Data ( Attribute View) Series_2
This Blog covers the technical steps to create Attribute Views ( Highlighted one in the below Model ).
Series 1:
SAP HANA Information Model for Master Data
Attribute View for VENDOR
This attribute view provides company code data for a vendor, It also supplies the corresponding descriptions also.
Below are SAP tables 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.
LFA1
T005U
T005T
T077Y
3. In the details screen, select below listed columns, Right Click > Add to Output.
MANDT,LIFNR,KTOKK,KUNNR,COUNTRY,STREET,TITLE,NAME1,CITY1,REGION (LFA1 Table)
T077Y.TXT30
T005T.LANDX
T005U.BEZEI
4. Connect MANDT , LAND1 & REGIO (LFA1) to MANDT , LAND1 & BLAND (T005U), In the properties select join type as Text Join, , Language as SPRAS & Cardinality as 1:1.
5. Connect MANDT , LAND1 (LFA1) to MANDT , LAND1 (T005T), In the properties select join type as Text Join, , Language as SPRAS & Cardinality as 1:1.
6. Final Steps.
Series 3
Thanks for posting this.
Slight amendement, below are the actual field names:
LAND1 = COUNTRY,
???=STREET,
POSTL=TITLE,
NAME1=NAME1,
ORT01=CITY1,
REGIO=REGION
BR
MD