Data in RSA3 and not in PSA (checked authorizations and datasource definitions)

[Former Member]

Added some fields (some are Z and other standard) to 0CO_OM_CCA_9 that are references to FI documents.

The problem is that I get the data for 0ACDOC_IT_F (line item) but not 0ACDOC_NO_F (document number).

Also get data for document type but not the document date and posting date.

In RSA3 the extractor retrieves the data.

I already unhide every field, check the ALEREMOTE authorizations, replicate datasource and activated transfer rules several times.

Searched in the forum but tried all this solutions mentioned before.

Could it have anything to do with using Referenced Characteristics?

Excess fields?

Other ALEREMOTE or RFCUSER configuration?

Enhancing too much the datasource?

Fields ok (green) a Not ok (red):

ZCO_BUSTR	Reference Business Transaction
0ACDOC_NO_F	FI Document
0ACDOC_ITEM_F	FI Line Item
0AC_DOC_TYP	FI Document Type
ZAC_ITEMT	FI Line item text
ZAC_PSTGD	FI Document Posting Date	0PSTNG_DATE
ZAC_DOCDT	FI Document Date	0DOC_DATE
ZCO_VENDR	Vendor	0VENDOR
ZCO_CUSTM	Customer	0CUSTOMER
ZUNIT	Posted Unit of Measure

Thank you in advance

[Former Member · Accepted solution]

Did you replicate datasource from bw side? This fields available in data-source, but come empty from source system?

[Former Member · Accepted solution]

Yes. It's a a data populating problem.

Looks like just calculated/complex fields don't come to BW. that's why there's no problem with 0AC_DOC_TYPE, it's assigned directly in the exit.

But need to check this.

The fields, at RSA2/6, are all type "P" maybe I should try a different one like "3", no?

[Former Member · Accepted solution]

What did you mean by type "P" or "3"? Where did you see this?

Did you check ALEREMOTE authorization in both source and BW systems?

Check in sm59, maybe another user (not ALEREMOTE) is used for connection (from BW to source or from source to BW)?

Check this threads:

http://scn.sap.com/thread/1970257(there is some OSS note about that, maybe you need to patch you systems)

http://scn.sap.com/thread/1461459 (try to increase package size)

[Former Member · Accepted solution]

And also check authorization for BWREMOTE user in BW.

[Former Member · Accepted solution]

In fact it's another user on SM59:

ECC - BI2ABAP - S_BI-WX_RFC

BW - ABAP2BI - S_BI-WHM_RFC; S_BI-WX_RFC

The ALEREMOTE users have also the same authorization.

There's no BWREMOTE.

I'll answer the other points right away.

[Former Member · Accepted solution]

Maybe try givving them SAP_ALL temporary. To know exactly this is not authorization problem.

BWREMOTE is typically user for background processing in BW. Try creating from here:

SAP Customizing Implementation Guide-SAP NetWeaver-Business Intelligence-Automated Processes-Create User for Background Processes. There is some instructions about this step:

"The user for background processes (BWREMOTE user) is used for data extraction, among other things. It is entered in the destination on the source system. The system asks for a background user password when connecting to the source system.

Activities

Maintain a background user in the user master record with a password and authorizations. The ALE user has to have profile S_BI-WHM_RFC.

For a detailed list of all required authorizations, see SAP Note 150315 on the SAP Service Marketplace."

I'm not sure this helps you, but try.

[Former Member · Accepted solution]

Type "P" thing you can see it on RSA2 tab fields. Added image to this thread.

[Former Member · Accepted solution]

OK I`ll try that.

Also checked that, in RSA3, if I put the destination (BWD client) the extractor gives me the same issue.

So in RSA3 withou destintation, I get data, with the BWD destination only some fields are populated.

[Former Member · Accepted solution]

Try authorization test in sm59 from source system to BW.

[Former Member · Accepted solution]

I had already done that, it`s ok.

On the BW side should the DEV_Dialog have a user?

[Former Member · Accepted solution]

No, dialog connections is without user (you must logon every time to that systems).

[Former Member · Accepted solution]

Anton, I decided to do the extractor debug and noticed that the fields needed to do the calculations to the ones enhanced weren't "displayed" on the BW side (this happens because those fields have routine in standard transfer rules). So, on the datasource tab in transfer rules just checked this fields and now it's OK.

Very stupid erro, sorry. And thank you for your support.

[Former Member · Accepted solution]

The main thing is that you solve problem ).