ARUN_PREVIEW

Transparent Table Application Table
34 Fields 17 CDS Views

Table: ARun Preview Requirement for Stock Assignment

ARUN_PREVIEW is an SAP database table in S/4HANA. Table: ARun Preview Requirement for Stock Assignment. It contains 34 fields. 17 CDS views read from this table.

CDS Views using this table (17)

ViewTypeJoinVDMDescription
ARUN_I_SO_REQMT_PREV view left_outer Sales Order selection from Preview table
ARUN_I_STAT_fut_prev view from Total AssignedQuantities at status level
ARUN_I_STAT_PLAN_ORD view from Assigned quantities aggregation at status level for Planned orders
ARUN_I_STAT_PR view from Assigned quantities aggregation at status level for Purchase Requisitions
ARUN_I_STO_REQMT_PREV view left_outer STO selection from Preview table
Arun_planord_bdbs_prv view from Total AssignedQuantity for planned order
Arun_Purchord_prev view from Aggregatation of assigned quantities for purchase orders in preview mode
Arun_Purchreq_Bdbs view from Aggregatation of assigned quantities for purchase requisition in preview mode
ARUN_SSD_PREV view from Get supply specific SO preview
ARUN_UNION_ALLOC view union Allocated quantity from preview and normal tables
ARUN_UNION_STO_ALLOC view union Allocated quanities for STO from normal and preview tables
I_ARunAllAssignments view union_all BASIC View for Supply Assignment Results
I_ARunAllDmndAssgmt view union_all BASIC Assignment Qty at Demand level
I_ARunAllSupAssgmt view union_all BASIC Assignment Qty at Stock level
I_ARunPreview view from BASIC Basic View for Preview Run data
I_SupDmndOvwSupplyAssignment view union_all BASIC Basic View for Supply Assignment
P_SupAssgmtPreview view from BASIC

Fields (34)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY arunid ARUNID ARun ID
plant WERKS_D Plant
material MATNR Material
arun_status ARUN_STAT ARun Status
salesdoc_num ARUN_SALESDOC Sales Document
purchdoc_num ARUN_PURCHDOC STO/RPO
reserv_num RSNUM Reservation
salesdoc_item ARUN_SDITEM SD Item
purchdoc_item ARUN_PDITEM Purch. Req Item
reserv_item ARUN_RSPOS Reservation Item
req_ind ARUN_BDART Requirement Type
stock_source ARUN_BSKZ Stock Source
batch CHARG_D Batch
storage_location LGORT_D Location
purchord_num ARUN_PODOC PO number
prodord_num ARUN_AUFNR Prod. Ord
purchord_item ARUN_POITM PO Item
prodord_item ARUN_COPOSNR Prod. Ord Item
purchord_sch ARUN_POETENR PO Schedule Line
confirmation_no ARUN_CONFETENS Sequential No.
consignment_num ARUN_SOBN Con. Ind
alloc_qty ARUN_ALLOC_QTY Assigned Qty
material_baseunit MEINS Base Unit
requested_date ARUN_REQDAT Requested date
material_avail_date MBDAT Mat.Avail.Date
delivery_date_po ARUN_EDATP Delivery Date PO
arun_mode ARUN_ARMD ARun Mode
creation_time TIMESTAMP Time Stamp
changed_by AENAM Changed By
mat_avail_date_mrp MBDAT Mat.Avail.Date
req_segment SGT_RCAT Req. Segment
stk_segment SGT_SCAT Stock Segment
plnum PLNUM Planned Order

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.

-- Table: ARun Preview Requirement for Stock Assignment
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ARUN_PREVIEW (
    MANDT,                -- Client [MANDT]
    ARUNID,               -- ARun ID [ARUNID]
    PLANT,                -- Plant [WERKS_D]
    MATERIAL,             -- Material [MATNR]
    ARUN_STATUS,          -- ARun Status [ARUN_STAT]
    SALESDOC_NUM,         -- Sales Document [ARUN_SALESDOC]
    PURCHDOC_NUM,         -- STO/RPO [ARUN_PURCHDOC]
    RESERV_NUM,           -- Reservation [RSNUM]
    SALESDOC_ITEM,        -- SD Item [ARUN_SDITEM]
    PURCHDOC_ITEM,        -- Purch. Req Item [ARUN_PDITEM]
    RESERV_ITEM,          -- Reservation Item [ARUN_RSPOS]
    REQ_IND,              -- Requirement Type [ARUN_BDART]
    STOCK_SOURCE,         -- Stock Source [ARUN_BSKZ]
    BATCH,                -- Batch [CHARG_D]
    STORAGE_LOCATION,     -- Location [LGORT_D]
    PURCHORD_NUM,         -- PO number [ARUN_PODOC]
    PRODORD_NUM,          -- Prod. Ord [ARUN_AUFNR]
    PURCHORD_ITEM,        -- PO Item [ARUN_POITM]
    PRODORD_ITEM,         -- Prod. Ord Item [ARUN_COPOSNR]
    PURCHORD_SCH,         -- PO Schedule Line [ARUN_POETENR]
    CONFIRMATION_NO,      -- Sequential No. [ARUN_CONFETENS]
    CONSIGNMENT_NUM,      -- Con. Ind [ARUN_SOBN]
    ALLOC_QTY,            -- Assigned Qty [ARUN_ALLOC_QTY]
    MATERIAL_BASEUNIT,    -- Base Unit [MEINS]
    REQUESTED_DATE,       -- Requested date [ARUN_REQDAT]
    MATERIAL_AVAIL_DATE,  -- Mat.Avail.Date [MBDAT]
    DELIVERY_DATE_PO,     -- Delivery Date PO [ARUN_EDATP]
    ARUN_MODE,            -- ARun Mode [ARUN_ARMD]
    CREATION_TIME,        -- Time Stamp [TIMESTAMP]
    CHANGED_BY,           -- Changed By [AENAM]
    MAT_AVAIL_DATE_MRP,   -- Mat.Avail.Date [MBDAT]
    REQ_SEGMENT,          -- Req. Segment [SGT_RCAT]
    STK_SEGMENT,          -- Stock Segment [SGT_SCAT]
    PLNUM,                -- Planned Order [PLNUM]
    PRIMARY KEY (MANDT, ARUNID)
);

Learn More