SAP ABAP View SEPMV_SO (Erzeugt aus Ddl Source SEPM_CDS_SALES_ORDER)
Hierarchy
☛
SAP_BASIS (Software Component) SAP Basis Component
⤷
BC-SRV-NWD-XBR (Application Component) HANA Reference Applications
⤷
S_EPM_OIA_DATA_MODEL (Package) EPM OIA: CDS view representation of EPM entities
⤷
⤷
Basic Data
| View Type | D | Database View |
| Database View | SEPMV_SO | |
| Short Description | Erzeugt aus Ddl Source SEPM_CDS_SALES_ORDER | |
| Root table | SNWD_SO | EPM: Sales Order Header Table |
Table
| # | Table Name | Foreign Table | Foreign Field | Foreign DIR |
|---|---|---|---|---|
| 1 | SNWD_SO |
Join Conditions
| # | Table Name | Field Name | Negation | Operator | Constants | Cont. line | AND/OR | Offset | F Length | Mco Field |
|---|---|---|---|---|---|---|---|---|---|---|
View Fields
| # | View field | Table | Field | Maintenance Flag | Key | Data element | Mod | Short Description |
|---|---|---|---|---|---|---|---|---|
| 1 | CLIENT | MANDT | Client | |||||
| 2 | NODE_KEY | SNWD_NODE_KEY | EPM: Generic Node Key | |||||
| 3 | SO_ID | SNWD_SO_ID | EPM: Sales Order Number | |||||
| 4 | CREATED_BY | SNWD_NODE_KEY | EPM: Generic Node Key | |||||
| 5 | CREATED_AT | TIMESTAMPL | UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) | |||||
| 6 | CHANGED_BY | SNWD_NODE_KEY | EPM: Generic Node Key | |||||
| 7 | CHANGED_AT | TIMESTAMPL | UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) | |||||
| 8 | NOTE_GUID | SNWD_NODE_KEY | EPM: Generic Node Key | |||||
| 9 | CURRENCY_CODE | SNWD_CURR_CODE | EPM: Currency Code | |||||
| 10 | GROSS_AMOUNT | SNWD_TTL_GROSS_AMOUNT | EPM: Total Gross Amount | |||||
| 11 | NET_AMOUNT | SNWD_TTL_NET_AMOUNT | EPM: Total Net Amount | |||||
| 12 | TAX_AMOUNT | SNWD_TTL_TAX_AMOUNT | EPM: Total Tax Amount | |||||
| 13 | LIFECYCLE_STATUS | SNWD_SO_LC_STATUS_CODE | EPM: Sales Order Lifecycle Status | |||||
| 14 | BILLING_STATUS | SNWD_SO_CF_STATUS_CODE | EPM: Sales Order Confirmation Status | |||||
| 15 | DELIVERY_STATUS | SNWD_SO_OR_STATUS_CODE | EPM: Sales Order Ordering Status | |||||
| 16 | BUYER_GUID | SNWD_NODE_KEY | EPM: Generic Node Key | |||||
Maintenance Status
| read only |
| read and change |
| Time-dependent views: like U, validity data like ' ' |
| read, change, delete and insert |
| Delivery Class | ||
| Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
History
| Last changed by/on | DDIC | 20150523 |
| SAP Release Created in |