ARUN_RULE
Supply Assignment Rule
ARUN_RULE is an SAP database table in S/4HANA. Supply Assignment Rule. It contains 38 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_ARunRule | view | from | BASIC | Basic View for Supply Assignment Rule |
Fields (38)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | arunruleuuid | ARUN_RULE_UUID | ARun Rule UUID | |||
| arunrulename | ARUN_RULE_NAME | ARun Rule | ||||
| abopstocksortrule | ARUN_SORT_RULE | Supply Sort Rule | ||||
| abopallocreleaseisrequired | ARUN_RELEASE_REQ | Release Check Req. | ||||
| abopsupplyselhorizonindays | ARUN_SUPPLY_HORIZON | Supply Horizon | ||||
| abopassignmentpreviewisactive | ARUN_ASSIGNMENT_PREVIEW | Assignment Preview | ||||
| abopsupplyreassignmentisreqd | ARUN_REASSIGNMENT | Reassignment | ||||
| arunstkoverwriteisrequired | ARUN_OVW_STK_SEL | Overwrite Supply Sel | ||||
| arunphysicalstkisselected | ARUN_PHYSICAL_STOCK | Include Physical Sto | ||||
| arunpostkisselected | ARUN_ABST | Include PO | ||||
| arunasnstkisselected | ARUN_SHPNO | Incl. Shipping Not. | ||||
| arunprodnordstkisselected | ARUN_AFPO | Incl. Production Ord | ||||
| arunpurreqnstkisselected | ARUN_EBAN | Incl. Purchase Req | ||||
| arunplndordstkisselected | ARUN_PLAF | Incl. Planned Order | ||||
| arunreleaserule | ARUN_REREG | Release Rule | ||||
| arundistributionstrategy | ARUN_DISTRIBUTION_LOGIC | ARun Distribution Lo | ||||
| arungroupingstrategy | ARUN_GROUPING_LOGIC | ARun Grouping Logic | ||||
| arunminassgmtpercent | ARUN_MIN_PERCENT | Min. Assgmt Percent | ||||
| arunmaxassgmtpercent | ARUN_MAX_PERCENT | Max Assgmt Percent | ||||
| createdbyuser | ERNAM | Created By | ||||
| creationdatetime | ARUN_RULE_CREATIONDATETIME | Created On | ||||
| lastchangedbyuser | AENAM | Changed By | ||||
| lastchangedatetime | ARUN_RULE_CHANGEDATETIME | ARun Rule Changed D | ||||
| arunsupprotisrqd | ARUN_SUP_REQUIRED | SUP required | ||||
| arunsupprotexecmode | ARUN_SUP_LOGIC | SUP Mode | ||||
| arundemandgroupruleuuid | ARUN_DEMAND_GROUP_RULE_UUID | ARun Group Rule UUID | ||||
| arunignorecanclndtechk | ARUN_SKIP_CNCDTCHECK | Ignore Canc. Dt. Chk | ||||
| arunignorestorlocchk | ARUN_SKIP_SLOCCHECK | Ignore S.loc Check | ||||
| arunqtyroundingstrgy | ARUN_QTY_ROUNDING_STRATEGY | Rounding Strategy | ||||
| arunrulefiltermode | ARUN_FILTERMODE | Filter Mode | ||||
| arunsupplyselectionruleuuid | ARUN_SUPPLY_SEL_RULE_UUID | ARun Sel Rule UUID | ||||
| arunignrcanclndtesupdtechk | ARUN_CANCELDTE_SUPPLYDTE_CHK | Ignr Canceln Dte Chk | ||||
| arunignrcanclndtereqddtechk | ARUN_SKIP_CANCELDTE_CHECK | Canceln Date Check | ||||
| arunignorebatchcheck | ARUN_SKIP_BATCH_CHECK | Ignore Batch Check | ||||
| arunincludeincmpltordchk | ARUN_INCMPLT_ORDCHK | Incomplete Orders | ||||
| arunignorepastcanclndatecheck | ARUN_SKIP_PAST_CANCEL_DATE_CHK | Ignr Past Cancln Dte | ||||
| arunconfbsdsegmtnisseld | ARUN_CONF_SEG_PRIO | Con-based Seg & Prio |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Supply Assignment Rule
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ARUN_RULE (
MANDT, -- Client [MANDT]
ARUNRULEUUID, -- ARun Rule UUID [ARUN_RULE_UUID]
ARUNRULENAME, -- ARun Rule [ARUN_RULE_NAME]
ABOPSTOCKSORTRULE, -- Supply Sort Rule [ARUN_SORT_RULE]
ABOPALLOCRELEASEISREQUIRED, -- Release Check Req. [ARUN_RELEASE_REQ]
ABOPSUPPLYSELHORIZONINDAYS, -- Supply Horizon [ARUN_SUPPLY_HORIZON]
ABOPASSIGNMENTPREVIEWISACTIVE, -- Assignment Preview [ARUN_ASSIGNMENT_PREVIEW]
ABOPSUPPLYREASSIGNMENTISREQD, -- Reassignment [ARUN_REASSIGNMENT]
ARUNSTKOVERWRITEISREQUIRED, -- Overwrite Supply Sel [ARUN_OVW_STK_SEL]
ARUNPHYSICALSTKISSELECTED, -- Include Physical Sto [ARUN_PHYSICAL_STOCK]
ARUNPOSTKISSELECTED, -- Include PO [ARUN_ABST]
ARUNASNSTKISSELECTED, -- Incl. Shipping Not. [ARUN_SHPNO]
ARUNPRODNORDSTKISSELECTED, -- Incl. Production Ord [ARUN_AFPO]
ARUNPURREQNSTKISSELECTED, -- Incl. Purchase Req [ARUN_EBAN]
ARUNPLNDORDSTKISSELECTED, -- Incl. Planned Order [ARUN_PLAF]
ARUNRELEASERULE, -- Release Rule [ARUN_REREG]
ARUNDISTRIBUTIONSTRATEGY, -- ARun Distribution Lo [ARUN_DISTRIBUTION_LOGIC]
ARUNGROUPINGSTRATEGY, -- ARun Grouping Logic [ARUN_GROUPING_LOGIC]
ARUNMINASSGMTPERCENT, -- Min. Assgmt Percent [ARUN_MIN_PERCENT]
ARUNMAXASSGMTPERCENT, -- Max Assgmt Percent [ARUN_MAX_PERCENT]
CREATEDBYUSER, -- Created By [ERNAM]
CREATIONDATETIME, -- Created On [ARUN_RULE_CREATIONDATETIME]
LASTCHANGEDBYUSER, -- Changed By [AENAM]
LASTCHANGEDATETIME, -- ARun Rule Changed D [ARUN_RULE_CHANGEDATETIME]
ARUNSUPPROTISRQD, -- SUP required [ARUN_SUP_REQUIRED]
ARUNSUPPROTEXECMODE, -- SUP Mode [ARUN_SUP_LOGIC]
ARUNDEMANDGROUPRULEUUID, -- ARun Group Rule UUID [ARUN_DEMAND_GROUP_RULE_UUID]
ARUNIGNORECANCLNDTECHK, -- Ignore Canc. Dt. Chk [ARUN_SKIP_CNCDTCHECK]
ARUNIGNORESTORLOCCHK, -- Ignore S.loc Check [ARUN_SKIP_SLOCCHECK]
ARUNQTYROUNDINGSTRGY, -- Rounding Strategy [ARUN_QTY_ROUNDING_STRATEGY]
ARUNRULEFILTERMODE, -- Filter Mode [ARUN_FILTERMODE]
ARUNSUPPLYSELECTIONRULEUUID, -- ARun Sel Rule UUID [ARUN_SUPPLY_SEL_RULE_UUID]
ARUNIGNRCANCLNDTESUPDTECHK, -- Ignr Canceln Dte Chk [ARUN_CANCELDTE_SUPPLYDTE_CHK]
ARUNIGNRCANCLNDTEREQDDTECHK, -- Canceln Date Check [ARUN_SKIP_CANCELDTE_CHECK]
ARUNIGNOREBATCHCHECK, -- Ignore Batch Check [ARUN_SKIP_BATCH_CHECK]
ARUNINCLUDEINCMPLTORDCHK, -- Incomplete Orders [ARUN_INCMPLT_ORDCHK]
ARUNIGNOREPASTCANCLNDATECHECK, -- Ignr Past Cancln Dte [ARUN_SKIP_PAST_CANCEL_DATE_CHK]
ARUNCONFBSDSEGMTNISSELD, -- Con-based Seg & Prio [ARUN_CONF_SEG_PRIO]
PRIMARY KEY (MANDT, ARUNRULEUUID)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA