DME file format HDFC bank

[Former Member]

Hi SAP Guru,

I am configuring DME for XXX bank, India.

Bank has asked for certain fields

like

1.  record identifier - "~"

2.payment run date

3. Identification

4. payment document number

5. amount

6. Payment method

and below that for payment advice it needed

1. advice header - "~H"

2. Payment document number

3. Detail identifier - "~D"

4.Invoice number

5. Invoice amount

With the help of DME i have configured every single data required by the bank

But they require data of payment advice once the data of all the payment document is completed

to explain a bit more I will take e.g. of a pay run

which creates two payment document 200000393 & 200000394

so the output they require is like this

1. reference" ~ "

2.Run ID - 05.04.2013

3. Identification - test

4. Payment document - 200000393 ( it is paid after clearing two invoices 0100000014 )

5. Amount -970

6. payment method - N

1. reference" ~ "

2.Run ID - 05.04.2013

3. Identification - test

4. Payment document - 200000394 ( it is paid after clearing invoices 0100000016 )

5. Amount -975

6. payment method - N

1. ~H

2.Payment document - 200000393

3.~D

4. Invoice number-0100000014

5. Invoice amt - 970

1. ~H

2.Payment document - 200000394

3.~D

4. Invoice number-0100000016

5. Invoice amt - 975

Means all the payment advice data comes after all the part 1 data is finished

for this i have created two separate segments

part1 data is caputred in level1

and payment advice in level 2

so to enable this same I am trying to use delay output in DME segment but dont know how to use it exactly

Pls guide me how can we achieve the same

for your reference I am attaching you the format shared by bank along with sample data shared by the bank

we are on SAP R/3 4.7

Regards

Ajay Gupta

ca.ajaygupta@gmail.com

File format given by bank.txt.zip

[Former Member]

Dear Ajay

in detail records, you must have created 2 nodes. 1 for Payment details and 2nd for Annexture details.

mark the Annexture records as 'Delay Output' and give it reference id.

after the detail records, create another node with level '1'  for annexture record and in segment data select the option for 'include other segment' and give the reference id of annexture node.

Cheers

Rs