IS-U and IDoc creation

[Former Member]

Hello everybody,

I need that the IS-U payment run creates a PAYEXT or DIRDEB Idoc with BaseType PEXR2002 ( I need this for in-house cash).

Anybody here who knows how to do this?

Thx

Thorsten

[Former Member · Accepted solution]

does really nobody know if this is possible?

[Former Member]

Hello,

Unlike F110, FPY1 does not create standard Idocs to send them to CFM. You need to have a separate development for it to send the Idocs. For that you need to put the info in one of the standard idoc structures <<any of the below>>

ACC_DOCUMENT01 Accounting: Posting

ACC_DOCUMENT02 Accounting: Posting

ACC_DOCUMENT03 Accounting: Posting

Hope this helps

Rgds

Rajendra

[Former Member]

and In-House Cash understand this structures?

How much effort is it to do this development?

[Former Member]

and In-House Cash understand this structures?

I'd say yes!!! infact we have used one of the strucutres to send Idocs to another SAP system <<global SAP System>>>

How much effort is it to do this development?

It depends on the complexity of your requirement. tentative efforts can be bt 15-20-25 days...

Hope this helps

Rgds

Rajendra

[Former Member]

25 days? wow

our requirement is to get a PAYEXT IDoc in basetype PEXR2002.

Or do you mean something else with requirement?

[Former Member]

of course you can put higher no of days...:)

I'm not aware of the functionality of what iDocs wud do after being send to CFM <like journal entry, updation of books etc>>

But I can tell what we have done @ our project. We had an ISU system. All the docs in FICA are sent to SAP FI-GL @ summary level using Standard SAP Program FPG1.

Then from SAP FI-GL we have sent the info to Group SAP FI-GL server on 1:1 basis i.e we have same set of GL Accounts in both the systems.

So if the entry in SAP FI-GL is

DR : Bank Clrng Acc <113100>

CR Main bank acc <113101>,

In Group SAP FI-GL the entry too wud be

DR : Bank Clrng Acc <113100>

CR Main bank acc <113101>,

This info we have sent through iDocs using standard iDoc strucutre ''ACC_DOCUMENT01''

Hope this helps.

Rgds

Rajendra

[Former Member]

Hi rejandra,

but you haven´t used it to send payments to the In House Cash Center?

We want to do this, but I have no idea what infos IHC needs to understand the IDoc.

[Former Member]

Yes Throsten we have not used iDocs to send Payments info to CFM!!...but we have send every thing <all monthly GL Info> to Group SAP system where upon our details are updated in their system.

You too can similarly send the info to CFM using one of the standard iDoc structures.

But before that one need to understand what all the info CFM expects from FPY1.

Usually in FPY1, payment details of the customer are present. The details are also available in the tables:

DPAYC Payment program - administrative records

DPAYD Payment Program - Payments (Check of Direct Debit Limit)

DPAYG Payment program - payment group

DPAYH Payment program - data for payment

DPAYN Sequential Number Assignment

DPAYP Payment program - data on paid item

DPAYV Payment program: Variants for payment medium and list

Bank details of the customers are available in

BUT0BK BP: Bank Details.

If you have correct info of what needs to be send to CFM from FPY1 run may be we can decide how it can be done.

Hope this helps.

Rgds

Rajendra

[Former Member]

Thx rajendra,

have you any idea where I do get this information?

Kind regards

Thorsten

[Former Member]

Thorsten,

You can get info using any of the following :

1. You speak with your business and collect what all info you need to send from FPY1 to CFM. Based on this, you can prepare High level design doc. Later during Low Level design, we can determine how this can be done.

2. If you are already sending info from F110 to CFM, you collect the info and see if at all you can send the same info from FPY1 to CFM.

Hope this helps

Rgds

Rajendra

[Former Member]

Hello rejandra,

at the moment we don´t have In House Cash.

We want to find out if we can use it in our concern.

So we don´t send anything to it at the moment.

[Former Member]

Ok.. got your point Thorsten... So you are in very initial stage of deciding. In that case what I feel is that you configure F110 Payment program as usual. Configure iDoc part of F110 too.

Assuming that your CFM for testing wud be ready, send iDocs from F110 and see how this gets posted in CFM. May be you can decide then.

Though this process seems lengthy, I see this is the only way.

Alternatively, you can put this post <<sending iDocs from F110 to CFM and how this gets posted in CFM>> either in Financials or CFM forums of SDN.

Hope this helps

Rgds

Rajendra

[Former Member]

Ok I could try this.

But our testsystem is not active at the moment.

We don´t want to do this convertion now, we only need to know if it is possible to make such a converter and how expensive it will be.

[Former Member]

hmm...cost wise I'm not too sure...but what all I can tell you is the config needed to generate iDoc from F110.

Here is the config.

Message types PAYEXT,EUPEXR,DIRBEB are the generated IDOC's from APP.

For IDOC to be generated from APP plz check the following.

1. Partner profile should be created and Valid Message types to be assigned to it.

2. Assign the above created Partner profile to the House bank in FBZP.

3. In House bank, specify the EDI compatible payment methos ( payment methods for which you want to generate iDoc's)

4.In Payment methods, assign Print programs if its for IDOC generation its RFFOEDI program.

5.Create a variant for the print program that is assigned above in the payment method

6. In APP based on the payment methods mentioned, their corresponding print programs will be populated(assigned in Step 4), for the same assign the variants created in step 5.

<<I assume that you have your FBZP config {F110 config} is already in place.

may be you need to sit with technical consultant too for iDocs.

Pls try this and if are able to generate iDocs to CFM, guess we'd have a picture.

Hope this helps.

Rgds

Rajendra

[Former Member]

Hello rajendra,

in F110 we already have created the IDocs in our testsystem.

It worked.

Now we need to do this for IS-U payment run.

[Former Member]

Great!! you need to use one of the standard iDoc structure as mentioned.

Hope this helps

Rgds

Rajendra

Pls assign points if found useful.

[Former Member]

Thersten,

I understand that after you send the IDoc info to SAP-Inhouse Cash, the entry/entries wud/cud be

DR: Subsidiary Bank

CR : Inhouse Cash Center

(OR) &

DR: Inhouse Cash Center

CR : House Bank

Another combination can be

DR: Subsidiary Bank

CR : Inhouse Cash Center

(OR) &

DR: Inhouse Cash Center

CR : Clearing Partner.

So while sending the IDocs to SAP Inhouse bank, you need to consider above entries & design the program accordingly.

But do remember that FYP1 entries usually wud be:

DR: Bank Clearing Account

CR: Contract Account

Below URL may be helpful to you

https://help.sap.com/saphelp_erp60_sp/helpdata/en/20/8ad8fa96494f16a8db9110234c855b/frameset.htm

Hope this helps

Rgds

Rajendra

[Former Member]

CR, DR?

that don´t say me anything

[Former Member]

Ok what I mean is

DR= Debit

CR = Credit

Field name is BSCHL in GL

Every accounting entry should have one debit &

one credit (-).

Hope this clarifies

Rgds

Rajendra

[Former Member]

you mean in the IDoc?

[Former Member]

yes!!! in the iDoc you need to send.DR/CR indicator.

for ex you need to include the following in your iDoc....

Field DRCRK

Field text Debit/Credit Indicator

table field DRCRK

Source GLPCT - DRCRK

Rgds

Rajendra

[Former Member]

why do you look so sad?

thank now i have understood what to integrate in the IDoc

thx

[Former Member]

Thanks..n..great....sending DR/CR indicator in the iDoc determines the Line Item entry in the target system. Hope this clarifies.

Rgds

Rajendra

Any points wud be motivating as I'm nearing 4 digits!!! Thankx for all u r points and hope I'm able to clarify your doubts.