on 2015 Mar 28 7:54 PM
Hi Team,
Need to know the logic behind the routine to populate 0GN_VEENDOR.
Source fields -
0GN_R3_SSY | @81@ | Source System for R/3 Entity | CHAR | 2 | SORSY |
0STOCKCAT | @81@ | Stock Categories | CHAR | 1 |
0STOCKTYPE | @81@ | Stock type | CHAR | 1 |
0VENDOR | @81@ | Vendor | CHAR | 10 | ALPHA |
Target field -
0GN_VENDOR | @81@ | Vendor | CHAR | 60 |
Regards
Hi,
Map the all fields to to target filed - 0GN_VENDOR
If Source_fields- 0GN_R3_SSY and
Source_fields-/0STOCKCAT and
Source_fields- 0STOCKTYPE
Source_fields- 0VENDOR and
0GN_VENDOR
endif.
endif.
Result = 0GN_VENDOR.
-Phani.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Phani,
Thanks for the reply.
What i mean to ask is in terms of functional side.
For e.g.Stock category,stock type would give us wheather stock is consignment stock,blocked stock,quality inspection stock etc...
But why have they mapped it to vendor,what are they trying to achieve.Also why have they introduced 0GN_R3_SSY field.
Suppose we have Price 1 and Price 2 and we want to display total in target.So we map Price 1 and Price 2 to total in target and apply formula.
In same way what is the logic behind vendor.
Regards
Hi Phani,
This is rule group in transformation.
In standard BI content
Source fields -
0GN_R3_SSY | @81@ | Source System for R/3 Entity | CHAR | 2 | SORSY |
0STOCKCAT | @81@ | Stock Categories | CHAR | 1 |
0STOCKTYPE | @81@ | Stock type | CHAR | 1 |
0VENDOR | @81@ | Vendor | CHAR | 10 | ALPHA |
Target field -
0GN_VENDOR | @81@ | Vendor | CHAR | 60 |
My question is why haven't they mapped 0VENDOR from source field directly to 0GN_VENDOR target field.
Regards
Hi Anmol,
0GN_VENDOR is a consolidated InfoObject that is helpful e.g. when you have multiple source systems connected. Therefore 0VENDOR is coumpounded with the 2 digit source system of the connected source system when loading into 0GN_VENDOR.
You can find more information and features about the consolidated info objects here:
If you have only one source system and you do not want to use other features of the consolidated InfoObject (like grouping vendor ID's for reporting), you can also replace 0GN_VENDOR by 0VENDOR in the cube.
This will of course simplify the transformation rule for this field, but you still will need to consider the different stock categories and stock types when updating vendor as it is defined in the BI content transformation.
Hope this explains it.
Best regards,
Andreas
User | Count |
---|---|
69 | |
8 | |
8 | |
7 | |
7 | |
6 | |
6 | |
6 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.