This Blog covers the technical steps to create Attribute Views ( Highlighted one in the below Model ).
Series 1:
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
5 | |
5 | |
5 | |
4 | |
4 | |
4 | |
4 | |
4 | |
3 | |
3 |