R_WORKASSIGNMENTBASIC

CDS View
44 Fields 3 CDS Views

Work assignment TP

R_WORKASSIGNMENTBASIC is a CDS View in S/4HANA. Work assignment TP. It contains 44 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
R_WorkAgreementPaymentMethod view inner COMPOSITE Work Assignment Payment Method
R_WorkAssignmentTP view_entity from TRANSACTIONAL Work assignment TP
R_WrkAssgmtPaymentMethodTP view_entity inner TRANSACTIONAL Work assignment Payment Method TP

Fields (44)

KeyField CDS FieldsUsed in Views
KEY WorkAssignment WorkAssignment 2
KEY WorkAssignmentUUID WorkAssignmentUUID 1
_BPUsrRoleText _BPUsrRoleText 1
_CompanyCodeText _CompanyCodeText 1
_CountryText _CountryText 1
_CurrencyText _CurrencyText 1
_EntrySourceText _EntrySourceText 1
_WorkAssignmentBP _WorkAssignmentBP 1
_WorkforcePersonBP _WorkforcePersonBP 1
AuthorizationGroup AuthorizationGroup 1
BasicRoleCategory BasicRoleCategory 1
BusinessPartnerName BusinessPartnerName 1
BusinessPartnerRelshpSupplier BusinessPartnerRelshpSupplier 1
BusinessPartnerRole BusinessPartnerRole 1
BusPartRelshpSupplierIsVisible BusPartRelshpSupplierIsVisible 1
CompanyCode CompanyCode 1
CompanyCodeCountry CompanyCodeCountry 1
CreationDateTime CreationDateTime 1
Currency Currency 1
DataController1 DataController1 1
DataController10 DataController10 1
DataController2 DataController2 1
DataController3 DataController3 1
DataController4 DataController4 1
DataController5 DataController5 1
DataController6 DataController6 1
DataController7 DataController7 1
DataController8 DataController8 1
DataController9 DataController9 1
DataControllerSet DataControllerSet 1
EmploymentSituation EmploymentSituation 1
EndDate EndDate 1
IsBlocked IsBlocked 1
IsBusinessPurposeCompleted IsBusinessPurposeCompleted 1
Person Person 1
PersonUUID PersonUUID 3
RoleCategory RoleCategory 1
StartDate StartDate 1
WorkAssignmentBusinessPartner WorkAssignmentBusinessPartner 1
WorkAssignmentCountryISOCode WorkAssignmentCountryISOCode 1
WorkAssignmentDataSource WorkAssignmentDataSource 1
WorkAssignmentExternalID WorkAssignmentExternalID 1
WorkforcePersonID WorkforcePersonID 1
WorkforcePersonUserID WorkforcePersonUserID 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.

-- Work assignment TP
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE R_WORKASSIGNMENTBASIC (
    WORKASSIGNMENT,
    WORKASSIGNMENTUUID,
    _BPUSRROLETEXT,
    _COMPANYCODETEXT,
    _COUNTRYTEXT,
    _CURRENCYTEXT,
    _ENTRYSOURCETEXT,
    _WORKASSIGNMENTBP,
    _WORKFORCEPERSONBP,
    AUTHORIZATIONGROUP,
    BASICROLECATEGORY,
    BUSINESSPARTNERNAME,
    BUSINESSPARTNERRELSHPSUPPLIER,
    BUSINESSPARTNERROLE,
    BUSPARTRELSHPSUPPLIERISVISIBLE,
    COMPANYCODE,
    COMPANYCODECOUNTRY,
    CREATIONDATETIME,
    CURRENCY,
    DATACONTROLLER1,
    DATACONTROLLER10,
    DATACONTROLLER2,
    DATACONTROLLER3,
    DATACONTROLLER4,
    DATACONTROLLER5,
    DATACONTROLLER6,
    DATACONTROLLER7,
    DATACONTROLLER8,
    DATACONTROLLER9,
    DATACONTROLLERSET,
    EMPLOYMENTSITUATION,
    ENDDATE,
    ISBLOCKED,
    ISBUSINESSPURPOSECOMPLETED,
    PERSON,
    PERSONUUID,
    ROLECATEGORY,
    STARTDATE,
    WORKASSIGNMENTBUSINESSPARTNER,
    WORKASSIGNMENTCOUNTRYISOCODE,
    WORKASSIGNMENTDATASOURCE,
    WORKASSIGNMENTEXTERNALID,
    WORKFORCEPERSONID,
    WORKFORCEPERSONUSERID,
    PRIMARY KEY (WORKASSIGNMENT, WORKASSIGNMENTUUID)
);

Learn More