SUP_OBJECT
SUP Object
SUP_OBJECT is an SAP database table in S/4HANA. SUP Object. It contains 32 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 (32)
| 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 |
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]
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