ICR - Importing File for process 003 + 001

[Former Member]

Hello sap colleagues,

We have an issue with ICR and I hope someone can give me a hand with it.

We have included process 001 into process 003.

Now we are working in the definition of the file structure so that companies from outside the reconciliation system can send us their documents.

According to what we have read so far, we understand that if ATYPE is C, the account will go to the field RCUST and if ATYPE is V it will go to the field RVEND.

Our problem is, What do we do with the GL Accounts Open Items coming from process 001? Which account type shall we use so that when we import the file the system knows is a GL Account and not a Vendor or a Customer?

We have tried to leave it blank and it doesn't do anything.

We have also tried to enter ATYPE = G and it doesn't do anything either (er read this in a SAP Note).

We saw another post where it says the GL Accounts go to the field RCUST but it doesn't work.

Also, does field HKONT or RACCT has to be added to the ICR tables for Process 003?

Coudl anyone please tell me how to do it? We a bit desperate to make it work...

Any help will be very much appreciated.

Thanks in advance

Regards

Isabel

[former_member572578 · Accepted solution]

Hello Isabel,

It really depends on what you want to do with the information "account number"...

If you want to differentiate between receivables and payables for G/L open items - do you want to do that based on the account number of based on the amount (positive / negative)?

What object groups do you currently use and how are they set up?

I'll give you some examples of what you can do - assuming you use the standard setup with object groups "Payables" and "Receivables" with "Payables" defined as RVEND > SPACE and "Receivables" defined as RCUST > SPACE.

Minimalistic approach:

Define your upload structure so that the column is uploaded as field RCUST - now the GL account number will be in the field RCUST and all uploaded G/L OIs will be treated as receivables (if you even differentiate between payables and receivables in FBICR3; if you just have one object group "Open Items" then this is not really an issue). If you upload as RVEND, everything will be treated as payables.

Distinguishing between AP and AR:

Define your upload structure so that the column is uploaded as field RCUST. Then implement BADI method CHANGE_DATA_TABLE for event '8' to implement whatever logic you would like to use in order to distinguish between AP and AR. You must have note 1475612 implemented for this event to be used. Then fill fields RVEND and RCUST accordingly. Just make sure that in the end you don't have both RCUST and RVEND filled... You could also prefix the account number with a 'G' so you can see that this is not really a customer/vendor account number but the integrated GL account number.

If you want to have the unmodified GL account number available in ICR process 003 you should add RACCT as a custom field. Then you can also upload the GL account number into that field and then fill RCUST / RVEND according to your requirements and still have RACCT available to display in FBICR3.

Hope this helps

Ralph

[Former Member · Accepted solution]

Hi Ralph, do you have any documentation on how to configure the import of a flat file from a legacy SAP system to the ICR 003? For example file layout, fields, ddl names and so on?

I could not find anything specific on this part. I would like to start importing only customers/vendors postings and then in the future add some g/l accounts.

Please let me know.

Than you, Vito

[former_member572578 · Accepted solution]

Hello Vito,

As long as your SAP sender system is on a release >= 46C you can load the data via RFC and don't have to worry about using flat file uploads...

Are your SAP systems older than that?

Ralph

[Former Member · Accepted solution]

Good morning Ralph. The two SAP systems are not older than that but the problem is that master data (gl accounts, PC, CC, vendors and customers) and company/company codes are different. For example Company in legacy is 9999 and is SAP is now USxx. So data needs to be mapped before being loaded. That is why I was thinking about a flat file.

Vito

[former_member572578 · Accepted solution]

Hello Vito,

You can implement mapping in BADIs as well. Otherwise you will have to perform the mapping in the program which creates the files... So you might as well try to go for as much automation as possible and implement BADIs instead. An example implementation is delivered with CL_IM_FB_ICRC_001->MAP_COMPANY_IDS. You would only have to maintain the mapping and implement the BADI in the ICR system. The sender system would remain completely unaffected.

Company codes are pretty much irrelevant. You can just take whatever the company code is in the sender system. The only thing that is a bit difficult is the company ID and the partner ID.

Of course you can also create a process to create a flat file. But then you will end up with various manual steps (create file, upload file / put it in the correct directory, ...).

Ralph

[Former Member · Accepted solution]

Hi Ralph, thank you for the reply.

I need to demonstrate the feasibility so the easiest and fastest way would be to create a file and upload it.

Do you have the file layout so I could use it? Also is there any documentation on what is the set up in the receiving system for uploading the file?

The SAP legacy will go away so I do not know if it is worth to set up the RFC and no development is done to the SAP legacy.

I was thinking to extract BSIK and BSID, map the file to the current SAP master data and then upload it.

Thank you, Vito

[former_member572578 · Accepted solution]

Hello Vito,

You just need to figure out which fields in FBICRC003A you want to fill and create a DDIC structure with corresponding field names. The order of the fields in the structure corresponds with the order of the columns in your file.

I suggest you copy the structure FBICRC_S_UPLOAD (as mentioned in the F1 documentation for the field DDIC Structure for Upload in the corresponding IMG activity - Tx FBIC032 for process 003), and add at least the field REFNR with type FB_ICRC_REFNR.

You need to fill ATYPE with 'C' (customer) or 'V' (vendor) depending on which type of data records you want to upload. Alternatively you could create a structure with the fields RCUST and RVEND and then just fill the columns accordingly. If you want to upload other information about the items, just look at the structure of FBICRC003A, include the fields in the structure, and create your download file accordingly...

As for documentation - all you need to do is create an entry for the company. I suggest that you always use the same SEQNR based on the data source (e.g. 0 - 199 for AR/AP, 200 - 299 for GL open items, 300 - 399 for upload)... You select File Upload as the Document Source, and sepcify the DDIC structure. You can provide a logical file name or you can just choose a file on your presentation server when you run FBICS3. That's really all the "preparation" you need to do. Now you just run data selection for that company and SEQNR, choose the file and it will post the data to the line items table...

Ralph

[Former Member · Accepted solution]

Hi Ralph, I used the structure FBICRC_S_UPLOAD to test my config. I will create a new DDIC will all the required data once the process will be approved.

The load worked but what table is update? I do not see the data in FBICRC003A.

[former_member572578 · Accepted solution]

Hello Vito,

Did you specify the account type in the file?

Make sure the following notes are applied:

• 1475612
• 1749312
• 1651384
• 1806114
• 1940593
• 1270782
• 1700577

Ralph

[Former Member · Accepted solution]

Hi Ralph, I think I did not explain myself too clearly.

I created a flat file, I ran FBICS3 to upload the file and it worked fine.

I then ran FBICA3 and FBICR3. The file I uploaded is showing so everything looks to work fine.

I was wondering what is the table that FBICS3 is using to store the flat file data.

But I can see them in FBICRC003A.

[former_member572578 · Accepted solution]

OK - that makes more sense now. In your previous post you wrote that it worked fine but you could not see data records in FBICRC003A...

[Former Member · Accepted solution]

Good morning Ralph, I am running FBICR3 and get a dump when I try to display the open items. Everything works fine, FBICS3 runs fine, FBICA3 runs fine and FBICR3 runs fine till I try to open the open items. Table FBICRC003A is updated and table FBICRC003T is updated but I get a dump.

If you cannot see the attached file the short text of the dump says: CREATE DATA: The specified type"LFBICRC_S_DISPLAY_003_ASSIGNED" is no valid.

Any idea of this can be?

[former_member572578 · Accepted solution]

Hello Vito,

In FBRC007 you specified an incorrect structure for process 003 in column Assigned Items. The correct structure name is FBICRC_S_DISPLAY_003_ASSIGNED. You need to delete the "L" at the beginning of the structure name.

Ralph

P.S.: If you have another question I suggest you reply to one of the "higher" posts. The indentation at this point is getting to be a bit much...

[Former Member · Accepted solution]

Hi Ralph. I am trying to use process 003 with process 001 excluding some G/L accounts from FBICR3. My display should have one line for Payables and receivables and one for G/L open items (these accounts are BS accounts used for intercompany but not vendors/customers).

At the moment I get the following results on 3 lines:

1) Payables and receivables open items

2) G/L open items (I selected only one g/l account for test)

3) Data Records not Contained in any category (these are g/l accounts that are excluded for my selection)

I defined 3 sets: 1 for g/l accounts, 1 for payables and 1 for receivables.

The set for g/l accounts has data = RACCT, text table = FBICRC003A

FBRC009 has 2 obj group, 1 for G/L open items and 1 for Payables and receivables.

In the obj group for g/l I cannot use RACCT (this was added and custom field for process 003) as it is not available so I use RCUST.

Now I would not like to see in FBICR3 the line for the Data Records not contained in....Is there a way to exclude that line form FBICR3?

The G/L open items have the G/L account in the columns RACCT and RCUST while the G/L number is blank. Is there a way to have the G/L number in the right colums and have RCUST blank?

Is there anything that I am doing wrong?

Please let me know.

Thanks, Vito

[former_member572578 · Accepted solution]

Hello Vito,

#1 You can only use fields defined on level "Total Items: Subassignment" in definition of object groups.

#2 Object group "Data Records Not Contained in Any Category" collects all data records which could not be assigned to any existing object group based on your settings. So either you have data in ICR that you don't want there (issue with data selection) or you didn't set up your object groups correctly.

#3 Please note that the data element you specify in the set definition only affects field length and input/output conversion. If you specified RCUST as the reference field in object group maintenance then the set is applied to that field.

HTH,

Ralph

[Former Member · Accepted solution]

Hi Ralph, I have RACCT and SAKNR defined as Total Items: Subassignment.Now I can see and select them in FBRC009.
However the G/L account number is in RACCT and RCUST. Why is it going to RCUST?

Now when I display with FBICR3 the G/L accounts have both receivable/payables and the other G/L accounts.

I have 3 sets created but the set for G/L accounts have receivables/payables and G/L accounts.

Any Idea?

[former_member572578 · Accepted solution]

Hello Vito,

As explained in the documentation the default logic is that RCCT will be copied to RCUST. If you want something else to happen, you need to implement this in a BADI method - usually CONVERT_DATA_FROM_001.

The data records show up in both object groups because RCUST and RACCT are filled.

Best regards,

Ralph

[Former Member · Accepted solution]

Hi Ralph. I have a question about the Communication status. I have configured the system to send email and the Communication Status is updated and the email icon is shown. So this is working fine.

However, when I reply to the email sent the Processing Status is not updated.

Is there a workflow that needs to be activated? Or a BADi that needs to be implemented?

I can change the Processing Status manually as I did not check the flag "Status Cannot Be Set Manually".

Please let me know.

Thank you, Vito

[former_member572578 · Accepted solution]

Hello Vito,

This question is completely unrelated to this thread "ICR - Importing File for process 003 + 001". Please create a new thread.

Best regards,

Ralph

[Former Member]

Hi Ralph !

Thanks a lot for all your help regarding ICR issues....

Would it be possible for you to have a look at the message I posted one week ago called "ICR - Add fields to table FBRC0020"?

I really need to know how to add GL Account fields for process 003 in Objects Groups and Subgroups transaction and I have tried everything I know.

Thanks a lot again.

Regards

Isabel

[former_member572578]

Hello Isabel,

Sorry - I didn't see the other post before. I replied there...

You probably forgot to save the new entries in view maintenance (FBRC008).

Ralph

[former_member572578]

P.S.: Your original question is still marked as "not answered". Is there still an open issue with your original question?

[ravi_89]

Hi Isabel,

I am not sure abt this as we are using only process 003.
Can you try with ACTYPE = S.
See if it works.

Best Regards,
Ravi

[Former Member]

Hi Ravi,

Thanks for your suggestion but it doesn't work.  😞

Regards

Isabel