1. Home
  2. Resources
  3. SAP Tables
  4. TIBRCLARREAS - Clarification Codes for Broker Report

SAP Table TIBRCLARREAS

Clarification Codes for Broker Report

TIBRCLARREAS (Clarification Codes for Broker Report) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link TIBRCLARREAS to other SAP tables.

TIBRCLARREAS table fields

Field Data element Checktable Datatype Length Decimals
CLIENT Client MANDT T000 CLNT 3 0
CLARREAS Clarification Code CLARREAS_BRO CHAR 2 0
POSTRULE Posting Rule for Broker Report Item POSTRULE_BRO TIBRPOSTRULE CHAR 2 0
POSCAT Category in the Broker Report POSCAT_BRO TIBRPOSCAT CHAR 2 0
LOCKREAS Payment lock reason for broker document item LOCKREAS_BRO TFK008 CHAR 1 0
LOCKDAYS Broker line item payment lock: Duration in days LOCKDAYS_BRO NUMC 3 0
CLEARRESTR Clearing restriction AUGRS_KK CHAR 1 0
0 Document is incorrect (no zero balance)
1 Down Payment from IS-U: Can Only be Cleared in Invoicing
2 Security Deposit: No Clearing Permitted
3 Difference amount cannot be cleared until next invoice
4 Donations or payment for equity funds
5 Down payment from SD: Can only be cleared against SD recevbl
6 Payable Only after Budget Billing Request
7 Collective invoice: Only payable after collective billing
8 Items cannot be processed until next regular invoice
9 Renewals Down Payment: Only Clear with IS-M-SD Receivable
A Gen. down payment: Can be cleared in next invoice
B Agency Collections: Can Only Be Paid via Agency Collections
C Broker report: Item in clarification
D Deposit: Can only be cleared with open item clearing
E Est. Posting
G Budget Billing as Down Payment on Vendor Side (Deregulation)
I Rounding Carryforward from Invoicing
P Cannot be Paid before Budget Billing Request (Deregulation)
R Items Relevant for Payment Scheme
S Cash Loss/Held Items
T Clearing Only via External Interface
U Reserved payment on account
V Clearing Only Permitted after Confirmation of Partner
W Clearing only by Account Maintenance
X Paid statistical charge
Z Clearing Only by Payment Program
NULL No restriction
F Automatic Clearing of Temporary Premium Requests (FS-CD)
Y Additional Deregulation Items
K Posting to Prepaid Account
H Provisional Posting
XNOCLAR Transfer Post Clarification Amt Without Clarification Proc. XNOCLAR_BRO CHAR 1 0
X Yes
NULL No
HVORG Main Trans. for New Created Open Items from Broker Report HVORG_BRO TFKHVO CHAR 4 0
TVORG Subtrans. for New Created Open Items from Broker Report TVORG_BRO TFKTVO CHAR 4 0
HVORG_CLAR Main Transaction for Clarification Posting (Sub-Ledger) HVORG_CLAR_BRO TFKHVO CHAR 4 0
TVORG_CLAR Subtransaction for Clarification Posting (Subledger Account) TVORG_CLAR_BRO TFKTVO CHAR 4 0
XNOGPVT_REQU Clarif. Code Usable for Missing BP, IO XNOGPVT_REQU_BRO CHAR 1 0
X Yes
NULL No
XCOMM_ON_ORIBRO Commission Postings on Account for Original Broker XCOMM_ON_ORIBRO_BRO CHAR 1 0
X Yes
NULL No
ALTBROK_RULE Derivation Rule for Alt. Collecting Broker w. On A/C Post. ALTBROK_RULE_BRO CHAR 1 0
NULL Do not fill collecting broker in document
1 Enter reporting broker as collecting broker in document
2 Enter assigned broker as collecting broker in document
XSEL_MULTIPLE Clarification Code Applicable for Multiple Groups XMULTGRP_ALLOW_BRO CHAR 1 0
X Yes
NULL No

TIBRCLARREAS foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
TIBRCLARREAS CLIENT TIBRCLARREAS CLIENT T000 Clients MANDT
TIBRCLARREAS HVORG 'V' TFKHVO Main transactions in contract accts receivable and payable APPLK
TIBRCLARREAS HVORG TIBRCLARREAS HVORG TFKHVO Main transactions in contract accts receivable and payable HVORG
TIBRCLARREAS HVORG TIBRCLARREAS CLIENT TFKHVO Main transactions in contract accts receivable and payable MANDT
TIBRCLARREAS HVORG_CLAR TIBRCLARREAS CLIENT TFKHVO Main transactions in contract accts receivable and payable MANDT
TIBRCLARREAS HVORG_CLAR 'V' TFKHVO Main transactions in contract accts receivable and payable APPLK
TIBRCLARREAS HVORG_CLAR TIBRCLARREAS HVORG_CLAR TFKHVO Main transactions in contract accts receivable and payable HVORG
TIBRCLARREAS LOCKREAS TIBRCLARREAS CLIENT TFK008 Locking Reasons for Automatic Payment Transactions MANDT
TIBRCLARREAS LOCKREAS TIBRCLARREAS LOCKREAS TFK008 Locking Reasons for Automatic Payment Transactions ZAHLS
TIBRCLARREAS POSCAT TIBRCLARREAS POSCAT TIBRPOSCAT Category That Classifies Items in a Broker Report POSCAT
TIBRCLARREAS POSTRULE TIBRCLARREAS POSTRULE TIBRPOSTRULE Posting Rules for Broker Report POSTRULE
TIBRCLARREAS TVORG 'V' TFKTVO Sub-transactions in Contract Accounts Receivable and Payable APPLK
TIBRCLARREAS TVORG TIBRCLARREAS HVORG TFKTVO Sub-transactions in Contract Accounts Receivable and Payable HVORG
TIBRCLARREAS TVORG TIBRCLARREAS TVORG TFKTVO Sub-transactions in Contract Accounts Receivable and Payable TVORG
TIBRCLARREAS TVORG TIBRCLARREAS CLIENT TFKTVO Sub-transactions in Contract Accounts Receivable and Payable MANDT
TIBRCLARREAS TVORG_CLAR TIBRCLARREAS HVORG_CLAR TFKTVO Sub-transactions in Contract Accounts Receivable and Payable HVORG
TIBRCLARREAS TVORG_CLAR TIBRCLARREAS TVORG_CLAR TFKTVO Sub-transactions in Contract Accounts Receivable and Payable TVORG
TIBRCLARREAS TVORG_CLAR TIBRCLARREAS CLIENT TFKTVO Sub-transactions in Contract Accounts Receivable and Payable MANDT
TIBRCLARREAS TVORG_CLAR 'V' TFKTVO Sub-transactions in Contract Accounts Receivable and Payable APPLK