RDN1 table in SAP Business One (Returns (rows))

What is the RDN1 table in SAP B1?

RDN1 is the SAP Business One table for the rows of sales returns. Each row is one item a customer sent back, with quantity, price, warehouse and row total, and joins to the ORDN header on DocEntry. BaseType 15 with BaseEntry and BaseLine points to the delivery row in DLN1 that the return reverses.

Where is the RDN1 table in SAP B1?

In SAP Business One 10.0, RDN1 is the "Returns - Rows" table with 343 columns. You see its data in Sales - A/R → Returns (header table ORDN).

RDN1 key fields

Types as listed in the SAP Business One 10.0 SDK database tables reference: nVarChar(n) is text of up to n characters, Num(19,6) a decimal with 6 places. Column names are the same on SQL Server and SAP HANA.

How RDN1 relates to other tables

RDN1 rows belong to one ORDN header (DocEntry). A return copied from a delivery stores BaseType 15, BaseEntry = ODLN.DocEntry and BaseLine = DLN1.LineNum. If an A/R credit memo is then copied from the return, the row keeps TargetType 14 and TrgetEntry = ORIN.DocEntry.

Common joins

• RDN1 T1 INNER JOIN ORDN T0 ON T0.DocEntry = T1.DocEntry (header)
• RDN1 T1 LEFT JOIN ODLN T2 ON T2.DocEntry = T1.BaseEntry AND T1.BaseType = 15 (delivery returned)
• RDN1 T1 LEFT JOIN ORIN T3 ON T3.DocEntry = T1.TrgetEntry AND T1.TargetType = 14 (A/R credit memo)
• RDN1 T1 LEFT JOIN OITM T4 ON T4.ItemCode = T1.ItemCode (item master)

When you use the RDN1 table

Use RDN1 for return rates per item or customer, for stock that came back into a warehouse, and to trace a returned row to its delivery and to the credit memo that followed.

Example query: returned rows with the delivery they came from

SQL Server

SELECT T0.DocNum AS ReturnNum, T0.DocDate, T0.CardCode, T0.CardName, T1.ItemCode,
  T1.Quantity, T1.WhsCode, T2.DocNum AS DeliveryNum
FROM ORDN T0
INNER JOIN RDN1 T1 ON T1.DocEntry = T0.DocEntry
LEFT JOIN ODLN T2 ON T2.DocEntry = T1.BaseEntry AND T1.BaseType = 15
WHERE T0.CANCELED = 'N'
ORDER BY T0.DocDate DESC, T0.DocNum, T1.LineNum

SAP HANA (column names in double quotes)

SELECT T0."DocNum" AS "ReturnNum", T0."DocDate", T0."CardCode", T0."CardName", T1."ItemCode",
  T1."Quantity", T1."WhsCode", T2."DocNum" AS "DeliveryNum"
FROM ORDN T0
INNER JOIN RDN1 T1 ON T1."DocEntry" = T0."DocEntry"
LEFT JOIN ODLN T2 ON T2."DocEntry" = T1."BaseEntry" AND T1."BaseType" = 15
WHERE T0."CANCELED" = 'N'
ORDER BY T0."DocDate" DESC, T0."DocNum", T1."LineNum"

Paste either version in Tools → Queries → Query Generator. Need the other dialect for your own query? Use the SQL to HANA converter.

Common pitfall: A return is not a credit memo

RDN1 records goods coming back after a delivery; it does not reduce invoiced sales. Goods that were already invoiced are credited with an A/R credit memo, whose rows are in RIN1. A sales report that subtracts RDN1 from INV1 is wrong on both counts: use RIN1 for the value credited and RDN1 for returned quantities of deliveries. See RIN1 table (A/R credit memo lines).

Ready-made queries that use RDN1

• Top 20 selling items: Best-selling items by sales value, with quantity sold, for a date range.
• Sales by customer for a date range: Net sales per customer (invoices minus credit notes) between two dates, highest first.

Building something on RDN1?

Reading RDN1 (Returns (rows)) in a query is the easy part. We build B2B customer portals for SAP Business One: customers see their prices, stock, order status, invoices and statements, and their orders land in SAP as sales orders. Or hire a dedicated SAP B1 developer for the whole job, fixed price per phase.

Questions about the RDN1 table

What is the RDN1 table in SAP B1?

RDN1 is the SAP Business One table for the rows of sales returns. Each row is one item a customer sent back, with quantity, price, warehouse and row total, and joins to the ORDN header on DocEntry. BaseType 15 with BaseEntry and BaseLine points to the delivery row in DLN1 that the return reverses.

How do I link RDN1 to the delivery?

RDN1.BaseType = 15, RDN1.BaseEntry = ODLN.DocEntry and RDN1.BaseLine = DLN1.LineNum.

What is the difference between RDN1 and RIN1?

RDN1 holds the rows of returns (ORDN), which reverse deliveries. RIN1 holds the rows of A/R credit memos (ORIN), which reverse invoices.

What is the difference between ORDN and RDN1?

ORDN is the return header (customer, dates, totals), with one row per return. RDN1 holds the item rows. They join on DocEntry.

Related tables

ORDN (Returns (header)) · DLN1 (Delivery (rows)) · ODLN (Delivery (header)) · RIN1 (A/R Credit Memo (lines)) · search all SAP Business One tables

Sources: SAP Business One documentation and SDK (DI API database tables reference), SAP Help Portal; SDK 10.0 table page for RDN1.