I_WBSELEMENTBASICDATA
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| 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)
| Key | Field | CDS Fields | Used 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)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA