_LOCATION

44 Fields

_LOCATION is an SAP database table in S/4HANA. It contains 44 fields.

Fields (44)

KeyField CDS FieldsUsed in Views
KEY Location Location,location_id 4
_BusinessArea _BusinessArea 1
_CompanyCode _CompanyCode 1
_EHSLocationAuthGroup _EHSLocationAuthGroup 1
_EHSLocationStatus _EHSLocationStatus 1
_EHSLocationType _EHSLocationType 1
_FormOfAddress _FormOfAddress 1
_MKT_LocationType _MKT_LocationType 2
_Plant _Plant 1
AddressID AddressID 1
AuthorizationGroup AuthorizationGroup 2
BusinessArea BusinessArea 1
CityName CityName 3
CompanyCode CompanyCode 1
CostCenter CostCenter 1
Country Country 4
DistrictNumber cityp_code 1
EHSLocationAuthorizationGroup EHSLocationAuthorizationGroup 1
EHSLocationID EHSLocationID 2
EHSLocationIsAssigned EHSLocationIsAssigned 1
EHSLocationPhone EHSLocationPhone 1
EHSLocationRevisionUUID EHSLocationRevisionUUID 1
EHSLocationStatus EHSLocationStatus 1
EHSLocationType EHSLocationType 1
EHSLocationUUID EHSLocationUUID 2
EWMResource EWMResource 1
EWMStorageBin EWMStorageBin 2
EWMStorageType EWMStorageType 2
FormOfAddress title 1
HouseNumber HouseNumber 1
IsBusinessPurposeCompleted IsBusinessPurposeCompleted 2
LocationName LocationName 2
MarketingLocationName MarketingLocationName 2
MarketingLocationType MarketingLocationType 2
OrganizationName1 name1 1
OrganizationName2 name2 1
OrganizationName3 name3 1
OrganizationName4 name4 1
Plant Plant 1
PostalCode PostalCode 2
Region Region 2
StreetName StreetName 3
TranspUnitInternalNumber TranspUnitInternalNumber 1
Village cityh_code 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE _LOCATION (
    LOCATION,
    _BUSINESSAREA,
    _COMPANYCODE,
    _EHSLOCATIONAUTHGROUP,
    _EHSLOCATIONSTATUS,
    _EHSLOCATIONTYPE,
    _FORMOFADDRESS,
    _MKT_LOCATIONTYPE,
    _PLANT,
    ADDRESSID,
    AUTHORIZATIONGROUP,
    BUSINESSAREA,
    CITYNAME,
    COMPANYCODE,
    COSTCENTER,
    COUNTRY,
    DISTRICTNUMBER,
    EHSLOCATIONAUTHORIZATIONGROUP,
    EHSLOCATIONID,
    EHSLOCATIONISASSIGNED,
    EHSLOCATIONPHONE,
    EHSLOCATIONREVISIONUUID,
    EHSLOCATIONSTATUS,
    EHSLOCATIONTYPE,
    EHSLOCATIONUUID,
    EWMRESOURCE,
    EWMSTORAGEBIN,
    EWMSTORAGETYPE,
    FORMOFADDRESS,
    HOUSENUMBER,
    ISBUSINESSPURPOSECOMPLETED,
    LOCATIONNAME,
    MARKETINGLOCATIONNAME,
    MARKETINGLOCATIONTYPE,
    ORGANIZATIONNAME1,
    ORGANIZATIONNAME2,
    ORGANIZATIONNAME3,
    ORGANIZATIONNAME4,
    PLANT,
    POSTALCODE,
    REGION,
    STREETNAME,
    TRANSPUNITINTERNALNUMBER,
    VILLAGE,
    PRIMARY KEY (LOCATION)
);

Learn More