I_WBSELEMENTVERSIONDATA

CDS View
66 Fields 3 CDS Views

WBS Element Version Data

I_WBSELEMENTVERSIONDATA is a CDS View in S/4HANA. WBS Element Version Data. It contains 66 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
C_WBSElementVersForGraph view from CONSUMPTION WBS Element For Graph
C_WBSElmntVersGraphOverview view from CONSUMPTION Overview of WBS Element Version for Graph
P_ProjSchedWBSElemVersAttrib view from COMPOSITE

Fields (66)

KeyField CDS FieldsUsed in Views
KEY Version Version 1
KEY WBSElementInternalID WBSElementInternalID 1
ActualDuration ActualDuration 2
ActualDurationUnit ActualDurationUnit 2
ActualEndDate ActualEndDate 2
ActualStartDate ActualStartDate 2
ApplicantName ApplicantName 1
BasicDuration BasicDuration 2
BasicDurationUnit BasicDurationUnit 2
BasicEndDate BasicEndDate 2
BasicStartDate BasicStartDate 2
CompanyCode CompanyCode 1
ControllingArea ControllingArea 1
CostCenter CostCenter 2
CreatedByUser CreatedByUser 1
CreationDate CreationDate 1
Currency Currency 1
ForecastedDuration ForecastedDuration 2
ForecastedDurationUnit ForecastedDurationUnit 2
ForecastedEndDate ForecastedEndDate 2
ForecastedStartDate ForecastedStartDate 2
FreeDefinedAmount1 FreeDefinedAmount1 1
FreeDefinedAmount1Currency FreeDefinedAmount1Currency 2
FreeDefinedAmount2 FreeDefinedAmount2 1
FreeDefinedAmount2Currency FreeDefinedAmount2Currency 2
FreeDefinedAttribute01 FreeDefinedAttribute01 2
FreeDefinedAttribute02 FreeDefinedAttribute02 2
FreeDefinedAttribute03 FreeDefinedAttribute03 2
FreeDefinedAttribute04 FreeDefinedAttribute04 2
FreeDefinedDate1 FreeDefinedDate1 2
FreeDefinedDate2 FreeDefinedDate2 2
FreeDefinedIndicator1 FreeDefinedIndicator1 2
FreeDefinedIndicator2 FreeDefinedIndicator2 2
FreeDefinedQuantity1 FreeDefinedQuantity1 2
FreeDefinedQuantity1Unit FreeDefinedQuantity1Unit 2
FreeDefinedQuantity2 FreeDefinedQuantity2 2
FreeDefinedQuantity2Unit FreeDefinedQuantity2Unit 2
FreeDefinedTableFieldSemantic FreeDefinedTableFieldSemantic 1
IsMarkedForDeletion IsMarkedForDeletion 1
LastChangeDate LastChangeDate 1
LatestSchedldFcstdEndDate LatestSchedldFcstdEndDate 2
LatestSchedldFcstdStartDate LatestSchedldFcstdStartDate 2
Plant Plant 2
PriorityCode PriorityCode 1
ProfitCenter ProfitCenter 1
ProjectInternalID ProjectInternalID 2
ProjectType ProjectType 2
RespCostCenterControllingArea RespCostCenterControllingArea 1
ResponsibleCostCenter ResponsibleCostCenter 2
ResponsiblePerson ResponsiblePerson 1
ResponsiblePersonName ResponsiblePersonName 2
SchedldBasicEarliestEndDate SchedldBasicEarliestEndDate 2
SchedldBasicEarliestStartDate SchedldBasicEarliestStartDate 2
SchedldBasicLatestStartDate SchedldBasicLatestStartDate 2
SchedldFcstdEarliestEndDate SchedldFcstdEarliestEndDate 2
SchedldFcstdEarliestStartDate SchedldFcstdEarliestStartDate 2
ScheduledBasicLatestEndDate ScheduledBasicLatestEndDate 2
TentativeActualEndDate TentativeActualEndDate 1
TentativeActualStartDate TentativeActualStartDate 1
WBSDescription WBSDescription 2
WBSElementExternalID WBSElementExternalID 1
WBSElementHierarchyLevel WBSElementHierarchyLevel 2
WBSElementIsBillingElement WBSElementIsBillingElement 2
WBSElementIsPlanningElement WBSElementIsPlanningElement 2
WBSElementObject WBSElementObject 2
WBSIsAccountAssignmentElement WBSIsAccountAssignmentElement 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.

-- WBS Element Version Data
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_WBSELEMENTVERSIONDATA (
    VERSION,
    WBSELEMENTINTERNALID,
    ACTUALDURATION,
    ACTUALDURATIONUNIT,
    ACTUALENDDATE,
    ACTUALSTARTDATE,
    APPLICANTNAME,
    BASICDURATION,
    BASICDURATIONUNIT,
    BASICENDDATE,
    BASICSTARTDATE,
    COMPANYCODE,
    CONTROLLINGAREA,
    COSTCENTER,
    CREATEDBYUSER,
    CREATIONDATE,
    CURRENCY,
    FORECASTEDDURATION,
    FORECASTEDDURATIONUNIT,
    FORECASTEDENDDATE,
    FORECASTEDSTARTDATE,
    FREEDEFINEDAMOUNT1,
    FREEDEFINEDAMOUNT1CURRENCY,
    FREEDEFINEDAMOUNT2,
    FREEDEFINEDAMOUNT2CURRENCY,
    FREEDEFINEDATTRIBUTE01,
    FREEDEFINEDATTRIBUTE02,
    FREEDEFINEDATTRIBUTE03,
    FREEDEFINEDATTRIBUTE04,
    FREEDEFINEDDATE1,
    FREEDEFINEDDATE2,
    FREEDEFINEDINDICATOR1,
    FREEDEFINEDINDICATOR2,
    FREEDEFINEDQUANTITY1,
    FREEDEFINEDQUANTITY1UNIT,
    FREEDEFINEDQUANTITY2,
    FREEDEFINEDQUANTITY2UNIT,
    FREEDEFINEDTABLEFIELDSEMANTIC,
    ISMARKEDFORDELETION,
    LASTCHANGEDATE,
    LATESTSCHEDLDFCSTDENDDATE,
    LATESTSCHEDLDFCSTDSTARTDATE,
    PLANT,
    PRIORITYCODE,
    PROFITCENTER,
    PROJECTINTERNALID,
    PROJECTTYPE,
    RESPCOSTCENTERCONTROLLINGAREA,
    RESPONSIBLECOSTCENTER,
    RESPONSIBLEPERSON,
    RESPONSIBLEPERSONNAME,
    SCHEDLDBASICEARLIESTENDDATE,
    SCHEDLDBASICEARLIESTSTARTDATE,
    SCHEDLDBASICLATESTSTARTDATE,
    SCHEDLDFCSTDEARLIESTENDDATE,
    SCHEDLDFCSTDEARLIESTSTARTDATE,
    SCHEDULEDBASICLATESTENDDATE,
    TENTATIVEACTUALENDDATE,
    TENTATIVEACTUALSTARTDATE,
    WBSDESCRIPTION,
    WBSELEMENTEXTERNALID,
    WBSELEMENTHIERARCHYLEVEL,
    WBSELEMENTISBILLINGELEMENT,
    WBSELEMENTISPLANNINGELEMENT,
    WBSELEMENTOBJECT,
    WBSISACCOUNTASSIGNMENTELEMENT,
    PRIMARY KEY (VERSION, WBSELEMENTINTERNALID)
);

Learn More