Skip to Content
Former Member
Jan 26, 2007 at 11:20 PM

Field name "SPERR" in LFA1 and LFB1


Hello - does anyone have any insight on how to bring in the field name "SPERR" into BW. For instance, it is not on the standard extractor that pulls from the table: LFA1, but it is on the standard extractor that pulls from table: LFB1. However, the field name "SPERR" has two completely different meanings depending on which table it is pulled from. So now my dilema is that our data in BW that is used for vendor master data reports, is completely mis-leading because it uses the "SPERR" from table: LFB1. Therefore, vendors in certain company codes are being reported as not having a posting block on them, but they actually do because they were blocked at the central level and not at the individual company code level. Is there any other solution other than adding "SPERR" to the extractor that pulls from table LFA1? I realize my question is vague however any insight would be greatly appreciated.

Thank you in advance!