C_RSHSTAFFINGREQUESTDATA

CDS View
34 Fields 1 CDS Views

Staffing Request Data without Parameters

C_RSHSTAFFINGREQUESTDATA is a CDS View in S/4HANA. Staffing Request Data without Parameters. It contains 34 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_RSHStaffingRequestForRes view left_outer CONSUMPTION Staffing Request for Resource

Fields (34)

KeyField CDS FieldsUsed in Views
_CategoryText _CategoryText 1
CityName CityName 1
Currency Currency 1
Customer Customer 1
CustomerAuthznGrp CustomerAuthznGrp 1
CustomerFullName CustomerFullName 1
EmployeeRequestDelivOrg EmployeeRequestDelivOrg 1
EmployeeRequestDuration EmployeeRequestDuration 1
EmployeeRequestProjMgrFullName EmployeeRequestProjMgrFullName 1
EmploymentInternalID EmploymentInternalID 1
EndDate EndDate 1
EngagementProject EngagementProject 1
EngagementProjectCategory EngagementProjectCategory 1
EngagementProjectName EngagementProjectName 1
EngagementProjectResource EngagementProjectResource 1
EngagementProjectStage EngagementProjectStage 1
EngmtProjectServiceOrgName EngmtProjectServiceOrgName 1
IsBusPrpsCmpltdCustomer IsBusPrpsCmpltdCustomer 1
IsBusPrpsCmpltdProjectManager IsBusPrpsCmpltdProjectManager 1
PlannedRevenueInPlnCrcy PlannedRevenueInPlnCrcy 1
PlanSkillTagDescription PlanSkillTagDescription 1
ProjectManager ProjectManager 1
ProjectManagerAuthznGrp ProjectManagerAuthznGrp 1
ProjectManagerExternalID ProjectManagerExternalID 1
ProjectVisibility ProjectVisibility 1
ResourceDemandUUID ResourceDemandUUID 1
Role Role 1
ServiceOrganization ServiceOrganization 1
StartDate StartDate 1
UnitOfMeasure UnitOfMeasure 1
WorkItem WorkItem 1
WorkItemName WorkItemName 1
WorkPackage WorkPackage 1
WorkPackageName WorkPackageName 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.

-- Staffing Request Data without Parameters
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE C_RSHSTAFFINGREQUESTDATA (
    _CATEGORYTEXT,
    CITYNAME,
    CURRENCY,
    CUSTOMER,
    CUSTOMERAUTHZNGRP,
    CUSTOMERFULLNAME,
    EMPLOYEEREQUESTDELIVORG,
    EMPLOYEEREQUESTDURATION,
    EMPLOYEEREQUESTPROJMGRFULLNAME,
    EMPLOYMENTINTERNALID,
    ENDDATE,
    ENGAGEMENTPROJECT,
    ENGAGEMENTPROJECTCATEGORY,
    ENGAGEMENTPROJECTNAME,
    ENGAGEMENTPROJECTRESOURCE,
    ENGAGEMENTPROJECTSTAGE,
    ENGMTPROJECTSERVICEORGNAME,
    ISBUSPRPSCMPLTDCUSTOMER,
    ISBUSPRPSCMPLTDPROJECTMANAGER,
    PLANNEDREVENUEINPLNCRCY,
    PLANSKILLTAGDESCRIPTION,
    PROJECTMANAGER,
    PROJECTMANAGERAUTHZNGRP,
    PROJECTMANAGEREXTERNALID,
    PROJECTVISIBILITY,
    RESOURCEDEMANDUUID,
    ROLE,
    SERVICEORGANIZATION,
    STARTDATE,
    UNITOFMEASURE,
    WORKITEM,
    WORKITEMNAME,
    WORKPACKAGE,
    WORKPACKAGENAME
);

Learn More