cancel
Showing results for 
Search instead for 
Did you mean: 

Step by step loading of custom field in R3

Former Member
0 Kudos

Hello All,

New to this forum and the BW world looking for assistance. We have created a custom z field in R3 in table VBAP and would appreciate a step by step procedure in extracting the new field to load into an existing infocube used in bex reporting.

The new field is a customer promise date on the sales order line item level and we are currently loading the sales order line item through the LO cockpit using the 2LIS_11_VAITM extractor.

Any help would be appreciated.

Thanks,

Dave

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

Enhancement of DataSource:

Here is a good blog for the enhancement of your datasource:

Forum

Take also a look:

[Enhancing LO DataSource u2013 Step by Step|https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/b0af763b-066e-2910-a784-dc6731660f46]

After the enhancement you have to repicate the DataSource in your BW system.

If you don't want to reload cube when you insert your new field, take a look:

Steps to do (😞

1. You enhanced the datasource

2. you added some coding in the user exit to populate the new fields

3. you replicated the datasource

4. you added infoobjects to your infosource and mapped the new fields to the infoobjects in the transfer rules

5. you added the fields to your cube and you did the mapping from infosource to cube in the update rules

After that the new field is also available in bex query designer. You can use it in query.

Regards

Andreas

Former Member
0 Kudos

Thank you for your advice. Your links were very helpful and resolved my issue.

Regards,

Dave