_LOCATION

50 Fields

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

Fields (50)

KeyField CDS FieldsUsed in Views
KEY BusinessLocationIdentifier BusinessLocationIdentifier 1
KEY Location AdvancedPlanningFilterLocation,Location,location_id 12
KEY locationID locationId 1
KEY LocationUUID AdvncdPlngLocationID,LocationUUID 2
_BusinessArea _BusinessArea 1
_CompanyCode _CompanyCode 1
_EHSLocationAuthGroup _EHSLocationAuthGroup 1
_EHSLocationStatus _EHSLocationStatus 1
_EHSLocationType _EHSLocationType 1
_FormOfAddress _FormOfAddress 1
_Plant _Plant 1
AddressID AddressID 1
AuthorizationGroup AuthorizationGroup 4
BusinessArea BusinessArea 1
CityName CityName 5
CompanyCode CompanyCode 1
CostCenter CostCenter 1
Country Country 6
DistrictNumber cityp_code 1
effectivefrom locationEffectivefrom 2
effectiveto locationEffectiveTo 2
EHSLocationAuthorizationGroup EHSLocationAuthorizationGroup 1
EHSLocationID EHSLocationID 1
EHSLocationIsAssigned EHSLocationIsAssigned 1
EHSLocationPhone EHSLocationPhone 1
EHSLocationRevisionUUID EHSLocationRevisionUUID 1
EHSLocationStatus EHSLocationStatus 1
EHSLocationType EHSLocationType 1
EWMResource EWMResource 1
EWMStorageBin EWMStorageBin 2
EWMStorageType EWMStorageType 2
FormOfAddress title 1
HouseNumber HouseNumber 3
InvgCsMLocationID InvgCsMLocationID 1
InvgCsMLocationName InvgCsMLocationName 1
IsBusinessPurposeCompleted IsBusinessPurposeCompleted 4
locationName locationDescr,locationName 8
locationType locationType 6
OrganizationName1 name1 1
OrganizationName2 name2 1
OrganizationName3 name3 1
OrganizationName4 name4 1
Plant Plant 1
PostalCode PostalCode 4
Region Region 4
searchTerm1 searchTerm1 1
searchTerm2 searchTerm2 1
StreetName StreetName 5
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 (
    BUSINESSLOCATIONIDENTIFIER,
    LOCATION,
    LOCATIONID,
    LOCATIONUUID,
    _BUSINESSAREA,
    _COMPANYCODE,
    _EHSLOCATIONAUTHGROUP,
    _EHSLOCATIONSTATUS,
    _EHSLOCATIONTYPE,
    _FORMOFADDRESS,
    _PLANT,
    ADDRESSID,
    AUTHORIZATIONGROUP,
    BUSINESSAREA,
    CITYNAME,
    COMPANYCODE,
    COSTCENTER,
    COUNTRY,
    DISTRICTNUMBER,
    EFFECTIVEFROM,
    EFFECTIVETO,
    EHSLOCATIONAUTHORIZATIONGROUP,
    EHSLOCATIONID,
    EHSLOCATIONISASSIGNED,
    EHSLOCATIONPHONE,
    EHSLOCATIONREVISIONUUID,
    EHSLOCATIONSTATUS,
    EHSLOCATIONTYPE,
    EWMRESOURCE,
    EWMSTORAGEBIN,
    EWMSTORAGETYPE,
    FORMOFADDRESS,
    HOUSENUMBER,
    INVGCSMLOCATIONID,
    INVGCSMLOCATIONNAME,
    ISBUSINESSPURPOSECOMPLETED,
    LOCATIONNAME,
    LOCATIONTYPE,
    ORGANIZATIONNAME1,
    ORGANIZATIONNAME2,
    ORGANIZATIONNAME3,
    ORGANIZATIONNAME4,
    PLANT,
    POSTALCODE,
    REGION,
    SEARCHTERM1,
    SEARCHTERM2,
    STREETNAME,
    TRANSPUNITINTERNALNUMBER,
    VILLAGE,
    PRIMARY KEY (BUSINESSLOCATIONIDENTIFIER, LOCATION, LOCATIONID, LOCATIONUUID)
);

Learn More