Stock Location Transfer - Internal Warehouse Management

[Former Member]

Dear colleagues,

I'm looking for answer regarding Stock Location Transfer Report in the topics below:

>* ECC Field, Field Names, Data Source and Comment.*

In exemple:

Report Field / ECC Field / Field / Data Source / Comment

Warehouse Code / Plant / WERKS / 2LIS_03_BF / 0PLANT

Report Field

- UID

- Shift

- Datetime of Transfer Begin

- Datetime of Transfer Completion

- Model ID

- Material ID

- Description

- Origin Location

- Destination Location

- Units Transferred

- Cube

- Transfer Time Hours

Thanks in advance,

Best Regards,

Elvio.

[Private_Member_101989]

Hello,

You can check this:

http://help.sap.com/saphelp_nw04s/helpdata/en/1d/f07037a2cb2473e10000009b38f8cf/frameset.htm

It got all the queries of Inventory Management, the query that you are looking for is Stock in Transit (0ic_c03_q0008), but you have to enhance the fields that don't exist in the query.

Regards,

Jorge Diogo

[former_member189406]

Hi,

As per my understanding, you need the below fields to be included / enhanced in the 2LIS_03_BF datasource.

- UID

- Shift

- Datetime of Transfer Begin

- Datetime of Transfer Completion

- Model ID

- Material ID

- Description

- Origin Location

- Destination Location

- Units Transferred

- Cube

- Transfer Time Hours

STEPS :

Goto LBWE transaction in R/3.

Goto the 2LIS_03_BF datasource and click on Maintenance.

A popup window will be displayed.

Search for the above fields, in the Right pool List If they are available, then add it to the Left pane.

Save and activate.

If some of the fields are not present, then identify from which table these fields needs to be fetched.

Goto RSA6 and search for 2LIS_03_BF datasource.

Click on Append Structure and add the fields that you need (Starting with ZZ or YY) Then goto SE38 --> ZXRSAU01 program and write the code to populate the data from the tables corresponding to those fields.

Save and Activate.

Then do a sample extraction and check.

Regards,

Balaji V