/SAPAPO/LOCMAP

Transparent Table Application Table
21 Fields 12 CDS Views

Mapping Table for Locations

/SAPAPO/LOCMAP is an SAP database table in S/4HANA. Mapping Table for Locations. It contains 21 fields. 12 CDS views read from this table.

CDS Views using this table (12)

ViewTypeJoinVDMDescription
/SAPAPO/CDPS_CURTORUL_SEL view inner Selection of Resource Usage
/SAPAPO/SDM_PLSTA_DD view inner CDS-View: Migration Status PPSKZ to /SAPAPO/MATPLSTA for SDM
/SAPAPO/SYPP_Location_material view inner Synchronized Production Planning Location Material
/sapapo/sypp_ts_sosmap view inner Mapping beween external and PP/DS source of supply
I_JITOutbLocationId view from BASIC JIT S2P - S2L Location ID
I_LocationMap view from BASIC Location Mapping
I_SrvcPartsDealerLocationMap view_entity inner BASIC Dealer Location Mapping
P_AdvncdPlngLocmapMarc view from BASIC
P_AdvncdPlngLocmapMdma view from BASIC
P_ADVNCDPLNGPRODPLANTMRP view inner BASIC
P_ADVNCDPLNGPRODUCTPLANT view inner BASIC
R_LocationMap view_entity from BASIC Location Mapping

Fields (21)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY ext_locno /SAPAPO/LOC_EXTLOCNO Ext. Location Id
KEY loctype /SAPAPO/C_LOCTYPE Location Type
KEY logqs /SAPAPO/LOC_LOGQS Bus. Syst. Grp
locid /SAPAPO/LOCID Location ID
locno /SAPAPO/LOCNO Location
logsys /SAPAPO/LOC_LOGSYS Log. Source Syst.
vmi_locid /SAPAPO/LOC_VMILOCID Location (SP)
vmi_ext_locno /SAPAPO/LOC_VMIEXTLOCNO Location Ext.
vkorg /SAPAPO/LOC_VKORG Sales Org.
vtweg /SAPAPO/LOC_VTWEG Distrib.Channel
spart /SAPAPO/LOC_SPART Division
ekorg /SAPAPO/LOC_EKORG Purchasing Org.
kunnr /SAPAPO/LOC_KUNNR CustomerNoPlant
pl_locid /SAPAPO/PL_LOCID Plant ID (MRP area)
pl_ext_locno /SAPAPO/PL_EXTLOCNO MRP Plant
pl_loctype /SAPAPO/PL_LOCTYPE Loc. Type
sublocation /SAPAPO/LOC_SUBLOC Storage Loc.
wm_logsys /SAPAPO/LOGSYS_EWM_TARGET_SYS Logical Syst. (EWM)
wm_wh_number /SAPAPO/EWM_WAREHOUSE_NUMBER SAP EWM Whse No.
bukrs /SCMB/BUKRS Company Code

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.

-- Mapping Table for Locations
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE /SAPAPO/LOCMAP (
    MANDT,          -- Client [MANDT]
    EXT_LOCNO,      -- Ext. Location Id [/SAPAPO/LOC_EXTLOCNO]
    LOCTYPE,        -- Location Type [/SAPAPO/C_LOCTYPE]
    LOGQS,          -- Bus. Syst. Grp [/SAPAPO/LOC_LOGQS]
    LOCID,          -- Location ID [/SAPAPO/LOCID]
    LOCNO,          -- Location [/SAPAPO/LOCNO]
    LOGSYS,         -- Log. Source Syst. [/SAPAPO/LOC_LOGSYS]
    VMI_LOCID,      -- Location (SP) [/SAPAPO/LOC_VMILOCID]
    VMI_EXT_LOCNO,  -- Location Ext. [/SAPAPO/LOC_VMIEXTLOCNO]
    VKORG,          -- Sales Org. [/SAPAPO/LOC_VKORG]
    VTWEG,          -- Distrib.Channel [/SAPAPO/LOC_VTWEG]
    SPART,          -- Division [/SAPAPO/LOC_SPART]
    EKORG,          -- Purchasing Org. [/SAPAPO/LOC_EKORG]
    KUNNR,          -- CustomerNoPlant [/SAPAPO/LOC_KUNNR]
    PL_LOCID,       -- Plant ID (MRP area) [/SAPAPO/PL_LOCID]
    PL_EXT_LOCNO,   -- MRP Plant [/SAPAPO/PL_EXTLOCNO]
    PL_LOCTYPE,     -- Loc. Type [/SAPAPO/PL_LOCTYPE]
    SUBLOCATION,    -- Storage Loc. [/SAPAPO/LOC_SUBLOC]
    WM_LOGSYS,      -- Logical Syst. (EWM) [/SAPAPO/LOGSYS_EWM_TARGET_SYS]
    WM_WH_NUMBER,   -- SAP EWM Whse No. [/SAPAPO/EWM_WAREHOUSE_NUMBER]
    BUKRS,          -- Company Code [/SCMB/BUKRS]
    PRIMARY KEY (MANDT, EXT_LOCNO, LOCTYPE, LOGQS)
);

Learn More