Routine to populate 0GN_VENDOR in 0IC_C03 for 2lis_03_BX

[former_member296667]

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

[KodandaPani_KV]

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.

[former_member296667]

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

[KodandaPani_KV]

Hi,

can you explain which one you want output?

are you using the any rescrticitons on the venders.

-Phani.

[former_member296667]

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

[former_member71289]

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:

Consolidated InfoObjects for BP, Product and Product Category - Cross-application Master Data - SAP ...

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

[former_member296667]

Hi Andreas,

Thanks for the reply.

Multiple source system point clear however not clear on storage type and storage categories.

Regards