I_PROJECTWITHVERSION

CDS View
44 Fields 2 CDS Views

Project Definitions With Version

I_PROJECTWITHVERSION is a CDS View in S/4HANA. Project Definitions With Version. It contains 44 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
C_ProjectBasicInfo view from CONSUMPTION Project Basic Information
C_ProjectWithVersion view from CONSUMPTION Additional Selection - Project Definition

Fields (44)

KeyField CDS FieldsUsed in Views
KEY Project Project 1
KEY ProjectWithCodingMask Project,ProjectWithCodingMask 2
KEY Version Version 2
_ProjectApplicant _ProjectApplicant 1
_ProjectShortText _ProjectShortText 1
_ResponsiblePerson _ResponsiblePerson 1
ApplicantCode ApplicantCode 2
ApplicantName ApplicantName 2
BudgetProfile BudgetProfile 1
BusinessArea BusinessArea 2
CompanyCode CompanyCode 2
ControllingArea ControllingArea 2
ControllingObjectClass ControllingObjectClass 2
CostCenter CostCenter 2
CreatedByUser CreatedByUser 2
CreationDate CreationDate 2
Currency Currency 1
FactoryCalendar FactoryCalendar 2
ForecastedEndDate ForecastedEndDate 2
ForecastedStartDate ForecastedStartDate 2
FunctionalArea FunctionalArea 1
InvestmentProfile InvestmentProfile 1
IsMarkedForDeletion IsMarkedForDeletion 1
LastChangeDate LastChangeDate 2
LastChangedByUser LastChangedByUser 2
NetworkProfile NetworkProfile 1
ObjBasedAuthorizationIsActive ObjBasedAuthorizationIsActive 1
PlannedEndDate PlannedEndDate 2
PlannedStartDate PlannedStartDate 2
PlanningMethForProjBasicDate PlanningMethForProjBasicDate 1
PlanningMethForProjFcstdDate PlanningMethForProjFcstdDate 1
PlanningProfile PlanningProfile 1
Plant Plant 2
ProfitCenter ProfitCenter 2
ProjectHasOwnStock ProjectHasOwnStock 1
ProjectInternalID ProjectInternalID 2
ProjectObject ProjectObject 2
ProjectProfileCode ProjectProfileCode 2
ProjInterestCalcProfile ProjInterestCalcProfile 1
ResponsiblePerson ResponsiblePerson 2
ResponsiblePersonName ResponsiblePersonName 2
SchedulingDurationUnit SchedulingDurationUnit 1
WBSIsStatisticalWBSElement WBSIsStatisticalWBSElement 1
WBSSchedulingProfile WBSSchedulingProfile 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.

-- Project Definitions With Version
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PROJECTWITHVERSION (
    PROJECT,
    PROJECTWITHCODINGMASK,
    VERSION,
    _PROJECTAPPLICANT,
    _PROJECTSHORTTEXT,
    _RESPONSIBLEPERSON,
    APPLICANTCODE,
    APPLICANTNAME,
    BUDGETPROFILE,
    BUSINESSAREA,
    COMPANYCODE,
    CONTROLLINGAREA,
    CONTROLLINGOBJECTCLASS,
    COSTCENTER,
    CREATEDBYUSER,
    CREATIONDATE,
    CURRENCY,
    FACTORYCALENDAR,
    FORECASTEDENDDATE,
    FORECASTEDSTARTDATE,
    FUNCTIONALAREA,
    INVESTMENTPROFILE,
    ISMARKEDFORDELETION,
    LASTCHANGEDATE,
    LASTCHANGEDBYUSER,
    NETWORKPROFILE,
    OBJBASEDAUTHORIZATIONISACTIVE,
    PLANNEDENDDATE,
    PLANNEDSTARTDATE,
    PLANNINGMETHFORPROJBASICDATE,
    PLANNINGMETHFORPROJFCSTDDATE,
    PLANNINGPROFILE,
    PLANT,
    PROFITCENTER,
    PROJECTHASOWNSTOCK,
    PROJECTINTERNALID,
    PROJECTOBJECT,
    PROJECTPROFILECODE,
    PROJINTERESTCALCPROFILE,
    RESPONSIBLEPERSON,
    RESPONSIBLEPERSONNAME,
    SCHEDULINGDURATIONUNIT,
    WBSISSTATISTICALWBSELEMENT,
    WBSSCHEDULINGPROFILE,
    PRIMARY KEY (PROJECT, PROJECTWITHCODINGMASK, VERSION)
);

Learn More