ARUNI_STO_LINE

CDS View

PO selection at date level

ARUNI_STO_LINE is a CDS View in S/4HANA. PO selection at date level. It contains 35 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
ARUNI_STO_STKSEL view from STO as stock selections

Fields (35)

KeyField CDS FieldsUsed in Views
attyp attyp 1
color color 1
color_atinn color_atinn 1
company_code company_code 1
delv_date delv_date 1
fsh_mg_at1 fsh_mg_at1 1
fsh_mg_at2 fsh_mg_at2 1
fsh_mg_at3 fsh_mg_at3 1
material material 1
materialbaseunit materialbaseunit 1
matkl matkl 1
plant plant 1
po_arrival_date po_arrival_date 1
PurchDocDate PurchDocDate 1
PurchDocType PurchDocType 1
purchord_item purchord_item 1
purchord_num purchord_num 1
purchord_sch purchord_sch 1
quantity StockQty 1
reslo reslo 1
reswk reswk 1
satnr satnr 1
SCollection SCollection 1
Season Season 1
SeasonYear SeasonYear 1
sgt_scat sgt_scat 1
size1 size1 1
size1_atinn size1_atinn 1
size2 size2 1
size2_atinn size2_atinn 1
StockSegment StockSegment 1
StorageLocation StorageLocation 1
Supplier Supplier 1
theme theme 1
webaz webaz 1

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.

-- PO selection at date level
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ARUNI_STO_LINE (
    ATTYP,
    COLOR,
    COLOR_ATINN,
    COMPANY_CODE,
    DELV_DATE,
    FSH_MG_AT1,
    FSH_MG_AT2,
    FSH_MG_AT3,
    MATERIAL,
    MATERIALBASEUNIT,
    MATKL,
    PLANT,
    PO_ARRIVAL_DATE,
    PURCHDOCDATE,
    PURCHDOCTYPE,
    PURCHORD_ITEM,
    PURCHORD_NUM,
    PURCHORD_SCH,
    QUANTITY,
    RESLO,
    RESWK,
    SATNR,
    SCOLLECTION,
    SEASON,
    SEASONYEAR,
    SGT_SCAT,
    SIZE1,
    SIZE1_ATINN,
    SIZE2,
    SIZE2_ATINN,
    STOCKSEGMENT,
    STORAGELOCATION,
    SUPPLIER,
    THEME,
    WEBAZ
);