cancel
Showing results for 
Search instead for 
Did you mean: 

Need a SQL Qurry for Incomming Payment for both "Pay On Invoice" & " Pay on Account"

pvinod_kumar
Participant
0 Kudos

Dear Experts

I need a query in SQL for Incoming Payment,

am using SAP 9.3

i need the data for tax department Submission

Payment based on Invoice like,,,

Invoice Number, Customer Name, Customer Code, Pay Doc Date, Invoice Date, Amount, Mean of Payment, Tax Amount

Payment based on Account like,,,

Once the Payment is Received ON PAYMENT ACCOUNT , and if its Re-Reconciled then all the same data req as the above one , additionally i need to mark these payment as OAP (On Account Based Payment)

Thanks

Regards

Vinod

Accepted Solutions (0)

Answers (1)

Answers (1)

kothandaraman_nagarajan
Active Contributor
0 Kudos
pvinod_kumar
Participant
0 Kudos

Hi Sir

This is a Wonder full Report, Thanks for the Valuable Support,

Can you help me to link the Document Number against which the Reconciliation is done for the Payment Like " PAY ON ACCOUNT"

Regards

Vinod

jitin_chawla
Product and Topic Expert
Product and Topic Expert
0 Kudos

Try joining ITR1 and OITR tables which keeps the reconciliation records,