SAP table TRRLCG (Settlement Document List Types)

SAP table TRRLCG has 2 primary key fields being MANDT,RRLCG.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
RRLCG Settlement Document List Type CHAR 4 0 RRLCG
RRLPR Partner Function for Recipient in Settlement Document List CHAR 2 0 TPAR RRLPR
RRLBD Default Value for Settlement Document List Date CHAR 2 0 RRLBD
01 Cash Discount 1 Due Date
02 Cash Discount 2 Due Data
03 Net Due Date
04 Document Date
05 Entered On
06 Posting Date
07 Baseline Date for Payment
08 SD: Invoice List Schedule + Posting Date (KNVV-PERRL)
99 Customer-Specific Variant (BAdI)
RRLCAL Settlement Calendar CHAR 2 0 TFACD WRKAL
LFART_RL Settlement Document Type for Settlement Document List CHAR 4 0 TMFK WFART_RL
CGTYPE Category of Settlement Document List Type CHAR 1 0 RRLCGTYPE
Standard
1 Rebate
2 Cross-Document-Category
CREATERRL Situation When to Create Settlement Document List CHAR 1 0 CREATERRL
Always
1 Only if Minimum of One Condition Exists
2 Only if Settlement Document List Recipient Exists
3 Only if Settlement Doc List Recip. and One Condition Exist
4 Only if Minimum of One Condition Exists with value <> 0
5 Only if Recipient and One Condition Exists with value <> 0
6 Recipient Exists and Settlement Document List Schedule Set
7 Settlement Doc List Schedule Set (Master Data (KNVV-PERRL))
SELECT_RRLCOND Determination of Settlement Document List Conditions CHAR 1 0 SELECT_RRLCOND
Condition Types for Group
1 All List Conditions
2 No Conditions
3 Condition Types for Group from "other" side
9 Customer-Specific Variant (BAdI)
SELECT_RRLREC Method for Determination Settlement Document List Recipient CHAR 1 0 SELECT_RRLREC
Partner Function (Invoicing Party / Payer)
1 Invoicing Party / Payer
2 Settlement Document List Type
3 Partner Function (Payment Recipient / Bill-To Party)
4 Payment Recipient / Bill-To Party (only with set. mgmt doc.)
5 Payer's Buying Group
6 Alternative Supplier (only with settl. mgmt doc.)
7 Customer of Invoicing Party / Supplier of Payer
8 Customer of Invoicing Party / Supplier of Payer (dyn.)
9 Customer-Specific Variant (BAdI)
A Store (only for FI documents)
B Supplier / Customer from Sales Organization
C Alternative Supplier Else Inv. Party (only with settl.doc.)
LFART_RL_CANCEL Settlement Document Type for Reversal Settlement Doc List CHAR 4 0 TMFK WFART_RL_CANCEL
CANCEL_TYPE Data Determination when Related Document is Cancelled CHAR 1 0 WLF_RRLE_CANCEL_TYPE
Transfer Data Without Changes
1 Redetermine Settlement Document List Date and Recipient
2 Only Redetermine Settlement Document List Date
3 Only Redetermine Settlement Document List Recipient
SELECT_WAERL_RL Currency Determination Method CHAR 1 0 WLF_RRLE_SELECT_WAERL
Document Currency
1 Local Currency
2 Payment Currency
3 Settlement Doc. List Recipient Currency
KURST_RL Exchange Rate Type CHAR 4 0 TCURV KURST
SELECT_WKURS Exchange Rate Determination Method CHAR 1 0 WLF_RRLE_SELECT_WKURS
For Settlement Doc. List Date
1 For Current Date
2 For Exchange Rate Date in Original Document
3 For Document Date in Original Document
4 For Posting Date in Original Document
5 For Entry Date in Original Document
9 Transfer from Original Document (If Payment Currency)
X About BAdI Method
RRLREC_CG Settlement Document List Recipient for List Type CHAR 10 0 WLF_RRLREC_CG
CANCEL_TYPE_WBRR Settlement Document List Relevance for Cancellations CHAR 1 0 WLF_RRLE_CANCEL_TYPE_WBRR
If Preceding Document is completed
1 If Index is completed (WBELN_RL not SPACE)
2 Independent of Preceding Document
3 If Settl. Doc. List Index Data Is Not the Same
4 If Remuneration List iis created for Preceding Document
5 Never (close both index entries)
9 Customer-Specific Variant (BAdI)
SELECT_ZTERM Determination Method for Terms of Payment CHAR 1 0 WLF_RRLE_SELECT_ZTERM
Standard
1 Master Data - Setlement Doc. List Recipient
2 From Settlement Doc. List Type
ZTERM_CG Terms of Payment for Settlement Document List CHAR 4 0 T052 WLF_RRLE_ZTERM_CG
PRICING Price Determination on Creation of Settlement Document Lists CHAR 1 0 WLF_RRLE_PRICING
Standard (Pricing Type E)
1 Use Pricing Type from Copy Control
2 No Price Determination
PRICING_SCHEME Determination of Calculation Schema CHAR 1 0 WLF_RRLE_SELECT_KALSM
Copy From Preceding Document
1 Redetermination via Schema Determtn (with schema grp prtnr)
2 Redetermination via Schema Determtn (w/o schema grp prtnr)
3 No Calculation Schema
4 Redetermination via Schema Determtn (only document scheme)
SELECT_WKURS_HW Exchange Rate Determination for Conversion to Local Currency CHAR 1 0 WLF_RRLE_SELECT_WKURS_HW
Copy from Preceding Document
1 Redetermination
COMPLETION_TYPE End Relevance for Settlement Document List Creation CHAR 1 0 WLF_RRLE_COMPLETION_TYPE
By Creation - Settlement Document List (Standard)
1 By Clearing the FI Document (Open FI)
2 By Creation - Settlement Document List (if not pro forma)
3 By External Process
9 Customer-Specific Check on Creation of Set. Doc List (BAdI)
SOURCE_DOCS Relevant Original Documents for Settlement Document Lists CHAR 1 0 WLF_RRLE_SOURCE_DOCUMENTS
Completed Documents
1 Completed and Locked Documents
2 All Documents (except completed ones)
3 Only Fully Completed Documents
4 All Documents
5 Only Fully Completed Documents with Accounting Relevance
DUPLICATE_CHECK Check for Duplicate Settlement Document Lists CHAR 1 0 WLF_RRLE_DUPLICATE_CHECK
IV_PROC_TYPE Type of Clearing in Clearing Workbench CHAR 1 0 WLF_IV_PROC_TYPE
Not Relevant for Clearing
1 Clearing at Header Level
2 Clearing at Item Level
3 Clearing at List Item Level
IV_DETERM_TYPE Assignment Method CHAR 1 0 WLF_IV_ASSIGNMENT_METHOD
No Automatic Assignment
1 Assignment According to Customizing
2 All Error-Free Operations
9 BAdI
IV_ASSMNT_GROUP Assignment Group CHAR 4 0 TMIVAG WLF_IV_ASSIGNMENT_GROUP
IV_PROFORMA ProForma Check CHAR 1 0 WLF_IV_PROFORMA
IV_WRART_RK_IN Settlement Process Type Difference Invoice CHAR 4 0 TMZR WLF_IV_WRART_DIF_RK_IN
IV_WRART_RK_CM Settlement Process Type Difference Credit Memo CHAR 4 0 TMZR WLF_IV_WRART_DIF_RK_CM
IV_WRART_TD Settlement Process Type Accepted Difference CHAR 4 0 TMZR WLF_IV_WRART_DIF_TD
IV_WRART_SD Settlement Process Type Other Difference CHAR 4 0 TMZR WLF_IV_WRART_DIF_SD
IV_LFGRU_PA Activity Reason for Document Creation CHAR 3 0 TMLFG WFGRU
IV_WRART_RST_PA Settlement Process Type Accrual Parked Documents CHAR 4 0 TMZR WLF_IV_WRART_PA
IV_RST_PA_COMPR Compress Difference Documents CHAR 1 0 WLF_IV_DIFFERENCE_COMPRESS
IV_WRART_RST_QC Settlement Process Type Clearance Accrual Parked Documents CHAR 4 0 TMZR WLF_IV_WRART_QC
IV_LFGRU_LA Activity Reason for Document Creation CHAR 3 0 TMLFG WFGRU
IV_WRART_RST_LA Settlement Process Type Accrual Unclarified Difference CHAR 4 0 TMZR WLF_IV_WRART_LA
IV_WRART_RST_MC Settle Process Type Clearance Accrual Unclarified Difference CHAR 4 0 TMZR WLF_IV_WRART_MC
IV_KTOSL Account Key CHAR 3 0 T687 KVSL1
IV_LFGRU_RL_MAN Activity Reason for Document Creation CHAR 3 0 TMLFG WFGRU
IV_LFGRU_RL_AUT Activity Reason for Document Creation CHAR 3 0 TMLFG WFGRU
IV_AUTORELEASE Handling of Locked Inbound Invoices CHAR 1 0 WLF_IV_INVOICE_AUTO_RELEASE
Release Automatically
1 Do Not Display
2 Display as Incorrect

TRRLCG foreign key relationships

Table Field Check Table Check Field
0 TRRLCG IV_ASSMNT_GROUP TMIVAG Assignment Groups MANDT
1 TRRLCG IV_KTOSL T687 Account Determination: Account Key KAPPL
0 TRRLCG IV_LFGRU_LA TMLFG Activity Reasons MANDT
1 TRRLCG IV_LFGRU_PA TMLFG Activity Reasons MANDT
0 TRRLCG IV_LFGRU_RL_AUT TMLFG Activity Reasons MANDT
1 TRRLCG IV_LFGRU_RL_MAN TMLFG Activity Reasons MANDT
0 TRRLCG IV_WRART_RK_CM TMZR Settlement Process Types MANDT
1 TRRLCG IV_WRART_RK_IN TMZR Settlement Process Types MANDT
0 TRRLCG IV_WRART_RST_LA TMZR Settlement Process Types MANDT
1 TRRLCG IV_WRART_RST_MC TMZR Settlement Process Types MANDT
0 TRRLCG IV_WRART_RST_PA TMZR Settlement Process Types MANDT
1 TRRLCG IV_WRART_RST_QC TMZR Settlement Process Types MANDT
0 TRRLCG IV_WRART_SD TMZR Settlement Process Types MANDT
1 TRRLCG IV_WRART_TD TMZR Settlement Process Types MANDT
0 TRRLCG KURST_RL TCURV Exchange rate types for currency translation MANDT
0 TRRLCG KURST_RL TCURV Exchange rate types for currency translation KURST
1 TRRLCG LFART_RL TMFK Settlement Document Types LFART
0 TRRLCG LFART_RL_CANCEL TMFK Settlement Document Types LFART
1 TRRLCG RRLPR TPAR Business Partner: Functions PARVW
0 TRRLCG ZTERM_CG T052 Terms of Payment MANDT
0 TRRLCG ZTERM_CG T052 Terms of Payment ZTERM
0 TRRLCG ZTERM_CG T052 Terms of Payment ZTAGG