_WORKPLACEADDRESS

15 Fields

_WORKPLACEADDRESS is an SAP database table in S/4HANA. It contains 15 fields.

Fields (15)

KeyField CDS FieldsUsed in Views
Building Building,WorkplaceBuilding 3
DefaultEmailAddress DefaultEmailAddress,EmailAddress 21
Department Department,DepartmentName 3
DestinationLocationCountry Country,DestinationLocationCountry 5
FaxAreaCodeSubscriberNumber FaxAreaCodeSubscriberNumber 1
FaxExtensionNumber FaxExtensionNumber 1
FaxNumberCountry FaxNumberCountry 1
FunctionalTitlename FunctionalTitleName,JobName 2
MblNormalizedPhoneNumber MblNormalizedPhoneNumber,MobilePhoneNumber 4
MblPhoneDestinationLocCountry MblPhoneDestinationLocCountry 4
MobilePhoneNumber MobilePhoneNumber 8
NormalizedPhoneNumber NormalizedPhoneNumber,PhoneNumber 8
PhoneNumber PhoneNumber 8
PhoneNumberExtension PhoneNumberExtension 4
RoomNumber RoomNumber 4

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 _WORKPLACEADDRESS (
    BUILDING,
    DEFAULTEMAILADDRESS,
    DEPARTMENT,
    DESTINATIONLOCATIONCOUNTRY,
    FAXAREACODESUBSCRIBERNUMBER,
    FAXEXTENSIONNUMBER,
    FAXNUMBERCOUNTRY,
    FUNCTIONALTITLENAME,
    MBLNORMALIZEDPHONENUMBER,
    MBLPHONEDESTINATIONLOCCOUNTRY,
    MOBILEPHONENUMBER,
    NORMALIZEDPHONENUMBER,
    PHONENUMBER,
    PHONENUMBEREXTENSION,
    ROOMNUMBER
);

Learn More