Using ZSA_D_FLDVAL in the SPM Extractor

[mani_chinnaiah]

We are trying to exclude certain GL accounts using table ZSA_D_FLDVAL while running the SPM Extractor obtained through SAP OSS Note 1239883. We have also referred to SAP Note No. 1774871 to poplulate the table by running a custom report so that we do not lose our leading zeroes.

After we run the extractor, we observed that the values that were required to be excluded were still included in the flat file generated by the extractor.

Any help in fixing this issue is appreciated.

[mbpatil99]

Hi Mani ,

As per your notes above , looks like you have correctly mantained the values in ZSA_D_FLDVAL table . Just double check and make sure you have the Project name correctly mantained , Object should be IVBSAK and IVBSIK for GL Account the field name has to be XARGLACC and Field value has to be the exact GL account number with the leading zeroes.

Example.

Project - ZXXX

Object - IVBSAK

Field Name - XARGLACC

Field Value - 0000100000

Now the most important thing after you mantain these entries is to generate the extractor using Z_SA_DEPD t-code.

Once the extractors are generated succesfully please go into the Extractor function module and make sure the below code is insterted for of the GL account exculuded.

IF WA_EXTR-ASAGLACC1 = '0000100000'.

      gv_assign = '' .

    ENDIF.

GV Assign has to be blank for each line item to be excluded from the extractor output.

Once this is done you can execute the extractor in RSA3 in Debug mode to validate if they are getting excluded correctly.

Hope this resolves your issue, let me know if you need more details.

Thanks

MJ