I_WORKPERMITBASIC

CDS View
40 Fields 10 CDS Views

Work Permit

I_WORKPERMITBASIC is a CDS View in S/4HANA. Work Permit. It contains 40 fields. 10 CDS views read from this table.

CDS Views using this table (10)

ViewTypeJoinVDMDescription
I_WorkPermit view from COMPOSITE Work Permit
I_WorkPermitApprvlSgmt view inner BASIC Work Permit Approval Segment
I_WorkPermitIssueHistory view inner BASIC Hand Out Work Permit history
I_WorkPermitOrder view inner BASIC Work Permit Assigned Orders
I_WorkPermitSafetyCertificate view inner COMPOSITE Safety Certificate in Work Permit
I_WorkPermitStatus view inner BASIC Work Permit Status
I_WorkPermitTechnicalObject view inner BASIC Work Permit Technical Object
I_WorkPermitTemplate view from COMPOSITE Work Permit Template
I_WrkPmtTmplSftyCertTemplate view inner COMPOSITE Wrk Pmt Tmpl Sfty Cert Template
P_WorkPermitCube view from COMPOSITE Work Permit - Cube

Fields (40)

KeyField CDS FieldsUsed in Views
KEY WorkPermit WorkPermit 9
CreatedByUser CreatedByUser 2
CreationDate CreationDate 2
CreationDateTime CreationDateTime 2
CreationTime CreationTime 2
Equipment Equipment 2
FunctionalLocation FunctionalLocation 2
LastChangeDate LastChangeDate 2
LastChangeDateTime LastChangeDateTime 2
LastChangedByUser LastChangedByUser 2
LastChangeTime LastChangeTime 2
LongTextKey LongTextKey 2
MaintenancePlannerGroup MaintenancePlannerGroup 2
MaintenancePlanningPlant MaintenancePlanningPlant 4
ObjectTypeCode ObjectTypeCode 2
OperationWorkCenterInternalID OperationWorkCenterInternalID 2
PlantTimeZone PlantTimeZone 1
StatusProfile StatusProfile 2
TechObjAuthorizationGroup TechObjAuthorizationGroup 2
ValidFromDateTime ValidFromDateTime 2
ValidToDateTime ValidToDateTime 2
WorkPermitHasLongText WorkPermitHasLongText 2
WorkPermitInternalID WorkPermitInternalID 2
WorkPermitOperationLongTextKey WorkPermitOperationLongTextKey 2
WorkPermitProcessingStatus WorkPermitProcessingStatus 3
WorkPermitTmplID WorkPermitTmplID 2
WorkPermitType WorkPermitType 3
WrkPermitDesc WrkPermitDesc 3
WrkPermitHasMaintRemark WrkPermitHasMaintRemark 2
WrkPermitHasObjectList WrkPermitHasObjectList 2
WrkPermitHasOpRemark WrkPermitHasOpRemark 2
WrkPermitIsDeleted WrkPermitIsDeleted 2
WrkPermitIsLinkdToDoc WrkPermitIsLinkdToDoc 2
WrkPermitValidFrmDate WrkPermitValidFrmDate 2
WrkPermitValidFrmTime WrkPermitValidFrmTime 2
WrkPermitValidToDate WrkPermitValidToDate 2
WrkPermitValidToTime WrkPermitValidToTime 2
WrkPmtMaintenanceLongTextKey WrkPmtMaintenanceLongTextKey 2
WrkPmtMgmtObjSubType WrkPmtMgmtObjSubType 4
WrkPmtMgmtPriority WrkPmtMgmtPriority 2

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.

-- Work Permit
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_WORKPERMITBASIC (
    WORKPERMIT,
    CREATEDBYUSER,
    CREATIONDATE,
    CREATIONDATETIME,
    CREATIONTIME,
    EQUIPMENT,
    FUNCTIONALLOCATION,
    LASTCHANGEDATE,
    LASTCHANGEDATETIME,
    LASTCHANGEDBYUSER,
    LASTCHANGETIME,
    LONGTEXTKEY,
    MAINTENANCEPLANNERGROUP,
    MAINTENANCEPLANNINGPLANT,
    OBJECTTYPECODE,
    OPERATIONWORKCENTERINTERNALID,
    PLANTTIMEZONE,
    STATUSPROFILE,
    TECHOBJAUTHORIZATIONGROUP,
    VALIDFROMDATETIME,
    VALIDTODATETIME,
    WORKPERMITHASLONGTEXT,
    WORKPERMITINTERNALID,
    WORKPERMITOPERATIONLONGTEXTKEY,
    WORKPERMITPROCESSINGSTATUS,
    WORKPERMITTMPLID,
    WORKPERMITTYPE,
    WRKPERMITDESC,
    WRKPERMITHASMAINTREMARK,
    WRKPERMITHASOBJECTLIST,
    WRKPERMITHASOPREMARK,
    WRKPERMITISDELETED,
    WRKPERMITISLINKDTODOC,
    WRKPERMITVALIDFRMDATE,
    WRKPERMITVALIDFRMTIME,
    WRKPERMITVALIDTODATE,
    WRKPERMITVALIDTOTIME,
    WRKPMTMAINTENANCELONGTEXTKEY,
    WRKPMTMGMTOBJSUBTYPE,
    WRKPMTMGMTPRIORITY,
    PRIMARY KEY (WORKPERMIT)
);

Learn More