Tuesday, September 17, 2024

SAP Table ARUN_SDO_ALLDOC – Table: Temporary Assignments for Supply Assignment

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