I_SITE

CDS View
10 Fields 37 CDS Views

Retail Site

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

CDS Views using this table (37)

ViewTypeJoinVDMDescription
C_AssignedStore_F4674 view inner CONSUMPTION Assigned Store
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 Move Products with RFID: Store
C_MSPWStore view from CONSUMPTION MPW: Store
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 Anchor view -SITE
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_SiteBPMaintainedVH view from COMPOSITE Site with BP assigned
I_SiteBPMaintenanceStatus view from BASIC Missing linkage between site and BP
I_SiteBPNotMaintainedVH view from COMPOSITE Site with BP not assigned
I_SiteStdVH view from COMPOSITE Value Help for Site
I_StoreValueHelp view_entity from COMPOSITE Store
P_AssgblReceivingDCFromDC view cross CONSUMPTION Assgbl Receiving DC from DC Value Help
P_CoCodeCrcyByStore_F4674 view inner CONSUMPTION Stores enriched by their company code currency
P_MSPWSellableProduct view inner BASIC MPW: Products available for sale
P_MSPWStorePosStorageLocation view from BASIC MPW: POS Storage Location for Store
P_RetailStoreAssignableUser view inner BASIC Assignable Users per Store in Retail Store Apps
P_RtlPromnItmStoreSlsUoM_F4674 view inner COMPOSITE Retail Promotion Items with Qty in Sales Unit
P_SiteReferenceSite view from BASIC Site Reference Site Assignment (helper)
P_StorePickingReqAuthzdUser view inner COMPOSITE Authrized users for picking app
P_StorePOSMovementTypes_F4674 view inner COMPOSITE POS relevant movement types by store
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