_WBSELEMENT

35 Fields

_WBSELEMENT is an SAP database table in S/4HANA. It contains 35 fields.

Fields (35)

KeyField CDS FieldsUsed in Views
KEY WBSElement HierarchyNode,OrglChgRptNodeDescription,ProjectObjectExternalID,WBSElement,WBSElementExternalID 38
KEY WBSElementExternalID AssetWBSElementExternalID,ProjectObjectExternalID,ps_posid,WBSElement,WBSElementExternalID 82
KEY WBSElementInternalID WBSElementInternalID 3
_Project _Project 3
_ProjectApplicant _ProjectApplicant 1
_ResponsiblePerson _ResponsiblePerson 1
ApplicantCode ApplicantCode 1
BasicEndDate BasicEndDate 6
BasicStartDate BasicStartDate 6
CompanyCode CompanyCode 3
ControllingArea ControllingArea 5
cpd_updat UpdateTimestamp 1
Currency ControllingObjectCurrency 1
CustomerProjectName CustomerProjectName 2
CustProjWorkPackageName CustProjWorkPackageName 2
FreeDefinedIndicator2 FreeDefinedIndicator2 1
logsystem LogicalSystem 1
ObjBasedAuthorizationIsActive ObjBasedAuthorizationIsActive 1
pgsbr BusinessArea 1
posnr_prps LeadingSalesOrder 1
PROFITCENTER PROFITCENTER,ProjectObjectProfitCenter,WBSElementProfitCenter 10
ProjectInternalID ProjectInternalID 8
ProjectType ProjectType 6
RespCostCenterControllingArea RespCostCenterControllingArea 1
ResponsibleCostCenter CostCenter,ResponsibleCostCenter 7
ResponsiblePerson ResponsiblePerson 1
ResponsiblePersonName ResponsiblePersonName 1
vbeln_prps LeadingSalesOrderItem 1
WBSDescription ProjectObjectDescription,WBSDescription,WBSElementDescription,WorkPackageName 94
WBSElementHierarchyLevel WBSElementHierarchyLevel 5
WBSElementIsBillingElement WBSElementIsBillingElement 1
WBSElementObject ControllingObject,ProjectObjectParentNode,WBSElementObject 14
WBSElementShortID WBSElementShortID 4
WBSElementWithCodingMask WBSElement 1
WBSIsStatisticalWBSElement IsStatistical 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE _WBSELEMENT (
    WBSELEMENT,
    WBSELEMENTEXTERNALID,
    WBSELEMENTINTERNALID,
    _PROJECT,
    _PROJECTAPPLICANT,
    _RESPONSIBLEPERSON,
    APPLICANTCODE,
    BASICENDDATE,
    BASICSTARTDATE,
    COMPANYCODE,
    CONTROLLINGAREA,
    CPD_UPDAT,
    CURRENCY,
    CUSTOMERPROJECTNAME,
    CUSTPROJWORKPACKAGENAME,
    FREEDEFINEDINDICATOR2,
    LOGSYSTEM,
    OBJBASEDAUTHORIZATIONISACTIVE,
    PGSBR,
    POSNR_PRPS,
    PROFITCENTER,
    PROJECTINTERNALID,
    PROJECTTYPE,
    RESPCOSTCENTERCONTROLLINGAREA,
    RESPONSIBLECOSTCENTER,
    RESPONSIBLEPERSON,
    RESPONSIBLEPERSONNAME,
    VBELN_PRPS,
    WBSDESCRIPTION,
    WBSELEMENTHIERARCHYLEVEL,
    WBSELEMENTISBILLINGELEMENT,
    WBSELEMENTOBJECT,
    WBSELEMENTSHORTID,
    WBSELEMENTWITHCODINGMASK,
    WBSISSTATISTICALWBSELEMENT,
    PRIMARY KEY (WBSELEMENT, WBSELEMENTEXTERNALID, WBSELEMENTINTERNALID)
);

Learn More