_ROOT

29 Fields

_ROOT is an SAP database table in S/4HANA. It contains 29 fields.

Fields (29)

KeyField CDS FieldsUsed in Views
_Scenario _Scenario 1
AuthorizationGroup AuthorizationGroup 4
badi_name extension_point_id 1
CDOCategory CDOCategory 4
CDOName CDOName 4
CompanyCode CompanyCode 1
DomainText ExpnPlngRootDocObjectTypeText 1
EnterpriseProjectType EnterpriseProjectType 1
goal MDChgProcessGoal 19
lifecycle_status lifecycle_status 1
MDChgProcessGoal MDChgProcessGoal 4
MDChgProcessTypeID MDChgProcessTypeID 3
MfgActionReasonCodeGroupCtlg MfgActionReasonCodeGroupCtlg 1
MPN MPN 4
OverallProjectStsCriticality OverallProjectStsCriticality 2
Project Project 6
ProjectDemandEndDate ProjectDemandEndDate 2
ProjectDemandStartDate ProjectDemandStartDate 2
ProjectName ProjectDescription,ProjectName 6
ProjectProfileCode ProjectProfileCode 1
ProjectType ProjectType 4
ReferencedObjectUUID ReferencedObjectUUID 2
Scenario Scenario 2
SelfKey CDOKey 4
status MDChgProcessStatus 4
SupplierName SupplierName 4
SupplierNumber SupplierNumber 4
transported transported 1
type_id MDChgProcessTypeID 19

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 _ROOT (
    _SCENARIO,
    AUTHORIZATIONGROUP,
    BADI_NAME,
    CDOCATEGORY,
    CDONAME,
    COMPANYCODE,
    DOMAINTEXT,
    ENTERPRISEPROJECTTYPE,
    GOAL,
    LIFECYCLE_STATUS,
    MDCHGPROCESSGOAL,
    MDCHGPROCESSTYPEID,
    MFGACTIONREASONCODEGROUPCTLG,
    MPN,
    OVERALLPROJECTSTSCRITICALITY,
    PROJECT,
    PROJECTDEMANDENDDATE,
    PROJECTDEMANDSTARTDATE,
    PROJECTNAME,
    PROJECTPROFILECODE,
    PROJECTTYPE,
    REFERENCEDOBJECTUUID,
    SCENARIO,
    SELFKEY,
    STATUS,
    SUPPLIERNAME,
    SUPPLIERNUMBER,
    TRANSPORTED,
    TYPE_ID
);

Learn More