I_SITE

CDS View
10 Fields 35 CDS Views

Retail Site

I_SITE is a CDS View in S/4HANA. Retail Site. It contains 10 fields. 35 CDS views read from this table.

CDS Views using this table (35)

ViewTypeJoinVDMDescription
C_AssignedStore_F4674 view inner CONSUMPTION
C_AssortmentModuleUserVH view_entity from CONSUMPTION Assortment User
C_AURSStore view_entity from CONSUMPTION Store
C_CSPRCountDeleteAuthorization view from CONSUMPTION Check if the user has authorization to delete an RFID Count
C_CSPRCountForceSubmitAuthzn view from CONSUMPTION Check if user has auth. to force the submit of an RFID Count
C_CSPRCountSubmitAuthorization view from CONSUMPTION Check if the user has authorization to submit an RFID Count
C_CSPRStore view from CONSUMPTION Count Products with RFID: Store
C_MSPRStore view_entity from CONSUMPTION
C_MSPWStore view from CONSUMPTION
C_RetailSiteDP view_entity from CONSUMPTION Retail Site
C_SiteDEX view from CONSUMPTION Site Address Data
C_SiteObjPg view from CONSUMPTION Site Object Page
C_SiteSupplyingSiteVH view from CONSUMPTION Value Help for supplying sites
ESH_N_SITE view from
I_DistributionCenterValueHelp view from COMPOSITE Value Help for Distribution Centers
I_ExternalStoreListingTP view_entity inner TRANSACTIONAL Product Assignment to Store by External Source
I_ListingDetail view_entity inner COMPOSITE Product Listing Detail
I_PickReqSchemaForStore view from COMPOSITE Retail Store Customizng Schema for Store
I_ProductDistrCtrListingTP view_entity inner TRANSACTIONAL Product Assignment to Distribution Center
I_ProductsForSaleInRtlStore view inner COMPOSITE Retail Store Products available for sale
I_RetailStoreApplicationStore view from COMPOSITE Retail Store Application and Store
I_RetailStoreSchemaForStore view from COMPOSITE Retail Store Customizng Schema for Store
I_SiteBPMaintenanceStatus view from BASIC Missing linkage between site and BP
I_SiteStdVH view from COMPOSITE Value Help for Site
I_StoreValueHelp view_entity from COMPOSITE Store
P_AssgblReceivingDCFromDC view cross CONSUMPTION
P_CoCodeCrcyByStore_F4674 view inner CONSUMPTION
P_MSPWSellableProduct view inner BASIC
P_MSPWStorePosStorageLocation view from BASIC
P_RetailStoreAssignableUser view inner BASIC
P_RtlPromnItmStoreSlsUoM_F4674 view inner COMPOSITE
P_SiteReferenceSite view from BASIC
P_StorePickingReqAuthzdUser view inner COMPOSITE
P_StorePOSMovementTypes_F4674 view inner COMPOSITE
R_SiteMasterTP view_entity from TRANSACTIONAL Site Master

Fields (10)

KeyField CDS FieldsUsed in Views
KEY Site DistributionCenter,Site,Store 8
_Customer _Customer 1
_DistributionChannel _DistributionChannel 1
_SalesOrganization _SalesOrganization 1
_Supplier _Supplier 1
DistributionChannel DistributionChannel 4
SalesOrganization SalesOrganization 4
SiteCategory SiteCategory 1
SiteCustomer SiteCustomer 3
SiteName SiteName 3

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.

-- Retail Site
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_SITE (
    SITE,
    _CUSTOMER,
    _DISTRIBUTIONCHANNEL,
    _SALESORGANIZATION,
    _SUPPLIER,
    DISTRIBUTIONCHANNEL,
    SALESORGANIZATION,
    SITECATEGORY,
    SITECUSTOMER,
    SITENAME,
    PRIMARY KEY (SITE)
);

Learn More