P_CATSDATAWITHCATEGORY

CDS View
18 Fields 4 CDS Views

P_CATSDATAWITHCATEGORY is a CDS View in S/4HANA. It contains 18 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_PMProjCatsDataKPI view left_outer COMPOSITE CATS Data of employees of a Project Manager for KPI Tile
I_TeamCatsHoursTile view left_outer COMPOSITE Team Recorded Hours for the Last Three Months
P_CATSRECHRSFORPROJANDNONPROJ view from COMPOSITE
P_PROJMGRCATSBYPO view from COMPOSITE

Fields (18)

KeyField CDS FieldsUsed in Views
KEY EmploymentInternalID EmploymentInternalID 2
AccountingIndicatorCode AccountingIndicatorCode 1
CalendarDate CalendarDate 1
CalendarMonth CalendarMonth 1
CalendarYear CalendarYear 1
EngagementProjFinPlanUUID EngagementProjFinPlanUUID 1
PurchaseOrder PurchaseOrder 1
PurchaseOrderItem PurchaseOrderItem 1
RecordedHours AttendanceHours,RecordedHours,TotalProductiveHours 3
Status Status 1
TaskCategory TaskCategory 2
TaskType TaskType 1
TimeSheetRecord TimeSheetRecord 1
UnitOfMeasure UnitOfMeasure 1
WorkItem WorkItem 1
WorkPackage WorkPackage 1
WorkPackageEndDate WorkPackageEndDate 1
WorkPackageStartDate WorkPackageStartDate 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 P_CATSDATAWITHCATEGORY (
    EMPLOYMENTINTERNALID,
    ACCOUNTINGINDICATORCODE,
    CALENDARDATE,
    CALENDARMONTH,
    CALENDARYEAR,
    ENGAGEMENTPROJFINPLANUUID,
    PURCHASEORDER,
    PURCHASEORDERITEM,
    RECORDEDHOURS,
    STATUS,
    TASKCATEGORY,
    TASKTYPE,
    TIMESHEETRECORD,
    UNITOFMEASURE,
    WORKITEM,
    WORKPACKAGE,
    WORKPACKAGEENDDATE,
    WORKPACKAGESTARTDATE,
    PRIMARY KEY (EMPLOYMENTINTERNALID)
);

Learn More