ARUN_SDO_ALLDOC is a standard SAP table in SAP ERP (or) S/4HANA which stores Table: Temporary Assignments for Supply Assignment data. There are total 42 fields in ARUN_SDO_ALLDOC table.This blog post provides key technical details of SAP table ARUN_SDO_ALLDOC, including its availability across SAP S/4HANA versions and the list of CDS views for ARUN_SDO_ALLDOC table in SAP.
SAP HANA Table Type | Column Store |
---|---|
Buffering Permission | Buffering not allowed |
Buffering Type | No buffering |
Package | Package for temporary supply assignment for all docuements (ARUN_ALLDOC_TEMP_ASSIGNMENTS) |
Technical Component | Order Allocation Run (LO-RFM-ARN) |
SAP ARUN_SDO_ALLDOC Table Fields
The following is the list of fields that are available in SAP ARUN_SDO_ALLDOC 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) | |
ARUNID | ARun GUID | ARUNID | SYSUUID | RAW (16) | |
PLANT | Plant | WERKS_D | WERKS | CHAR (4) | |
MATERIAL | Material Number | MATNR | MATNR | CHAR (40) | |
ARUN_STATUS | Supply Demand Overview Temporary Assignment Status | ARUN_SDO_ALLDOC_STAT | ARUN_SDO_ALLDOC_STAT | CHAR (1) | |
SALESDOC_NUM | Sales Document | ARUN_SALESDOC | VBELN | CHAR (10) | |
PURCHDOC_NUM | Purchasing requirement document | ARUN_PURCHDOC | EBELN | CHAR (10) | |
RESERV_NUM | Number of reservation/dependent requirements | RSNUM | RSNUM | NUMC (10) | |
SALESDOC_ITEM | Item number of the SD document | ARUN_SDITEM | POSNR | NUMC (6) | |
PURCHDOC_ITEM | Item Number of STO/Return PO | ARUN_PDITEM | EBELP | NUMC (5) | |
RESERV_ITEM | Item number of Reservation | ARUN_RSPOS | RSPOS | NUMC (4) | |
REQ_IND | Requirement Type for All Documents of Suppy Demand Overview | ARUN_SDO_ALLDOC_REQMT_TYPE | ARUN_SDO_ALLDOC_REQMT_TYPE | CHAR (2) | |
STOCK_IND | Supply Type for All Documents of Suppy Demand Overview | ARUN_SDO_ALLDOC_SUPPLY_TYPE | ARUN_SDO_ALLDOC_SUPPLY_TYPE | CHAR (1) | |
STOCK_SOURCE | Stock Source for All Documents of Supply Demand Overview | ARUN_SDO_ALLDOC_STOCK_SOURCE | ARUN_SDO_ALLDOC_STOCK_SOURCE | CHAR (1) | |
BATCH | Batch Number | CHARG_D | CHARG | CHAR (10) | |
STORAGE_LOCATION | Storage location | LGORT_D | LGORT | CHAR (4) | |
PURCHORD_NUM | Purchase Order number (Stock) | ARUN_PODOC | EBELN | CHAR (10) | |
PRODORD_NUM | Production number (Stock) | ARUN_AUFNR | AUFNR | CHAR (12) | |
RETSD_NUM | Return Sales Document | ARUN_RETSALESDOC | VBELN | CHAR (10) | |
PURCHORD_ITEM | Item number of Purchase Order | ARUN_POITM | EBELP | NUMC (5) | |
PRODORD_ITEM | Item number of Production Order | ARUN_COPOSNR | CO_POSNR | NUMC (4) | |
RETSD_ITEM | Item number of the Return Sales Document | ARUN_RETSDITM | POSNR | NUMC (6) | |
PURCHORD_SCH | Schedule Line number of Purchase Order | ARUN_POETENR | ETENR | NUMC (4) | |
RETSD_SCH | Schedule Line number of the Return Sales Document | ARUN_RETSDSCHDLN | ETENR | NUMC (4) | |
CONFIRMATION_NO | Sequential Number of Supplier Confirmation for ARun | ARUN_CONFETENS | NUM04 | NUMC (4) | |
CONSIGNMENT_NUM | Special stock consignment number | ARUN_SOBN | CHAR10 | CHAR (10) | |
ALLOC_QTY | Assigned Quantity by ARun | ARUN_ALLOC_QTY | MENG13 | QUAN (13) | |
MATERIAL_BASEUNIT | Base Unit of Measure | MEINS | MEINS | UNIT (3) | |
REQUESTED_DATE | Requested date | ARUN_REQDAT | DATUM | DATS (8) | |
MATERIAL_AVAIL_DATE | Material Staging/Availability Date | MBDAT | DATUM | DATS (8) | |
DELIVERY_DATE_PO | Confirmed Delivery Date for Future Receipts | ARUN_EDATP | DATUM | DATS (8) | |
PLNUM | Planned Order | PLNUM | PLNUM | CHAR (10) | |
PIR | Requirements Plan | PBDNR | CHAR10 | CHAR (10) | |
CONSUMED_QTY | Withdrawal Quantity | ENTMG | MENG13 | QUAN (13) | |
PIR_DATE | Requested date | ARUN_REQDAT | DATUM | DATS (8) | |
SUP_UUID | Time Bucket UUID | SUP_TIMEBUCKET_UUID | SYSUUID | RAW (16) | |
FPC_MATERIAL | Material Number | MATNR | MATNR | CHAR (40) | |
FPC_PLANT | Plant | WERKS_D | WERKS | CHAR (4) | |
OPENDEMAND_QTY | Quantity | MENGE_D | MENG13 | QUAN (13) | |
OPENSUPPLY_QTY | Quantity | MENGE_D | MENG13 | QUAN (13) | |
CREATION_TIME | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TIMESTAMP | TZNTSTMPS | DEC (15) | |
CHANGED_BY | Name of person who changed object | AENAM | USNAM | CHAR (12) |
Availability
The SAP table ARUN_SDO_ALLDOC 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_SDO_ALLDOC table
The following is the list of ARUN_SDO_ALLDOC CDS views, which can also be used instead of ARUN_SDO_ALLDOC table based on your business requirements.
CDS View | CDS View Type | Description |
---|---|---|
I_ARUNALLASSIGNMENTS | BASIC | View for Supply Assignment Results |
I_ARUNALLDMNDASSGMT | BASIC | Assignment Qty at Demand level |
I_ARUNALLSUPASSGMT | BASIC | Assignment Qty at Stock level |
I_SUPDMNDALLDOCCNSMPN | BASIC | View for Document Consumption |
I_ARUNANLYTSALLASSGMTCUBE | COMPOSITE | Demand and Assignments |
I_ARUNANLYTSALLASSGMTQUERY | COMPOSITE | Demand and Assignments |
I_ARUNANLYTSPURGCONTRCUBE | COMPOSITE | Purchasing Contract Details |
I_ARUNANLYTSSLSCONTRCUBE | COMPOSITE | Contract Details |
I_ARUNANLYTSSUPASSGMTCUBE | COMPOSITE | Assignment Results |
I_ARUNANLYTSSUPDMNDOVWCUBE | COMPOSITE | Overview of Supply and Demand |
I_ARUNANLYTSTOTDMNDCUBE | COMPOSITE | Supply Assignment Total Demand |
I_ARUNANLYTSTOTSUPCUBE | COMPOSITE | Total Supply of all Document Types |
I_SUPDMNDALLDOC3RDPTYORDASSGC | COMPOSITE | Cube View for Third Party Orders Assignment Details |
I_SUPDMNDALLDOC3RDPTYORDCUBE | COMPOSITE | Cube View for Third Party Orders |
I_SUPDMNDALLDOCASSGMT | COMPOSITE | View for Assignment for all Modes |
I_SUPDMNDALLDOCASSGMTCUBE | COMPOSITE | Cube View for Assignment for all Modes |
I_SUPDMNDALLDOCBATSTKASSGC | COMPOSITE | Cube View for Batch Stock Assignment Details |
I_SUPDMNDALLDOCBATSTKC | COMPOSITE | Cube View for Batch Stock Details |
I_SUPDMNDALLDOCCNSMPNCUBE | COMPOSITE | Cube View for Planned Independent Requirement Consumption |
I_SUPDMNDALLDOCCONFASSGC | COMPOSITE | Cube View for Supplier Confirmations Assignment Details |
I_SUPDMNDALLDOCCONFCUBE | COMPOSITE | Cube View for Supplier Confirmations Details |
I_SUPDMNDALLDOCCONTRASSGC | COMPOSITE | Cube View for Contract Assignment Details |
I_SUPDMNDALLDOCCONTRCUBE | COMPOSITE | Cube View for Contract Details |
I_SUPDMNDALLDOCMAKETOORDASSGC | COMPOSITE | Cube View for Make To Order Assignment Details |
I_SUPDMNDALLDOCMAKETOORDCUBE | COMPOSITE | Cube View for Make To Order Details |
I_SUPDMNDALLDOCNONBATSTKASSGC | COMPOSITE | Cube View for Non Batch Stock Assignment Details |
I_SUPDMNDALLDOCNONBATSTKC | COMPOSITE | Cube View for Non Batch Stock Details |
I_SUPDMNDALLDOCOVWCUBE | COMPOSITE | Cube View for Overview of Supply and Demand |
I_SUPDMNDALLDOCPHYSSTKASSGC | COMPOSITE | Cube View for Physical Stock Assignment Details |
I_SUPDMNDALLDOCPHYSSTKC | COMPOSITE | Cube View for Physical Stock Details |
I_SUPDMNDALLDOCPLNDINDEPRQMT1C | COMPOSITE | Cube View for Planned Independent Requirement Assignments |
I_SUPDMNDALLDOCPLNDINDEPRQMTC | COMPOSITE | Cube View for Planned Independent Requirement Details |
I_SUPDMNDALLDOCPLNDORDASSGC | COMPOSITE | Cube View for Planned Order Assignment Details |
I_SUPDMNDALLDOCPLNDORDCOMP1C | COMPOSITE | Cube View for Planned Order Components Assignment Details |
I_SUPDMNDALLDOCPLNDORDCOMPC | COMPOSITE | Cube View for Planned Order Components |
I_SUPDMNDALLDOCPLNDORDCUBE | COMPOSITE | Cube View for Planned Order Details |
I_SUPDMNDALLDOCPOASSGC | COMPOSITE | Cube View for Purchase Order Assignment Details |
I_SUPDMNDALLDOCPOCUBE | COMPOSITE | Cube View for Purchase Order Details |
I_SUPDMNDALLDOCPRODNORDASSGC | COMPOSITE | Cube View for Production Order Assignment Details |
I_SUPDMNDALLDOCPRODNORDC | COMPOSITE | Cube View for Production Order Details |
I_SUPDMNDALLDOCPRODNORDCOMP1C | COMPOSITE | Cube View for Production Order Components Assignment Details |
I_SUPDMNDALLDOCPRODNORDCOMPC | COMPOSITE | Cube View for Production Order Components |
I_SUPDMNDALLDOCPURGCONTRASSGC | COMPOSITE | Cube View for Purchasing Contract Assignment Details |
I_SUPDMNDALLDOCPURGCONTRC | COMPOSITE | Cube View for Purchasing Contract Details |
I_SUPDMNDALLDOCPURORDCOMP1C | COMPOSITE | Cube View for Sub Contracting PO Components Assignments |
I_SUPDMNDALLDOCPURORDCOMPC | COMPOSITE | Cube View for Sub Contracting Purchase Order Components |
I_SUPDMNDALLDOCPURREQNASSGC | COMPOSITE | Cube View for Purchase Requisition Assignment Details |
I_SUPDMNDALLDOCPURREQNCOMP1C | COMPOSITE | Cube View for Sub Contracting PR Components Assignments |
I_SUPDMNDALLDOCPURREQNCOMPC | COMPOSITE | Cube View for Sub Contracting Purchase Requisition Component |
I_SUPDMNDALLDOCPURREQNCUBE | COMPOSITE | Cube View for Purchase Requisition Details |
I_SUPDMNDALLDOCPURTOORDASSGC | COMPOSITE | Cube View for Purchase To Order Assignment Details |
I_SUPDMNDALLDOCPURTOORDCUBE | COMPOSITE | Cube View for Purchase To Order Details |
I_SUPDMNDALLDOCRETDELIVASSGC | COMPOSITE | Cube View for Return Deliveries Assignment Details |
I_SUPDMNDALLDOCRETDELIVC | COMPOSITE | Cube View for Return Deliveries Details |
I_SUPDMNDALLDOCRETSLSORDASSGC | COMPOSITE | Cube View for Return Sales Orders Assignment Details |
I_SUPDMNDALLDOCRETSLSORDC | COMPOSITE | Cube View for Return Sales Orders Details |
I_SUPDMNDALLDOCRETSSUPASSGC | COMPOSITE | Cube View for Returns from PO/STO Assignment Details |
I_SUPDMNDALLDOCRETSSUPC | COMPOSITE | Cube View for Returns from PO/STO |
I_SUPDMNDALLDOCSLSORDASSGC | COMPOSITE | Cube View for Sales Order Assignment Details |
I_SUPDMNDALLDOCSLSORDCUBE | COMPOSITE | Cube View for Sales Order Details |
I_SUPDMNDALLDOCSTKTRANSPTREQ1C | COMPOSITE | Cube View for Stock Transport Requisition Assignment Details |
I_SUPDMNDALLDOCSTKTRANSPTREQNC | COMPOSITE | Cube View for Stock Transport Requisition Details |
I_SUPDMNDALLDOCSTOASSGC | COMPOSITE | Cube View for Stock Transport Order Assignment Details |
I_SUPDMNDALLDOCSTOCUBE | COMPOSITE | Cube View for Stock Transport Order Details |
I_SUPDMNDALLDOCSUPPROT1C | COMPOSITE | Supply Protection Assignment Details |
I_SUPDMNDALLDOCSUPPROTC | COMPOSITE | Supply Protection relevant for Supply Assignment |
I_SUPDMNDALLDOCTOTDMND | COMPOSITE | View for Total Demand of All Document Types |
I_SUPDMNDALLDOCTOTDMNDCUBE | COMPOSITE | Cube View for Total Demand of All Document Types |
I_SUPDMNDALLDOCTOTSUP | COMPOSITE | View for Total Supply of All Document Types |
I_SUPDMNDALLDOCTOTSUPCUBE | COMPOSITE | Cube View for Total Supply of All Document Types |
I_SUPDMNDOVWPGCUSTRETSC | COMPOSITE | Cube View for Customer Returns |
I_SUPDMNDOVWPGTOTDMNDC | COMPOSITE | Cube View for Total Demand of All Document Types |
I_SUPDMNDOVWPGTOTSUPC | COMPOSITE | Cube View for Total Supply of all Sources |
P_ARUNASSGMTDMND | COMPOSITE | View for Supply Assignment Results from Demand Perspective |
P_ARUNASSGMTDMNDTYPE | COMPOSITE | View for Assignments from Supply and Demand Type Perspective |
P_ARUNASSGMTSUP | COMPOSITE | View for Supply Assignment Results from Supply Perspective |
P_ARUNASSGMTSUPTYPE | COMPOSITE | View for Assignments from Demand and Supply Type Perspective |
P_SUPDMNDALLDOCCNSMPN | COMPOSITE | View for Consumption from Demand Perspective |
P_SUPDMNDALLDOCOVW | COMPOSITE | Overview of Demand and Supply |
P_SUPDMNDALLDOCPHYSSTK | COMPOSITE | View for Physical Stock Details |
P_SUPDMNDALLDOCPHYSSTKASSG | COMPOSITE | View for Physical Stock Assignment Details |
C_ARUNANLYTSALLASSGMTQUERY | CONSUMPTION | Demand and Assignments |
C_ARUNANLYTSPURGCONTRQRY | CONSUMPTION | Purchasing Contract Details Query |
C_ARUNANLYTSSLSCONTRQRY | CONSUMPTION | Contract Consumption Quantities |
C_ARUNANLYTSSUPASSGMTQRY | CONSUMPTION | Consumption View for Assignments |
C_ARUNANLYTSSUPDMNDOVWQRY | CONSUMPTION | Overview of Supply and Demand Query |
C_ARUNANLYTSTOTDMNDQRY | CONSUMPTION | Consumption View for Total Demand |
C_ARUNANLYTSTOTSUPQRY | CONSUMPTION | Total Supply of all Document Types Query |
C_SUPDMNDALLDOC3RDPTYORDASSGQ | CONSUMPTION | Query View for Third Party Orders Assignment Details |
C_SUPDMNDALLDOC3RDPTYORDQRY | CONSUMPTION | Query View for Third Party Orders |
C_SUPDMNDALLDOCASSGMTQRY | CONSUMPTION | Query View for Assignment for all Modes |
C_SUPDMNDALLDOCBATSTKASSGQ | CONSUMPTION | Query View for Batch Stock Assignment Details |
C_SUPDMNDALLDOCBATSTKQ | CONSUMPTION | Query View for Batch Stock Details |
C_SUPDMNDALLDOCCNSMPNQUERY | CONSUMPTION | Query View for Planned Independent Requirement Consumption |
C_SUPDMNDALLDOCCONFASSGQ | CONSUMPTION | Query View for Supplier Confirmations Assignment Details |
C_SUPDMNDALLDOCCONFQRY | CONSUMPTION | Query View for Supplier Confirmations Details |
C_SUPDMNDALLDOCCONTRASSGQ | CONSUMPTION | Query View for Contract Assignment Details |
C_SUPDMNDALLDOCCONTRQRY | CONSUMPTION | Query View for Contract Details |
C_SUPDMNDALLDOCFILTER | CONSUMPTION | Filter View for Supply Demand Overview for All Documents |
C_SUPDMNDALLDOCMAKETOORDASSGQ | CONSUMPTION | Query View for Make To Order Assignment Details |
C_SUPDMNDALLDOCMAKETOORDQRY | CONSUMPTION | Query View for Make To Order Details |
C_SUPDMNDALLDOCNONBATSTKASSGQ | CONSUMPTION | Query View for Non Batch Stock Assignment Details |
C_SUPDMNDALLDOCNONBATSTKQ | CONSUMPTION | Query View for Non Batch Stock Details |
C_SUPDMNDALLDOCOVWQRY | CONSUMPTION | Query View for Overview of Supply and Demand |
C_SUPDMNDALLDOCPHYSSTKASSGQ | CONSUMPTION | Query View for Physical Stock Assignment Details |
C_SUPDMNDALLDOCPHYSSTKQ | CONSUMPTION | Query View for Physical Stock Details |
C_SUPDMNDALLDOCPLNDINDEPRQMT1Q | CONSUMPTION | Query View for Planned Independent Requirement Assignments |
C_SUPDMNDALLDOCPLNDINDEPRQMTQ | CONSUMPTION | Query View for Planned Independent Requirement Details |
C_SUPDMNDALLDOCPLNDORDASSGQ | CONSUMPTION | Query View for Planned Order Assignment Details |
C_SUPDMNDALLDOCPLNDORDCOMP1Q | CONSUMPTION | Query View for Planned Order Components Assignment Details |
C_SUPDMNDALLDOCPLNDORDCOMPQ | CONSUMPTION | Query View for Planned Order Components |
C_SUPDMNDALLDOCPLNDORDQRY | CONSUMPTION | Query View for Planned Order Details |
C_SUPDMNDALLDOCPOASSGQ | CONSUMPTION | Query View for Purchase Order Assignment Details |
C_SUPDMNDALLDOCPOQRY | CONSUMPTION | Query View for Purchase Order Details |
C_SUPDMNDALLDOCPRODNORDASSGQ | CONSUMPTION | Query View for Production Order Assignment Details |
C_SUPDMNDALLDOCPRODNORDCOMP1Q | CONSUMPTION | Query View for Production Order Components Assignment Detail |
C_SUPDMNDALLDOCPRODNORDCOMPQ | CONSUMPTION | Query View for Production Order Components |
C_SUPDMNDALLDOCPRODNORDQ | CONSUMPTION | Query View for Production Order Details |
C_SUPDMNDALLDOCPURGCONTRASSGQ | CONSUMPTION | Query View for Purchasing Contract Assignment Details |
C_SUPDMNDALLDOCPURGCONTRQ | CONSUMPTION | Query View for Purchasing Contract Details |
C_SUPDMNDALLDOCPURORDCOMP1Q | CONSUMPTION | Query View for Sub Contracting PO Components Assignments |
C_SUPDMNDALLDOCPURORDCOMPQ | CONSUMPTION | Query View for Sub Contracting Purchase Order Components |
C_SUPDMNDALLDOCPURREQNASSGQ | CONSUMPTION | Query View for Purchase Requisition Assignment Details |
C_SUPDMNDALLDOCPURREQNCOMP1Q | CONSUMPTION | Query View for Sub Contracting PR Components Assignments |
C_SUPDMNDALLDOCPURREQNCOMPQ | CONSUMPTION | Query View Sub Contracting Purchase Requisition Component |
C_SUPDMNDALLDOCPURREQNQRY | CONSUMPTION | Query View for Purchase Requisition Details |
C_SUPDMNDALLDOCPURTOORDASSGQ | CONSUMPTION | Query View for Purchase To Order Assignment Details |
C_SUPDMNDALLDOCPURTOORDQRY | CONSUMPTION | Query View for Purchase To Order Details |
C_SUPDMNDALLDOCRETDELIVASSGQ | CONSUMPTION | Query View for Return Deliveries Assignment Details |
C_SUPDMNDALLDOCRETDELIVQ | CONSUMPTION | Query View for Return Deliveries Details |
C_SUPDMNDALLDOCRETSLSORDASSGQ | CONSUMPTION | Query View for Return Sales Orders Assignment Details |
C_SUPDMNDALLDOCRETSLSORDQ | CONSUMPTION | Query View for Return Sales Orders Details |
C_SUPDMNDALLDOCRETSSUPASSGQ | CONSUMPTION | Query View for Returns from PO/STO Assignment Details |
C_SUPDMNDALLDOCRETSSUPQ | CONSUMPTION | Query View for Returns from PO/STO |
C_SUPDMNDALLDOCSLSORDASSGQ | CONSUMPTION | Query View for Sales Order Assignment Details |
C_SUPDMNDALLDOCSLSORDQRY | CONSUMPTION | Query View for Sales Order Details |
C_SUPDMNDALLDOCSTKTRANSPTREQ1Q | CONSUMPTION | Query View for Stock Transport Requisition Assignments |
C_SUPDMNDALLDOCSTKTRANSPTREQNQ | CONSUMPTION | Query View for Stock Transport Requisition Details |
C_SUPDMNDALLDOCSTOASSGQ | CONSUMPTION | Cube View for Stock Transport Order Assignment Details |
C_SUPDMNDALLDOCSTOQRY | CONSUMPTION | Query View for Stock Transport Order Details |
C_SUPDMNDALLDOCSUPPROT1Q | CONSUMPTION | Supply Protection Assignment Details |
C_SUPDMNDALLDOCSUPPROTQ | CONSUMPTION | Supply Protection relevant for Supply Assignment |
C_SUPDMNDALLDOCTOTDMNDQRY | CONSUMPTION | Query View for Total Demand of All Document Types |
C_SUPDMNDALLDOCTOTSUPQRY | CONSUMPTION | Query View for Total Supply of All Document Types |
C_SUPDMNDOVWPGALLDOCASSGMTQ | CONSUMPTION | View for Assignments from Normal, Preview and Temporary Mode |
C_SUPDMNDOVWPGCUSTRETSQ | CONSUMPTION | View for Customer Returns Query |
C_SUPDMNDOVWPGFLTR | CONSUMPTION | Supply and Demand Cockpit Filter |
C_SUPDMNDOVWPGPURGCONTRQ | CONSUMPTION | Query View for Purchasing Contract |
C_SUPDMNDOVWPGSLSCONTRQ | CONSUMPTION | Query View for Sales Contract |
C_SUPDMNDOVWPGSUPPROTQ | CONSUMPTION | Query View for Supply Protection Details |
C_SUPDMNDOVWPGTOTDMNDQ | CONSUMPTION | Consumption View for Total Demand of All Document Types |
C_SUPDMNDOVWPGTOTSUPQ | CONSUMPTION | Consumption View for Total Supply of all Sources |