R_WORKASSGMTALTCOSTASSGMT

CDS View
14 Fields 2 CDS Views

Alternate Cost Object for Wrk Assignment

R_WORKASSGMTALTCOSTASSGMT is a CDS View in S/4HANA. Alternate Cost Object for Wrk Assignment. It contains 14 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
R_WorkAssgmtAltCostAssgmtUnion view_entity from COMPOSITE Alt Cost Assgmnts at Wrk Assignmnt
R_WrkAssgAltCostAssgUnion_2 view_entity from COMPOSITE Alt Cost Assgmnts at Wrk Assignmnt

Fields (14)

KeyField CDS FieldsUsed in Views
KEY SequenceNumber SequenceNumber 2
KEY WorkforceAssgmtStartDate WorkAssignmentStartDate 2
AlternateCostPercent AlternateCostPercent 2
CompanyCode CompanyCode 2
ControllingArea ControllingArea 2
CostCenter CostCenter 2
FinancialManagementArea FinancialManagementArea 2
FunctionalArea FunctionalArea 2
Fund Fund 2
GrantID GrantID 2
IsDefaultValue IsDefaultValue 2
WBSElementExternalID WBSElementExternalID 2
WorkforceAssgmtEndDate WorkAssignmentEndDate 2
WorkforceAssignment WorkAssignment 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.

-- Alternate Cost Object for Wrk Assignment
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE R_WORKASSGMTALTCOSTASSGMT (
    SEQUENCENUMBER,
    WORKFORCEASSGMTSTARTDATE,
    ALTERNATECOSTPERCENT,
    COMPANYCODE,
    CONTROLLINGAREA,
    COSTCENTER,
    FINANCIALMANAGEMENTAREA,
    FUNCTIONALAREA,
    FUND,
    GRANTID,
    ISDEFAULTVALUE,
    WBSELEMENTEXTERNALID,
    WORKFORCEASSGMTENDDATE,
    WORKFORCEASSIGNMENT,
    PRIMARY KEY (SEQUENCENUMBER, WORKFORCEASSGMTSTARTDATE)
);

Learn More