SAP BUCC_RULE Consistency Checks - Rules Table data and field list

BUCC_RULE is a standard SAP Table which is used to store Consistency Checks - Rules data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The BUCC_RULE table consists of various fields, each holding specific information or linking keys about Consistency Checks - Rules data available in SAP. These include APPLIC (Application), LIBRARY (Consistency Checks - Library Code), CHECKTYPE (Consistency Checks - Check Type), CHECKRULE (Consistency Checks - Code for Check Rule)... See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

BUCC_RULE table Technical Details:

Delivery Class: E - Control table, SAP and customer have separate key areas
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced

Text table = BUCC_RULE_T


SAP BUCC_RULE table fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the BUCC_RULE table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.
Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
CLIENTClient MANDTCLNT3T000MANDT
APPLICApplication BUKU_APPLICCHAR2BUCC_LIBBUKU_APPLIC
LIBRARYConsistency Checks - Library Code BUCC_LIBRARYCHAR7BUCC_LIBRARY
CHECKTYPEConsistency Checks - Check Type BUCC_CHECKTYPECHAR1BUCC_CHECKTYPE
CHECKRULEConsistency Checks - Code for Check Rule BUCC_CHECKRULECHAR7BUCC_CHECKRULE
CRTUSERUser Who Created or Updated the Object BUKU_CRTUSERCHAR12USERNAME
CRTDATEDate on which the object was created or updated BUKU_CRTDATEDATS8DATE
CRTTIMETime at which the object was created or updated BUKU_CRTTIMETIMS6TIME
CHGUSERLast user to change object BUKU_CHGUSERCHAR12USERNAME
CHGDATEDate on which the object was changed BUKU_CHGDATEDATS8DATE
CHGTIMETime at which the object was changed BUKU_CHGTIMETIMS6TIME
ACTIVEConsistency checks - Active/inactive status of a check rule BUCC_CHECKRULE_ACTIVATIONCHAR1BOOLE
FUNDKey Figures - Fund aggregation FMKF_FUND_AGGRCHAR1BOOLE
BUDGET_PDKey Figures - Budget Period aggregation FMKF_BUDGET_PD_AGGRCHAR1BOOLE
FUNDSCTRKey Figures - Funds center aggregation FMKF_FUNDSCTR_AGGRCHAR1BOOLE
CMMTITEMKey Figures - Commitment item aggregation FMKF_CMMTITEM_AGGRCHAR1BOOLE
FUNCAREAKey Figures - Functional area aggregation FMKF_FUNCAREA_AGGRCHAR1BOOLE
GRANT_NBRKey Figures - Grant aggregation FMKF_GRANT_NBR_AGGRCHAR1BOOLE
MEASUREKey Figures - Program in Funds Management FMKF_MEASURE_AGGRCHAR1BOOLE
USERDIMKey Figures - Aggregation for Customer Field FMKF_USERDIM_AGGRCHAR1BOOLE
OPERATORConsistency Checks - Comparison operator BUCC_OPERATORCHAR2BUCC_OPERATOR
TOL_TYPESingle-Character Indicator CHAR1CHAR1CHAR1
TOL_AMOUNTConsistency Checks - Tolerance Amount BUCC_TOLERANCE_AMOUNTCURR17(2) WERTV9
TOL_PERCENTConsistency Checks - Tolerance Percentage BUCC_TOLERANCE_PERCENTDEC5(2)
FORMULA_IDFormula ID SFBEIDCHAR32SYSUUID_C

Key field Non-key field



How do I retrieve data from SAP table BUCC_RULE using ABAP code

The following ABAP code Example will allow you to do a basic selection on BUCC_RULE to SELECT all data from the table
DATA: WA_BUCC_RULE TYPE BUCC_RULE.

SELECT SINGLE *
FROM BUCC_RULE
INTO CORRESPONDING FIELDS OF WA_BUCC_RULE
WHERE...

How to access SAP table BUCC_RULE

Within an ECC or HANA version of SAP you can also view further information about BUCC_RULE and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).