Urgent-Transformation Routine Sample code

[Former Member]

Hi Experts,

I have a custom cube which is being fed by FI_GL(ODS),Material Movements Cube,and Purchasing Cube(OPUR_C01).

In my Custom Cube,

1) need some chars and all the KF's from ODS.

2) need only 0Batch and 0vendor from MM cube.No KF's from MM Cube

3) need only Req Tracking Number(BEDNR) and outline agreement(KONNR)

fields from Purchasing cube.No KF's from Puchasing Cube.

How should i go about it this req?I am pretty new to ABAP.Please help me with this solution or with some helpful code.

Thanks in advance

[Former Member · Accepted solution]

Sample code from 2LIS_02_SCL -> 0PUR_O01 for a key figure (ODS):

IF ( SOURCE_FIELDS-BWVORG = '001' or "Bestellu *ng

SOURCE_FIELDS-BWVORG = '011' or

SOURCE_FIELDS-BWVORG = '021' or

SOURCE_FIELDS-BWVORG = '004' or "LP

SOURCE_FIELDS-BWVORG = '014' or

SOURCE_FIELDS-BWVORG = '024' )

AND SOURCE_FIELDS-BWAPPLNM EQ 'MM'.

RESULT = SOURCE_FIELDS-J_3ANETW.

endif.

Use DIRECT assignment for KONNR -> 0CONTRACT

If helpful, please assign points.

Regards,

Alex

[Former Member · Accepted solution]

Hi Alex,

Thanks for the sample code.It would be very helpful for me if you could tell me what its actually doing.As i am pretty new to ABAP.

Thanks in advance

[Former Member · Accepted solution]

In this example: BWVORG represents the process key (which you can read more on in SAP Note 684465). It is check to be sure the document type is a Purchase order (001), transport order (011), cross company order (021), or Scheduling agreement of some sort. Then it just posts the RESULT to the Key figure in the routine (in this case J_3ANETW represents a net value)...