SNWD_GI_I
EPM: Goods Issue Item Table
SNWD_GI_I is an SAP database table in S/4HANA. EPM: Goods Issue Item Table. It contains 9 fields. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| SEPM_I_GoodsIssueItem | view | from | EPM Demo: Goods Issue Item | |
| sepm_sddl_goods_issue_item | view | from |
Fields (9)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | client | mandt | Client | |||
| KEY | node_key | snwd_node_key | Node Key | |||
| parent_key | snwd_node_key | Node Key | ||||
| so_item_guid | snwd_node_key | Node Key | ||||
| gi_item_pos | snwd_so_item_pos | Item Position | ||||
| quantity_unit | snwd_quantity_unit | Unit of Measure | ||||
| quantity | snwd_quantity | Quantity | ||||
| product_guid | snwd_node_key | Node Key | ||||
| _dataaging | data_temperature | Data Aging |
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.
-- EPM: Goods Issue Item Table
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SNWD_GI_I (
CLIENT, -- Client [mandt]
NODE_KEY, -- Node Key [snwd_node_key]
PARENT_KEY, -- Node Key [snwd_node_key]
SO_ITEM_GUID, -- Node Key [snwd_node_key]
GI_ITEM_POS, -- Item Position [snwd_so_item_pos]
QUANTITY_UNIT, -- Unit of Measure [snwd_quantity_unit]
QUANTITY, -- Quantity [snwd_quantity]
PRODUCT_GUID, -- Node Key [snwd_node_key]
_DATAAGING, -- Data Aging [data_temperature]
PRIMARY KEY (CLIENT, NODE_KEY)
);
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