Relation ship Map - Sales Quotation to Incoming Payments

[Former Member]

Dear Experts,

I had an issue in the SAP Relationship Map,

From the SQ to Incoming payments (in between SQ and Incoming payments, there are some documents like AR down payment invoice/Deliver Note / AR Invoices)

When I preview the relationship Map for a particular SQ it is showing only 2 incoming payments.

For examples

SQ (2350)----> Incoming payments(203,206))

  But  there is a receipt(227), that one also based on the particular SQ. When we click the based documents (from Incoming payent 227)button form from respective documents in between SQ and RC, it is going up to that particular SQ.

What is the issue ?

     

Thanks

Best Regards

Gobi

[kothandaraman_nagarajan · Accepted solution]

Hi,

Please advice total number of documents for above sales quotation.

Thanks & Regards,

Nagarajan

[Former Member · Accepted solution]

Hi Nagarajan

As per the Map

12 Down payment invoices

4 Credit memos

2 Incoming payments

but actual  no of Incoming payments should be 7.

I checked through a SQL query, there cancelled incoming payments not considered.

SQL Query

SELECT DISTINCT

                      TOP (100) PERCENT OQUT.DocNum AS SQNo, 0 AS DelNo, ODPI.DocNum AS DownPayNo, RCT2.DocNum AS RecpNo, ODPI.Series, ODPI.ObjType,

                      OQUT.DocEntry AS SQEntry, OQUT.Project, ODPI.DocEntry AS InvDocEntry, DPI1.BaseRef, ORCT.DocDate, ORCT.CashSum, ORCT.CheckSum, ORCT.TrsfrSum,

                      ORCT.NoDocSum, ORCT.DocTotal, ORCT.CounterRef, RCT2.InvType, ORCT.CreateDate, ODPI.DocTotal AS InvLineTotal, ODPI.PaidToDate,

                      DPI1.Dscription AS LineDescription, ODPI.DocDate AS PayDocDate

FROM         RCT2 INNER JOIN

                      ORCT ON RCT2.DocNum = ORCT.DocNum RIGHT OUTER JOIN

                      ODPI ON RCT2.InvType = ODPI.ObjType AND RCT2.DocEntry = ODPI.DocEntry RIGHT OUTER JOIN

                      DPI1 RIGHT OUTER JOIN

                      OQUT ON DPI1.BaseType = OQUT.ObjType AND DPI1.BaseRef = OQUT.DocNum ON ODPI.DocEntry = DPI1.DocEntry

WHERE     (ODPI.DocNum IS NOT NULL) AND (OQUT.CANCELED = 'n') AND (ODPI.CANCELED = 'n') AND (RCT2.DocNum IS NOT NULL) AND (ORCT.Canceled = 'N')

UNION ALL

SELECT DISTINCT

                      TOP (100) PERCENT OQUT_2.DocNum AS SQNo, ODLN.DocNum AS DelNo, ODPI_1.DocNum AS DownPayNo, RCT2_2.DocNum AS RecpNo, ODPI_1.Series,

                      ODPI_1.ObjType, OQUT_2.DocEntry AS SQEntry, OQUT_2.Project, DPI1_1.DocEntry AS InvDocEntry, DPI1_1.BaseRef, ORCT_2.DocDate, ORCT_2.CashSum,

                      ORCT_2.CheckSum, ORCT_2.TrsfrSum, ORCT_2.NoDocSum, ORCT_2.DocTotal, ORCT_2.CounterRef, RCT2_2.InvType, ORCT_2.CreateDate,

                      ODPI_1.DocTotal AS InvLineTotal, ODPI_1.PaidToDate, DPI1_1.Dscription AS LineDescription, ODPI_1.DocDate AS PayDocDate

FROM         RCT2 AS RCT2_2 INNER JOIN

                      ORCT AS ORCT_2 ON RCT2_2.DocNum = ORCT_2.DocNum RIGHT OUTER JOIN

                      ODPI AS ODPI_1 ON RCT2_2.InvType = ODPI_1.ObjType AND RCT2_2.DocEntry = ODPI_1.DocEntry RIGHT OUTER JOIN

                      OQUT AS OQUT_2 RIGHT OUTER JOIN

                      DLN1 INNER JOIN

                      ODLN ON DLN1.DocEntry = ODLN.DocEntry LEFT OUTER JOIN

                      DPI1 AS DPI1_1 ON ODLN.DocNum = DPI1_1.BaseRef AND ODLN.ObjType = DPI1_1.BaseType ON OQUT_2.DocNum = DLN1.BaseRef AND

                      OQUT_2.ObjType = DLN1.BaseType ON ODPI_1.DocEntry = DPI1_1.DocEntry

WHERE     (OQUT_2.DocNum IS NOT NULL) AND (ODLN.DocNum IS NOT NULL) AND (ODPI_1.CANCELED = 'N') AND (ODLN.CANCELED = 'N') AND (OQUT_2.CANCELED = 'N') AND

                      (ORCT_2.Canceled = 'N')

Thanks

Regards

Gobi

[kothandaraman_nagarajan · Accepted solution]

Hi,

There is limitation of display documents in relationship. Maximum of 18 documents will be displayed.

Thanks & Regards,

Nagarajan

[Former Member · Accepted solution]

Thanks Mr.Nagarajan.