ARUN_BDBS

Transparent Table Application Table
34 Fields 43 CDS Views

Table: ARun Requirement for Stock Assignment

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

CDS Views using this table (43)

ViewTypeJoinVDMDescription
ARUN_BDBS_CDS1 view from Supply Assignment view with semantic key
ARUN_BDBS_FULL view from Supply Assignment view with semantic key
Arun_Com_Ralloc view from Subcontrg PO/Prodn. Ord allocated qty
ARUN_CONF_SALLOC view from Purchase order allocated quantity
arun_i_c_agg view from ARun Status quantities aggregation at batch stock level
Arun_i_conf_bdbs view from Confirmation stock selection
ARUN_i_prod_bdbs view from Assigned quantities for Production orders
ARUN_i_prod_stat view from Assigned quantity aggregation at Status level for Production Orders
arun_i_s_agg view from ARun Status quantities aggregation at storage location stock level
arun_i_so_alloc view from Aggregation of Assigned quantities for SO
arun_i_so_p_alloc view from So Alloc aggregates Preview
arun_i_so_reqmt view left_outer Sales Order selection in Normal mode
ARUN_I_SO_STAT_QTY view from Total AssignedQuantities at status level
ARUN_I_STAT_FUTURE view from Assigned quantities aggregation at status level for future stock in Normal mode
arun_i_stat_physical view from Assigned quantities aggregation at status level for physical stock
arun_i_stk_bdbs view from Assigned quantities aggregation at status level for physical stock
ARUN_I_STO_Alloc view from Aggregation of Assigned quantities for STO
ARUN_i_sto_p_alloc view from STO Alloc aggregates Preview
Arun_I_Sto_Reqmt view left_outer STO selection for Normal mode
ARUN_I_STO_STAT_QTY view from Alloc qty aggreg at stat level for STO for normal allocation
Arun_Open_Delivery_C view union_all Supply Assignment open deliveries
Arun_Po_Ralloc view from Requirement Allocated Qty of STO/RPO
ARUN_PO_SALLOC view from Purchase order allocated quantity
Arun_Purchord_Bdbs view from Allocated purchase order aggregate
Arun_So_Alloc view from Requirement allocated Qty of sales order
ARUN_SO_BDBS_QTY view from Cummulated value at item
Arun_So_Ralloc view from Requirement Allocated Qty of Sales Order
ARUN_SSD_BG view from Get supply specific SO online
Arun_Sto_Reqmt view left_outer Stock Transport Order Requirement
Arun_Stock_Bdbs view from Aggregate of allocated stock -Sup Assgmt
ARUN_SUP_SP_SO view from Get supply specific SO online
ARun_ValAddedSrvcNormalAssgmt view from
ARUNI_L_XDOCK view from IFO Assignment delivered quantity
I_AlignPOSchedLineAllocQty view from BASIC Allocated Qty at PO schedule line level
I_ARunAllAssignments view from BASIC View for Supply Assignment Results
I_ARunAllDmndAssgmt view from BASIC Assignment Qty at Demand level
I_ARunAllSupAssgmt view from BASIC Assignment Qty at Stock level
I_ARunNormal view from BASIC Basic View for Normal Run data
I_SupDmndOvwSupplyAssignment view from BASIC Basic View for Supply Assignment
I_SupplyAssignmentBasic view from BASIC Basic View for Supply Assignment API
P_SupAssgmtNormal view from BASIC
rfm_psst_assign view left_outer PSST Assignment monitor view
rfm_psst_sto_assign view left_outer Assignment Monitor STO view

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
arun_source ARUN_SOURCE ARun Source

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 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_BDBS (
    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]
    ARUN_SOURCE,          -- ARun Source [ARUN_SOURCE]
    PRIMARY KEY (MANDT, ARUNID)
);

Learn More