I_WBSELEMENTBASICDATA

CDS View

WBS Element Basic Data

I_WBSELEMENTBASICDATA is a CDS View in S/4HANA. WBS Element Basic Data. It contains 47 fields. 88 CDS views read from this table.

CDS Views using this table (88)

ViewTypeJoinVDMDescription
A_FinWBSElement view from BASIC API FIN WBS Element Details
C_AllocationWBSElementVH view from CONSUMPTION WBS Element Company Code - Value Help
C_AssetWBSElement view from CONSUMPTION WBS Element in Asset
C_EvtBsdRevnRecgnProjMonitor view from CONSUMPTION EBRR Monitor: Project (2) - main CDS
C_MM_WBSElmntEngmntProjVH view_entity inner CONSUMPTION WBS element on Engagement Project
C_PurOrdWBSValHelp view from CONSUMPTION WBS Element Value Help
C_RunOverheadWBSElement view from CONSUMPTION Overhead Calculation WBS Element
C_RunSettlmtActualWBSElement view from CONSUMPTION Actual Settlement WBS Element
C_RunSettlmtActualWBSElementVH view from CONSUMPTION Run Settlement Actual WBSElement
C_SubscrpnMassProcgWBSElmntVH view_entity from CONSUMPTION WBS Element on Mass Processing
C_UnivAllocationWBSElementVH view_entity from CONSUMPTION Allocation WBS Element
FAC_AUDIT_Z3_WBSELEMENT view from WBS Element
FAC_CDS_UH_WBSElement view from WBS Element Details
finoc_hard_dependency_soi view_entity inner Orgl Change: SOI Hard Dependencies
finoc_hard_dependency_soi view_entity left_outer Orgl Change: SOI Hard Dependencies
FINOC_HARD_DEPENDENCY_WBS view_entity inner Orgl Change: WBS Hard Dependencies
FINOC_RT_WBS_FILL view inner Orgl Change: Fill Runtime for WBS Elmnt
FINOC_RULE_FA_BASE view inner Orgl Change: Fixed Asset Base
FINOC_RULE_WBS_DEFAULT_CE view inner OC: Default Rule WBS elmts, EPPM wR CE
I_BillingWBSBasicDataStdVH view from BASIC Value help view for I_WBSElementBasicData
I_EntProjProfnlSrvcBillgElmnt view_entity inner COMPOSITE Billing Elements of Projects
I_FinWBSElementHierarchyNodeT view_entity inner BASIC Fin WBS Element Hierarchy Node - Text
I_InternalOrderWBSElementVH view_entity from COMPOSITE WBS Element
I_JointVentureProjectData view from BASIC Joint Venture Project Data
I_JVAActualBudgetLineItem view left_outer COMPOSITE Actual Cost and JV Budget
I_MM_WBSElementByIntKeyVH view from COMPOSITE Purchasing WBS Element by Internal ID
I_MM_WBSElementValueHelp view from COMPOSITE Purchasing WBS Element Value Help
I_PPM_ProjectPublicSector view inner COMPOSITE Extension for Public Sector Fields
I_PPM_ProjectTask view left_outer COMPOSITE Milestone Information
I_PPM_ProjectTaskJVA view inner COMPOSITE Extension fields for Joint Venture Accounting on Task level
I_PPM_ProjectTaskPublicSector view inner COMPOSITE Extension fields for PSM on Task level
I_ProjectBillingElementTP view_entity inner TRANSACTIONAL Details of Billing Element
I_ProjectHierarchyRootData view_entity union_all COMPOSITE Project Hierarchy Root Data
I_ProjectToWBSElementCount view from COMPOSITE Number of WBS Elements per Project
I_REControllingObject view union_all COMPOSITE Real Estate Accounting Object
I_WBSElementBasicDataStdVH view from BASIC Basic data for WBS Element
I_WBSElmntInGteeMBillgPlnVH view from COMPOSITE WBS Element Used in Grants Billing Plan
MMIM_WBSELEMENTVALUEHELP view from Value Help for WBS Element
P_ActvPROJECTSWITHPROJCAT6 view inner COMPOSITE
P_BillingDocumentsForProjects view inner COMPOSITE
P_CATSDATAWITHCATEGORY view left_outer COMPOSITE
P_CnsldtnWBSElement view from COMPOSITE
P_CnsldtnWBSElementT view from COMPOSITE
P_CtrlgSettlementObject view union COMPOSITE
P_CtrlgSettlmtDocProjMaxDate view inner CONSUMPTION
P_CtrlgSettlmtProjLastDocNumbr view inner CONSUMPTION
P_EngmntProjReviewData view left_outer COMPOSITE
P_EngmtProjActlPlnSlsOrd view inner COMPOSITE
P_EnterpriseProjectActCosts view inner COMPOSITE
P_EnterpriseProjectCmtmtCosts view inner COMPOSITE
P_EnterpriseProjectPlnCosts view inner COMPOSITE
P_EvtBsdRevnRecgnAcastyWbs view inner CONSUMPTION Join Acasty and WBSElement
P_EvtBsdRevnRecgnProjWIPItm view inner COMPOSITE
P_EvtBsdRevnRecgnRealTmeIss view inner CONSUMPTION Event based rev. rec. Real-time issue
P_EWM_PINVCOUNTITEM06 view left_outer CONSUMPTION
P_MMIM_WBSElementValueHelp view from COMPOSITE
P_MngProjDmndWorkActual view inner COMPOSITE
P_OrglChgWBSElmntUploadCheck view_entity inner COMPOSITE
P_PPM_PrjActCostLineitems view inner COMPOSITE
P_PPM_PrjActCstLineItemsSemTag view inner COMPOSITE
P_PPM_PrjPlnCostLineitems view inner COMPOSITE
P_PPM_PrjPlnCstLineItemsSemTag view inner COMPOSITE
P_PPM_Project view left_outer COMPOSITE
P_PPM_Prstcm_ProjData view left_outer CONSUMPTION
P_ProjectBudgetItems view left_outer COMPOSITE
P_ProjectFinBdgtSummary view inner COMPOSITE
P_ProjectObject view inner COMPOSITE
P_ProjRevnRecgnRealTmeIss view inner CONSUMPTION Event based rev. rec. Real-time issue
P_ProjSettlmtRuleProjBasicData view_entity from COMPOSITE Settlement Rule for Project
P_ProjSettlmtRuleProjBasicData view_entity union COMPOSITE Settlement Rule for Project
P_ProjSettlmtRuleWBSElement view_entity from COMPOSITE Settlement Rule for WBS Element
P_PROJWITHPROJCAT6 view inner COMPOSITE
P_PURORDWBSVALHELP view inner COMPOSITE
P_PurReqnWorkPackage view from CONSUMPTION Purchase Requision work package
P_RAIntegEBRRWBSElement view inner COMPOSITE RAR Integration EBRR WBS
P_RecrrgSuplrInvcWBSElementVH view from BASIC
P_RRBSalesPricingDynamicItem view inner CONSUMPTION
P_SalesDocumentsForProjects view inner COMPOSITE
P_SettlementSender view from CONSUMPTION
P_TimeShtHrsAnlysForProjects view inner COMPOSITE
P_TimeShtPartialDmndKey view inner COMPOSITE
P_WhereUsdPrftCtrWBSElmnt view from CONSUMPTION WBSElement for Where Used List Profit Centers
P_WorkPackageFunctions view from BASIC
P_WPMO_PROJCOSTLINEITEMS view inner COMPOSITE
R_EvtBsdPostingRuleRcvrName view union_all COMPOSITE EB Posting Rule Receiver Name
R_EvtBsdPostingRuleReceiverVH view union_all COMPOSITE EB Posting Rule Receiver
R_EvtBsdPostingRuleWBSElmntVH view from COMPOSITE WBS Element
SHSM_WBS_WORK_PACK_V view from cds view for search help H_WBS_WORK_PACKAGE

Fields (47)

KeyField CDS FieldsUsed in Views
KEY ProjectInternalID ProjectInternalID,ps_prj_pnr,psphi 7
KEY ProjectType EnterpriseProjectType,ProjectType 17
KEY ResponsibleCostCenter ResponsibleCostCenter 20
KEY WBSElement HierarchyNode,posid,WBSElement,WorkPackage 11
KEY WBSElementExternalID BillingWBSElementExternalID,PS_PSP_PNR,WBSElement,WBSElementExternalID 19
KEY WBSElementInternalID WBSElementInternalID 17
KEY WBSElementObject ControllingObject,ObjectNumber,objnr,ProjectObjectNode 9
_ControllingArea _ControllingArea 1
_ProfitCenter _ProfitCenter 1
_Project _Project 4
CompanyCode bukrs,CompanyCode 17
ControllingArea ControllingArea,kokrs 22
CostCenter ActualPostedCostCenter,CostCenter 4
CostingSheet CostingSheet 3
CreatedByUser CreatedByUser,SenderCreatedByUser 2
CreationDate CreationDate,SenderCreationDate 2
EntProjectSettlementElement EntProjectSettlementElement 2
EntProjIsSettlmtRuleInherited EntProjIsSettlmtRuleInherited 2
FactoryCalendar FactoryCalendar 3
FunctionalArea FunctionalArea 12
FunctionalAreaIsFixAssigned FunctionalAreaIsFixAssigned 2
FunctionalLocation FunctionalLocation 3
Fund Fund 3
FundIsFixAssigned FundIsFixAssigned 2
GrantID GrantID 2
GrantIsFixAssigned GrantIsFixAssigned 2
InvestmentProfile InvestmentProfile 3
JntIntrstBillgClass JntIntrstBillgClass 1
JntIntrstBillgSubClass JntIntrstBillgSubClass 1
JntVntrProjectType JntVntrProjectType 2
JointVenture JointVenture 2
JointVentureCostRecoveryCode JointVentureCostRecoveryCode 1
JointVentureEquityType JointVentureEquityType 1
LastChangeDate LastChangeDate,SenderLastChangedDate 2
LastChangedByUser LastChangedByUser,SenderLastChangedByUser 2
Location Location 2
Plant Plant 10
ProfitCenter prctr_current,ProfitCenter,WBSElementProfitCenter 22
RespCostCenterControllingArea RespCostCenterControllingArea 2
ResultAnalysisInternalID ResultAnalysisInternalID 4
SponsoredProgram SponsoredProgram 2
TaxJurisdiction TaxJurisdiction 2
WBSDescription ControllingObjectDescription,HierarchyNodeText,post1,WBSDescription,WorkPackageName 18
WBSElementIsBillingElement billable,IsBillingRelevant,WBSElementIsBillingElement 5
WBSElementShortID WBSElementShortID 1
WBSIsAccountAssignmentElement WBSIsAccountAssignmentElement 1
WBSIsStatisticalWBSElement IsStatistical,StatisticalWBSElement,WBSIsStatisticalWBSElement 3

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 Basic Data
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_WBSELEMENTBASICDATA (
    PROJECTINTERNALID,
    PROJECTTYPE,
    RESPONSIBLECOSTCENTER,
    WBSELEMENT,
    WBSELEMENTEXTERNALID,
    WBSELEMENTINTERNALID,
    WBSELEMENTOBJECT,
    _CONTROLLINGAREA,
    _PROFITCENTER,
    _PROJECT,
    COMPANYCODE,
    CONTROLLINGAREA,
    COSTCENTER,
    COSTINGSHEET,
    CREATEDBYUSER,
    CREATIONDATE,
    ENTPROJECTSETTLEMENTELEMENT,
    ENTPROJISSETTLMTRULEINHERITED,
    FACTORYCALENDAR,
    FUNCTIONALAREA,
    FUNCTIONALAREAISFIXASSIGNED,
    FUNCTIONALLOCATION,
    FUND,
    FUNDISFIXASSIGNED,
    GRANTID,
    GRANTISFIXASSIGNED,
    INVESTMENTPROFILE,
    JNTINTRSTBILLGCLASS,
    JNTINTRSTBILLGSUBCLASS,
    JNTVNTRPROJECTTYPE,
    JOINTVENTURE,
    JOINTVENTURECOSTRECOVERYCODE,
    JOINTVENTUREEQUITYTYPE,
    LASTCHANGEDATE,
    LASTCHANGEDBYUSER,
    LOCATION,
    PLANT,
    PROFITCENTER,
    RESPCOSTCENTERCONTROLLINGAREA,
    RESULTANALYSISINTERNALID,
    SPONSOREDPROGRAM,
    TAXJURISDICTION,
    WBSDESCRIPTION,
    WBSELEMENTISBILLINGELEMENT,
    WBSELEMENTSHORTID,
    WBSISACCOUNTASSIGNMENTELEMENT,
    WBSISSTATISTICALWBSELEMENT,
    PRIMARY KEY (PROJECTINTERNALID, PROJECTTYPE, RESPONSIBLECOSTCENTER, WBSELEMENT, WBSELEMENTEXTERNALID, WBSELEMENTINTERNALID, WBSELEMENTOBJECT)
);