Fields (41)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | business_context | business_context | 2 |
| KEY | BusinessContext | BusinessContext | 5 |
| KEY | cds_view_name | object_key | 1 |
| KEY | CDSViewName | CDSViewName | 3 |
| KEY | direct_union_suffix | Suffix | 1 |
| KEY | EntityName | EntityName | 2 |
| KEY | ExtensionIncludeViewName | ExtensionIncludeViewName | 1 |
| KEY | IDocTypeName | IDocTypeName | 1 |
| KEY | MdrDataTypeName | MdrDataTypeName | 1 |
| KEY | MessageDirection | MessageDirection | 1 |
| KEY | ModelName | modelName | 2 |
| KEY | node_name | NodeName | 1 |
| KEY | Operation | Operation | 1 |
| KEY | ServiceInterfaceName | ServiceInterfaceName | 1 |
| KEY | Successor | Successor,successor_object_key | 4 |
| KEY | union_suffix | Suffix | 1 |
| KEY | UnionSuffix | UnionSuffix | 3 |
| AddAutomatically | AddAutomatically | 1 | |
| ApiUsage | ApiUsage | 2 | |
| Availability | Availability | 6 | |
| BadiDefinitionForHidden | BadiDefinitionForHidden | 1 | |
| EmailUsage | EmailUsage | 1 | |
| EntityHasOwnText | EntityHasOwnText | 2 | |
| EntityImplementationType | EntityImplementationType | 2 | |
| FormUsage | FormUsage | 2 | |
| IsAnalyticalUsage | IsAnalyticalUsage | 1 | |
| IsApiUsage | IsApiUsage | 1 | |
| IsInvisible | IsInvisible | 1 | |
| MandatoryFieldEnabled | MandatoryFieldEnabled | 1 | |
| ModelNameWOVersion | ModelNameWOVersion | 1 | |
| ModelVersion | ModelVersion | 1 | |
| ReadOnlyFieldEnabled | ReadOnlyFieldEnabled | 1 | |
| ReleaseStatus | ReleaseStatus | 5 | |
| ScreenUsage | ScreenUsage | 3 | |
| SearchSupported | SearchSupported | 3 | |
| ServiceInterfaceType | ServiceInterfaceType | 1 | |
| UnderlyingViewName | UnderlyingViewName | 1 | |
| usage_form_template | FormUsage | 1 | |
| usage_ui_report | ScreenUsage | 1 | |
| ViewIsAlwaysEnabled | ViewIsAlwaysEnabled | 1 | |
| ViewType | ViewType | 1 |
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.
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE REGISTRY (
BUSINESS_CONTEXT,
BUSINESSCONTEXT,
CDS_VIEW_NAME,
CDSVIEWNAME,
DIRECT_UNION_SUFFIX,
ENTITYNAME,
EXTENSIONINCLUDEVIEWNAME,
IDOCTYPENAME,
MDRDATATYPENAME,
MESSAGEDIRECTION,
MODELNAME,
NODE_NAME,
OPERATION,
SERVICEINTERFACENAME,
SUCCESSOR,
UNION_SUFFIX,
UNIONSUFFIX,
ADDAUTOMATICALLY,
APIUSAGE,
AVAILABILITY,
BADIDEFINITIONFORHIDDEN,
EMAILUSAGE,
ENTITYHASOWNTEXT,
ENTITYIMPLEMENTATIONTYPE,
FORMUSAGE,
ISANALYTICALUSAGE,
ISAPIUSAGE,
ISINVISIBLE,
MANDATORYFIELDENABLED,
MODELNAMEWOVERSION,
MODELVERSION,
READONLYFIELDENABLED,
RELEASESTATUS,
SCREENUSAGE,
SEARCHSUPPORTED,
SERVICEINTERFACETYPE,
UNDERLYINGVIEWNAME,
USAGE_FORM_TEMPLATE,
USAGE_UI_REPORT,
VIEWISALWAYSENABLED,
VIEWTYPE,
PRIMARY KEY (BUSINESS_CONTEXT, BUSINESSCONTEXT, CDS_VIEW_NAME, CDSVIEWNAME, DIRECT_UNION_SUFFIX, ENTITYNAME, EXTENSIONINCLUDEVIEWNAME, IDOCTYPENAME, MDRDATATYPENAME, MESSAGEDIRECTION, MODELNAME, NODE_NAME, OPERATION, SERVICEINTERFACENAME, SUCCESSOR, UNION_SUFFIX, UNIONSUFFIX)
);
Learn More
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- 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