SUP_OBJECT
SUP Object
SUP_OBJECT is an SAP database table in S/4HANA. SUP Object. It contains 33 fields. 4 CDS views read from this table.
CDS Views using this table (4)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| E_SupAvailabilityProtPlan | view_entity | from | EXTENSION | Supply Protection Object - Extension |
| I_ARunSupplyProtection | view | from | BASIC | Supply Protection relevant for Supply Assignment |
| I_ARunSupProtCnsmpn | view | from | BASIC | Supply Protection Consumption Details |
| I_SupplyProtection | view_entity | from | BASIC | Supply Protection |
Fields (33)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | client | MANDT | Client | |||
| KEY | uuid | SUP_OBJECT_UUID | UUID | |||
| material | MATNR | Material | ||||
| plant | WERKS_D | Plant | ||||
| status | SUP_OBJECT_STATUS | Status | ||||
| planningperiodtype | SUP_PLANNING_PERIOD_TYPE | Planning Period Type | ||||
| planningperiodstart | SUP_PLANNING_PERIOD_START_DATE | Planning Start Date | ||||
| planningperiodend | SUP_PLANNING_PERIOD_END_DATE | Planning End Date | ||||
| corecharc01catalogpathuuid | SUP_CHARC_CATALOG_PATH_UUID | Catalog Path UUID | ||||
| corecharc01catalogpathid | SUP_CHARC_CATALOG_PATH_ID | Catalog Path Int. ID | ||||
| corecharc01value | SUP_CHARC_VALUE | Characteristic Value | ||||
| corecharc02catalogpathuuid | SUP_CHARC_CATALOG_PATH_UUID | Catalog Path UUID | ||||
| corecharc02catalogpathid | SUP_CHARC_CATALOG_PATH_ID | Catalog Path Int. ID | ||||
| corecharc02value | SUP_CHARC_VALUE | Characteristic Value | ||||
| name | SUP_OBJECT_NAME | Name | ||||
| catalogtype | SUP_CHARC_CATALOG_TYPE | Catalog Type | ||||
| planningcontextso | SUP_PLANNING_CONTEXT_SO | Sales Document | ||||
| planningcontextsto | SUP_PLANNING_CONTEXT_STO | Stock Transport Order | ||||
| creationdatetime | SUP_CREATION_DATE_TIME | Created On / At | ||||
| createdbyuser | VDM_CREATEDBYUSERID | Created By | ||||
| lastchangedatetime | SUP_LAST_CHANGE_DATE_TIME | Changed On / At | ||||
| lastchangedbyuser | VDM_LASTCHANGEDBYUSERID | Changed By | ||||
| charcvalauthzngroup | SUP_CHARCVALAUTHZNGRP | Authorization Group | ||||
| blocked | SUP_BLOCK | Blocked | ||||
| last_changed_at | TIMESTAMPL | Time Stamp | ||||
| autoactivation | SUP_AUTO_ACTIVATION | Activate Automatically | ||||
| autoactivationdate | SUP_AUTO_ACTIVATION_DATE | Activate On | ||||
| activationdate | SUP_ACTIVATION_DATE | Activation Date | ||||
| consumptiondatetype | SUP_CONSUMPTION_DATE_TYPE | Consumption Based On | ||||
| selfrestriction | SUP_SELF_RESTRICTION_TYPE | Restriction by Own Protection | ||||
| storagelocation | LGORT_D | Location | ||||
| planninglevel | SUP_PLANNING_LEVEL | Planning Level | ||||
| sup_object_incl_eew_ps | SUP_DUMMY | SUP Dummy |
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.
-- SUP Object
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SUP_OBJECT (
CLIENT, -- Client [MANDT]
UUID, -- UUID [SUP_OBJECT_UUID]
MATERIAL, -- Material [MATNR]
PLANT, -- Plant [WERKS_D]
STATUS, -- Status [SUP_OBJECT_STATUS]
PLANNINGPERIODTYPE, -- Planning Period Type [SUP_PLANNING_PERIOD_TYPE]
PLANNINGPERIODSTART, -- Planning Start Date [SUP_PLANNING_PERIOD_START_DATE]
PLANNINGPERIODEND, -- Planning End Date [SUP_PLANNING_PERIOD_END_DATE]
CORECHARC01CATALOGPATHUUID, -- Catalog Path UUID [SUP_CHARC_CATALOG_PATH_UUID]
CORECHARC01CATALOGPATHID, -- Catalog Path Int. ID [SUP_CHARC_CATALOG_PATH_ID]
CORECHARC01VALUE, -- Characteristic Value [SUP_CHARC_VALUE]
CORECHARC02CATALOGPATHUUID, -- Catalog Path UUID [SUP_CHARC_CATALOG_PATH_UUID]
CORECHARC02CATALOGPATHID, -- Catalog Path Int. ID [SUP_CHARC_CATALOG_PATH_ID]
CORECHARC02VALUE, -- Characteristic Value [SUP_CHARC_VALUE]
NAME, -- Name [SUP_OBJECT_NAME]
CATALOGTYPE, -- Catalog Type [SUP_CHARC_CATALOG_TYPE]
PLANNINGCONTEXTSO, -- Sales Document [SUP_PLANNING_CONTEXT_SO]
PLANNINGCONTEXTSTO, -- Stock Transport Order [SUP_PLANNING_CONTEXT_STO]
CREATIONDATETIME, -- Created On / At [SUP_CREATION_DATE_TIME]
CREATEDBYUSER, -- Created By [VDM_CREATEDBYUSERID]
LASTCHANGEDATETIME, -- Changed On / At [SUP_LAST_CHANGE_DATE_TIME]
LASTCHANGEDBYUSER, -- Changed By [VDM_LASTCHANGEDBYUSERID]
CHARCVALAUTHZNGROUP, -- Authorization Group [SUP_CHARCVALAUTHZNGRP]
BLOCKED, -- Blocked [SUP_BLOCK]
LAST_CHANGED_AT, -- Time Stamp [TIMESTAMPL]
AUTOACTIVATION, -- Activate Automatically [SUP_AUTO_ACTIVATION]
AUTOACTIVATIONDATE, -- Activate On [SUP_AUTO_ACTIVATION_DATE]
ACTIVATIONDATE, -- Activation Date [SUP_ACTIVATION_DATE]
CONSUMPTIONDATETYPE, -- Consumption Based On [SUP_CONSUMPTION_DATE_TYPE]
SELFRESTRICTION, -- Restriction by Own Protection [SUP_SELF_RESTRICTION_TYPE]
STORAGELOCATION, -- Location [LGORT_D]
PLANNINGLEVEL, -- Planning Level [SUP_PLANNING_LEVEL]
SUP_OBJECT_INCL_EEW_PS, -- SUP Dummy [SUP_DUMMY]
PRIMARY KEY (CLIENT, UUID)
);
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