I_LOCATIONBASIC

CDS View
17 Fields 16 CDS Views

Location

I_LOCATIONBASIC is a CDS View in S/4HANA. Location. It contains 17 fields. 16 CDS views read from this table.

CDS Views using this table (16)

ViewTypeJoinVDMDescription
/SCMTMS/VE_LOCAD view_entity from BOPF: Location Selected Address Details
/SCMTMS/VE_LOCAI view_entity from BOPF: Location Alternative ID
/SCMTMS/VE_LocQuByPhysAdd view_entity from BOPF: Location Query By Physical Address
/SCMTMS/VE_LOCRT view_entity from BOPF: Location Root
/SCMTMS/VE_LocTimeInfShipFr view_entity from BOPF: Helper for Locatn. Outb. Time Inf.
/SCMTMS/VE_LocTimeInfShipTo view_entity from BOPF: Helper for Locatn. Inb. Time Inf.
C_LoadingPointVH view from CONSUMPTION Loading Point
I_LocationAddressVH view from COMPOSITE Location Value help with Address Attributes
I_LocationAnalytics view from COMPOSITE Location
I_LocationBasicStdVH view from COMPOSITE Location
I_LocationValueHelp view from COMPOSITE Location
I_TransportationLocation view from COMPOSITE Transportation Location
R_LocationAddressTP view_entity from TRANSACTIONAL Location Address
R_LocationTP view_entity from TRANSACTIONAL Transactional Processing View for Location
R_TrOrdStopLocAddrAddlRprstnTP view_entity inner TRANSACTIONAL Transp Ord Stop Loc Addr Addl Rpn - TP
R_TrOrdStopLocAddrDfltRprstnTP view_entity inner TRANSACTIONAL Transp Ord Stop Loc Addr Dflt Rpn - TP

Fields (17)

KeyField CDS FieldsUsed in Views
KEY Location LoadingPointForDelivery,loc_id002,loc_id002_i,location_id 5
KEY LocationUUID locationGUID22,LocationUUID 2
_BusinessPartner _BusinessPartner 1
_CollaborationPartner _CollaborationPartner 1
_Text _Text 1
AddressID AddressID 1
AuthorizationGroup AuthorizationGroup 6
BusinessPartnerUUID BusinessPartnerUUID 1
CollaborationPartner CollaborationPartner 1
InboundCalendarResourceUUID uuid015_c22 1
IsBusinessPurposeCompleted IsBusinessPurposeCompleted 6
LocationAdditionalUUID location_uuid,locationGUID16 2
LocationIATACode iatacode 1
LocationType location_type_code,LocationType 3
LocationUNCode unlocode 1
OutboundCalendarResourceUUID uuid015_c22 1
ResourceValidity resctrl_optcd 2

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.

-- Location
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_LOCATIONBASIC (
    LOCATION,
    LOCATIONUUID,
    _BUSINESSPARTNER,
    _COLLABORATIONPARTNER,
    _TEXT,
    ADDRESSID,
    AUTHORIZATIONGROUP,
    BUSINESSPARTNERUUID,
    COLLABORATIONPARTNER,
    INBOUNDCALENDARRESOURCEUUID,
    ISBUSINESSPURPOSECOMPLETED,
    LOCATIONADDITIONALUUID,
    LOCATIONIATACODE,
    LOCATIONTYPE,
    LOCATIONUNCODE,
    OUTBOUNDCALENDARRESOURCEUUID,
    RESOURCEVALIDITY,
    PRIMARY KEY (LOCATION, LOCATIONUUID)
);

Learn More