Thursday, September 19, 2024

SAP Table ARUN_RULE – Supply Assignment Rule

ARUN_RULE is a standard SAP table in SAP ERP (or) S/4HANA which stores Supply Assignment Rule data. There are total 26 fields in ARUN_RULE table.This blog post provides key technical details of SAP table ARUN_RULE, including its availability across SAP S/4HANA versions and the list of CDS views for ARUN_RULE table in SAP.

SAP HANA Table Type Column Store
Buffering Permission Buffering not allowed
Buffering Type No buffering
Package Supply Assignment Rules (ARUN_RULE)
Technical Component Order Allocation Run (LO-RFM-ARN)

SAP ARUN_RULE Table Fields

The following is the list of fields that are available in SAP ARUN_RULE table. The key fields of the table are highlighted in color.

Field Description Data Element Domain Check Table Data Type
MANDT Client MANDT MANDT CLNT (3)
ARUNRULEUUID ARun Rule UUID ARUN_RULE_UUID SYSUUID RAW (16)
ARUNRULENAME Supply Assignment Rule ARUN_RULE_NAME ARUN_RULE_NAME CHAR (30)
ABOPSTOCKSORTRULE Supply Assignment: Supply Sort Rule ARUN_SORT_RULE ARUN_SORT_RULE ARUN_SORT_ID CHAR (4)
ABOPALLOCRELEASEISREQUIRED Supply Assignment: Release Check Required ARUN_RELEASE_REQ BOOLE CHAR (1)
ABOPASSIGNMENTPREVIEWISACTIVE Supply Assignment: Preview ARUN_ASSIGNMENT_PREVIEW BOOLE CHAR (1)
ABOPSUPPLYREASSIGNMENTISREQD Supply Assignment: Reassignment indicator ARUN_REASSIGNMENT BOOLE CHAR (1)
ARUNSTKOVERWRITEISREQUIRED Overwrite Supply Selection ARUN_OVW_STK_SEL BOOLEAN CHAR (1)
ARUNPHYSICALSTKISSELECTED Include Physical Stock ARUN_PHYSICAL_STOCK XFELD CHAR (1)
ARUNPOSTKISSELECTED Include Purchase Orders for Stock Selection ARUN_ABST XFELD CHAR (1)
ARUNASNSTKISSELECTED Include Shipping Notifications for Stock Selection ARUN_SHPNO XFELD CHAR (1)
ARUNPRODNORDSTKISSELECTED Include Production Order for Stock Selection ARUN_AFPO XFELD CHAR (1)
ARUNPURREQNSTKISSELECTED Include Purchase Requisition for Stock Selection ARUN_EBAN XFELD CHAR (1)
ARUNPLNDORDSTKISSELECTED Include Planned Order for Stock Selection ARUN_PLAF XFELD CHAR (1)
ARUNRELEASERULE Release Rule ARUN_REREG ARUN_REREG ARUN_RELEASE CHAR (4)
ARUNDISTRIBUTIONSTRATEGY ARun Distribution Logic ARUN_DISTRIBUTION_LOGIC ARUN_DISTRIBUTION_LOGIC CHAR (1)
ARUNGROUPINGSTRATEGY ARun Grouping Logic ARUN_GROUPING_LOGIC ARUN_GROUPING_LOGIC CHAR (1)
ARUNMINASSGMTPERCENT Minimum Assignment Percentage ARUN_MIN_PERCENT PROZENT100 NUMC (3)
ARUNMAXASSGMTPERCENT Maximum Assignment Percentage ARUN_MAX_PERCENT PROZENT100 NUMC (3)
CREATEDBYUSER Name of Person who Created the Object ERNAM USNAM CHAR (12)
CREATIONDATETIME ARun Rule Creation Date Time ARUN_RULE_CREATIONDATETIME TZNTSTMPL DEC (21)
LASTCHANGEDBYUSER Name of person who changed object AENAM USNAM CHAR (12)
LASTCHANGEDATETIME ARun Rule Changed Date Time ARUN_RULE_CHANGEDATETIME TZNTSTMPL DEC (21)
ARUNSUPPROTISRQD Supply Protection is required ARUN_SUP_REQUIRED BOOLEAN CHAR (1)
ARUNSUPPROTEXECMODE Supply Protection Execution Mode ARUN_SUP_LOGIC ARUN_SUP_LOGIC CHAR (1)
ARUNDEMANDGROUPRULEUUID ARun Demand Group Rule UUID ARUN_DEMAND_GROUP_RULE_UUID SYSUUID RAW (16)

Availability

The SAP table ARUN_RULE is available within SAP S/4HANA On-premise and SAP S/4HANA Cloud systems depending on the version and release level.

SAP S/4HANA Version Available?
1909 Yes
2020 Yes
2021 Yes
2022 Yes
2023 Yes

CDS Views for ARUN_RULE table

The following is the list of ARUN_RULE CDS views, which can also be used instead of ARUN_RULE table based on your business requirements.

CDS View CDS View Type Description
I_ARUNABOPVARIANTVALUEHELP BASIC Value help for BOP Variant
I_ARUNRULE BASIC Basic View for Supply Assignment Rule
I_ARUNAMOUNTCUBE COMPOSITE Cube View for Amount in Display Currency
I_ARUNCOMPAREASSGMT COMPOSITE Supply Assignment Run Compare Assignment
I_ARUNCOMPAREASSGMTCUBE COMPOSITE ARun Compare Assignments Cube View
I_ARUNITMRSNCODE COMPOSITE Basic View for Reason Code of ARun
I_ARUNITMRSNCODECUBE COMPOSITE Cube View for Reason Code of ARun
I_ARUNMONITOR COMPOSITE Basic view for ARun monitor
I_ARUNMONITORRUNS COMPOSITE Basic view for ARun monitor
I_ARUNMONITORTP COMPOSITE Basic view for ARun monitor
I_ARUNOVWASSGMTALL COMPOSITE Supply Assignment Run Assignment View
I_ARUNOVWASSGMTCUBE COMPOSITE ARun Assignments Cube View
I_ARUNOVWCONFSTRGY COMPOSITE View for Confirmation Strategy of ARun
I_ARUNOVWCONFSTRGYCUBE COMPOSITE Cube View for ARun Confirmation Strategy
I_ARUNOVWDEMAND COMPOSITE Supply Assignment Run Demand View
I_ARUNOVWSIMLNDMND COMPOSITE Supply Assignment Run Simulation Demand
I_ARUNOVWTOTDMND COMPOSITE Supply Assignment Run Total Demand View
I_ARUNOVWTOTDMNDCUBE COMPOSITE Supply Assignment Run Demand Cube View
I_ARUNRULEVALUEHELP COMPOSITE Value Help for ARun Rule
I_ARUNSIMLNDMNDCUBE COMPOSITE ARun Simulation Demand Cube View
P_ARUNABOPNRUNS COMPOSITE Basic view for Supply Assignment Normal Runs Qunatity
P_ARUNATPITEMREQUIREMENT COMPOSITE BOP Run Item Level Data
P_ARUNATPRESULT COMPOSITE Basic view for ARun ATP Runs
P_ARUNATPRESULT1 COMPOSITE Basic view for ARun ATP Runs
P_ARUNATPRESULTREQUIREMENT COMPOSITE Basic View for BOP Run Details
P_ARUNDMNDGRPRULEARUNRULE COMPOSITE dfs
P_ARUNITARESULTREQMT COMPOSITE Requirement Document Selection of BOP Variant Runs
P_ARUNNORMALASSIGNED COMPOSITE Basic view for Assigned Quantity for Normal Run
P_ARUNOVWDEMAND COMPOSITE Supply Assignment Run Demand View
P_ARUNOVWDEMAND1 COMPOSITE Supply Assignment Run Demand View
P_ARUNOVWDEMAND2 COMPOSITE Supply Assignment Run Demand View
P_ARUNOVWDEMAND3 COMPOSITE Supply Assignment Run Demand View
P_ARUNOVWSIMLNDMND COMPOSITE Supply Assignment Run Simulation Demand
P_ARUNOVWSIMLNDMND1 COMPOSITE Supply Assignment Run Simulation Demand
P_ARUNOVWSIMLNDMND2 COMPOSITE Supply Assignment Run Demand View
P_ARUNOVWSIMLNDMND3 COMPOSITE Supply Assignment Run Demand View
P_ARUNPREVIEWASSIGNED COMPOSITE Basic view for Assigned Quantity for Preview Run
P_ARUNRELCHKATPRUN COMPOSITE ARun ATP Result Runs for RC Var
P_ARUNSIMASSIGNED COMPOSITE Simulation Assigned Quantity for Run
P_ARUNSIMLNLGITMTOT COMPOSITE Basic view for Supply Assignment Simulation Log Total
P_ARUNSIMLNLGTOT COMPOSITE Basic view for Supply Assignment Simulation Log Total
C_ABOPVARIANTTP CONSUMPTION ABOP Variant Transactional Processing
C_ARUNABOPVARIANTVALUEHELP CONSUMPTION Value help for BOP Variant
C_ARUNAMOUNTQUERY CONSUMPTION Query View Amount in Display Currency
C_ARUNCOMPAREASSGMTQUERY CONSUMPTION ARun Compare Assignments Query View
C_ARUNCOMPRNFLTR CONSUMPTION Filter View for Comparison of ARun
C_ARUNDEMANDGROUPRULE CONSUMPTION ARun Demand Grouping Rule
C_ARUNDETAILEDANLYSFLTR CONSUMPTION Filter View for Supply Assignment Run
C_ARUNDMNDGRPRULERELTDARUNRULE CONSUMPTION Related ARun Rules
C_ARUNITMRSNCODEQUERY CONSUMPTION Query View for ARun Reason Code
C_ARUNMNTRRUNS CONSUMPTION View for ARun monitor runs
C_ARUNMNTRRUNSINCOMPLETE CONSUMPTION View for ARun monitor runs
C_ARUNMONITORINCOMPLETETP CONSUMPTION View for ARun monitor incomplete runs
C_ARUNMONITORTP CONSUMPTION View for ARun monitor runs
C_ARUNOVWASSGMTQUERY CONSUMPTION ARun Assignments Query View
C_ARUNOVWCONFSTRGYQUERY CONSUMPTION Query View ARun Confirmation Strategy
C_ARUNOVWTOTDMNDQUERY CONSUMPTION Supply Assignment Run Demand Query View
C_ARUNRULE CONSUMPTION Supply Assignment Rule
C_ARUNRULEABOPVARIANT CONSUMPTION Count of Related Variants
C_ARUNSIMLNDMNDQUERY CONSUMPTION ARun Simulation Demand Query View