_WBSELEMENT

32 Fields

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

Fields (32)

KeyField CDS FieldsUsed in Views
KEY WBSElement HierarchyNode,OrglChgRptNodeDescription,ProjectObjectExternalID,WBSElement,WBSElementExternalID 38
KEY WBSElementExternalID posid,ProjectObjectExternalID,ps_posid,WBSElement,WBSElementExternalID 73
KEY WBSElementInternalID WBSElementInternalID 2
KEY WBSElementObject ControllingObject,ProjectObjectParentNode,WBSElementObject 12
_Project _Project 1
_ProjectApplicant _ProjectApplicant 1
_ResponsiblePerson _ResponsiblePerson 1
ApplicantCode ApplicantCode 1
BasicEndDate BasicEndDate 6
BasicStartDate BasicStartDate 6
CompanyCode CompanyCode 3
ControllingArea ControllingArea 4
cpd_updat UpdateTimestamp 1
CustomerProjectName CustomerProjectName 2
CustProjWorkPackageName CustProjWorkPackageName 2
FreeDefinedIndicator2 FreeDefinedIndicator2 1
logsystem LogicalSystem 1
pgsbr BusinessArea 1
posnr_prps LeadingSalesOrder 1
PROFITCENTER PROFITCENTER,ProjectObjectProfitCenter,WBSElementProfitCenter 9
Project Project 1
ProjectInternalID ProjectInternalID 6
ProjectType ProjectType 5
RespCostCenterControllingArea RespCostCenterControllingArea 1
ResponsibleCostCenter CostCenter,ResponsibleCostCenter 6
ResponsiblePerson ResponsiblePerson 1
ResponsiblePersonName ResponsiblePersonName 1
vbeln_prps LeadingSalesOrderItem 1
WBSDescription ProjectObjectDescription,WBSDescription,WBSElementDescription,WorkPackageName 83
WBSElementHierarchyLevel WBSElementHierarchyLevel 4
WBSElementIsBillingElement WBSElementIsBillingElement 1
WBSElementShortID WBSElementShortID 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.

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

Learn More