ARUNI_STO_LINE
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| ARUNI_STO_STKSEL | view | from | STO as stock selections |
Fields (35)
| Key | Field | CDS Fields | Used 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
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA