SYCM_CUST_REFS
Object References
SYCM_CUST_REFS is an SAP database table in S/4HANA. Object References. It contains 19 fields. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| sycm_aps_c_cust_refs_vh | view | from | Value Help for custrefs | |
| Sycm_Simplification_View | view | inner | Join Simplification DB with SYCM_CUST_REFS, -ENHS and -MODS |
Fields (19)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | extraction_sysid | SYST_SYSID | SAP System ID | |||
| KEY | extraction_name | SYCM_EXTRACTION_NAME | Result Name | |||
| KEY | reference_kind | SYCM_REFERENCE_KIND | Category | |||
| KEY | hash | HASH160 | Hash Value | |||
| ref_obj_type | TROBJTYPE | Object Type | ||||
| ref_obj_name | SOBJ_NAME | Object Name | ||||
| ref_sub_type | TROBJTYPE | Object Type | ||||
| ref_sub_name | SOBJ_SNAME | Object name in SUBKEY | ||||
| ref_int_type | SEU_OBJTYP | Obj. Type | ||||
| ref_int_name | SEU_OBJKEY | Key for a Repository object | ||||
| obj_type | TROBJTYPE | Object Type | ||||
| obj_name | SOBJ_NAME | Object Name | ||||
| sub_type | TROBJTYPE | Object Type | ||||
| sub_name | SOBJ_SNAME | Object name in SUBKEY | ||||
| include_name | PROGNAME | Program Name | ||||
| devclass | DEVCLASS | Package | ||||
| genflag | GENFLAG | Generation Flag | ||||
| dlvunit | DLVUNIT | Softw. Comp. | ||||
| ref_appl_component | UFPS_POSID | Applic. Component |
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.
-- Object References
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SYCM_CUST_REFS (
EXTRACTION_SYSID, -- SAP System ID [SYST_SYSID]
EXTRACTION_NAME, -- Result Name [SYCM_EXTRACTION_NAME]
REFERENCE_KIND, -- Category [SYCM_REFERENCE_KIND]
HASH, -- Hash Value [HASH160]
REF_OBJ_TYPE, -- Object Type [TROBJTYPE]
REF_OBJ_NAME, -- Object Name [SOBJ_NAME]
REF_SUB_TYPE, -- Object Type [TROBJTYPE]
REF_SUB_NAME, -- Object name in SUBKEY [SOBJ_SNAME]
REF_INT_TYPE, -- Obj. Type [SEU_OBJTYP]
REF_INT_NAME, -- Key for a Repository object [SEU_OBJKEY]
OBJ_TYPE, -- Object Type [TROBJTYPE]
OBJ_NAME, -- Object Name [SOBJ_NAME]
SUB_TYPE, -- Object Type [TROBJTYPE]
SUB_NAME, -- Object name in SUBKEY [SOBJ_SNAME]
INCLUDE_NAME, -- Program Name [PROGNAME]
DEVCLASS, -- Package [DEVCLASS]
GENFLAG, -- Generation Flag [GENFLAG]
DLVUNIT, -- Softw. Comp. [DLVUNIT]
REF_APPL_COMPONENT, -- Applic. Component [UFPS_POSID]
PRIMARY KEY (EXTRACTION_SYSID, EXTRACTION_NAME, REFERENCE_KIND, HASH)
);
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