_JOINTVENTUREPROJECTDATA

_JOINTVENTUREPROJECTDATA is an SAP database table in S/4HANA. It contains 14 fields.

Fields (14)

KeyField CDS FieldsUsed in Views
KEY WBSElement WBSElement 2
FunctionalLocation FunctionalLocation 2
JntVntrProjectType JntVntrProjectType 2
JointVentureCostRecoveryCode JointVentureCostRecoveryCode 2
NetworkAssignmentType NetworkAssignmentType 2
ProjectType ProjectType 2
RequestingCostCenter RequestingCostCenter 2
ResponsibleCostCenter ResponsibleCostCenter 2
WBSDescription WBSDescription 2
WBSElementHierarchyLevel WBSElementHierarchyLevel 2
WBSElementIsBillingElement WBSElementIsBillingElement 2
WBSElementIsPlanningElement WBSElementIsPlanningElement 2
WBSElementShortID WBSElementShortID 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE _JOINTVENTUREPROJECTDATA (
    WBSELEMENT,
    FUNCTIONALLOCATION,
    JNTVNTRPROJECTTYPE,
    JOINTVENTURECOSTRECOVERYCODE,
    NETWORKASSIGNMENTTYPE,
    PROJECTTYPE,
    REQUESTINGCOSTCENTER,
    RESPONSIBLECOSTCENTER,
    WBSDESCRIPTION,
    WBSELEMENTHIERARCHYLEVEL,
    WBSELEMENTISBILLINGELEMENT,
    WBSELEMENTISPLANNINGELEMENT,
    WBSELEMENTSHORTID,
    WBSISACCOUNTASSIGNMENTELEMENT,
    PRIMARY KEY (WBSELEMENT)
);