Wrong Values for DMBTR from MSEG table in 2lis_03_bf extractor.

[Former Member]

Hi Experts,

We have an issue with BW extractor. BW Extractor 2lis_03_bf is pulling 0 (zero) amount for field DMBTR from MSEG table. Hope SAP is changing this value some where while filling the setup tables. There should be some logic here. There is some value for this Field in MSEG table.

Please let me know if you had faced the same issue before. Also, Can you please give me where this DMBTR is bieng calculated.

Please let me know if there are any SAP Notes for this issue.

THanks

RK

[Former Member]

Hi RK,

Please check that Industry sector is set. we also faced the same issue and found that industry sector was set to NONE.

PAth:

sbiw -> settings for appl. specific Datasource (PI) -> Logistics -> Settings : Inventory Controlling -> Determine Industry Secto (Execute).

Set this to standard. and try data extraction hope u wil get values for DMBTR.

Regards,

Dipika

[Former Member]

Hey can you please confirm whether u worked for hp chennai in 2007 ???

[Former Member]

Hi ,

You can check the following notes for the issue :

1. 555488 - BW purchase order with account assignment: No data

2. 458676 - Enhancing extractors with AFS-specific fields

Regards,

Lokesh

[Former Member]

Thanks a lot Lokesh,

When I debugged while filling the setup tables, we found that SAP is converting the value of DMBTR in MSEG table to ZERO, Here is the code in program

In LMCB1F20 we can find where SAP is changing the value to ZERO when WERTU is Blank.

IF xmcmseg-wertu IS INITIAL.

• Keine Wertfortschreibung

IF xmcmseg-bstaus NE 'V' AND xmcmseg-bsttyp NE 'V'.

xmcmseg-dmbtr = 0.

ENDIF.

ELSEIF xmcmseg-dmbtr IS INITIAL.

SELECT SINGLE * FROM tcurm.

IF sy-subrc = 0 AND NOT tcurm-bwkrs_cus = '1'.

• Nur bewerteter Bestand

IF xmcmseg-sobkz = space OR xmcmseg-sobkz = o OR

xmcmseg-sobkz = v OR xmcmseg-sobkz = w.

PERFORM dmbtr_ergaenzen.

ENDIF.

Can you please let me know if you have come across this issue.

[Former Member]

Hey can you please confirm whether u worked for hp chennai in 2007 ???

[former_member222556]

Hi,

Check the value in RSA3 for that fields (LC Amount).

if not getting the value, then

-->LBWE Schedule the job (Immediate) for Filling Setup table and then after completion of this job

-->check it again in RSA3

Best Regards

Obaid