_UTILSTECHOBJLOCATIONADDR

30 Fields

_UTILSTECHOBJLOCATIONADDR is an SAP database table in S/4HANA. It contains 30 fields.

Fields (30)

KeyField CDS FieldsUsed in Views
_Address _Address 6
_Address2 _Address2 5
_ControllingArea _ControllingArea 2
_CostCenter _CostCenter 2
_Country _Country 5
_CountyCode _CountyCode 5
_FunctionalLocationText _FunctionalLocationText 3
_Location _Location 2
_LocationAccountAssignment _LocationAccountAssignment 3
_MaintenancePlannerGroup _MaintenancePlannerGroup 2
_MaintenancePlanningPlant _MaintenancePlanningPlant 4
_PlanningPlant _PlanningPlant 4
_Plant _MaintenancePlant,_Plant 6
_PostalCity _PostalCity 5
_Region _Region 5
AddressID AddressID 7
AssetLocation AssetLocation 6
AuthorizationGroup AuthorizationGroup 1
CityNumber CityNumber 5
ControllingArea ControllingArea 6
CostCenter CostCenter 6
Country Country 5
CountyCode CountyCode 5
FunctionalLocation FunctionalLocation 5
MaintenanceObjectLocation MaintenanceObjectLocation 5
MaintenancePlannerGroup MaintenancePlannerGroup 6
MaintenancePlanningPlant MaintenancePlanningPlant 6
MaintenancePlant MaintenancePlant 6
MaintObjectLocAcctAssgmtNmbr MaintObjectLocAcctAssgmtNmbr 6
Region Region 5

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 _UTILSTECHOBJLOCATIONADDR (
    _ADDRESS,
    _ADDRESS2,
    _CONTROLLINGAREA,
    _COSTCENTER,
    _COUNTRY,
    _COUNTYCODE,
    _FUNCTIONALLOCATIONTEXT,
    _LOCATION,
    _LOCATIONACCOUNTASSIGNMENT,
    _MAINTENANCEPLANNERGROUP,
    _MAINTENANCEPLANNINGPLANT,
    _PLANNINGPLANT,
    _PLANT,
    _POSTALCITY,
    _REGION,
    ADDRESSID,
    ASSETLOCATION,
    AUTHORIZATIONGROUP,
    CITYNUMBER,
    CONTROLLINGAREA,
    COSTCENTER,
    COUNTRY,
    COUNTYCODE,
    FUNCTIONALLOCATION,
    MAINTENANCEOBJECTLOCATION,
    MAINTENANCEPLANNERGROUP,
    MAINTENANCEPLANNINGPLANT,
    MAINTENANCEPLANT,
    MAINTOBJECTLOCACCTASSGMTNMBR,
    REGION
);

Learn More