CDS Views for In-Store Merchandise and Inventory Management - Fiori Apps (LO-RFM-STO-FIO)

CDS View NameDescriptionSQL View Name
C_ASSIGNEDSTORE_F4674Assigned StoreCSASSGDSTORF4674
C_AURSASSIGNABLEUSERAURS: User Assignable to StoreCAURSASSBLUSER
C_AURSASSIGNEDSTOREAURS: Assigned StoreCAURSASSGDSTORE
C_AURSSTOREStoreCAURSSTORE
C_AURSSTOREUSERAURS: Store UserCAURSSTOREUSER
C_CMPTASKCheck My Products: TaskCCMPTASK
C_CSPRASSIGNEDSTORECount Products with RFID: Assigned StoreCCSPRASSGDSTORE
C_CSPRCOUNTCount Products with RFID: CountCCSPRCOUNT
C_CSPRCOUNTDELETEAUTHORIZATIONCheck if the user has authorization to delete an RFID CountCCSPRDELETECNT
C_CSPRCOUNTDIFFERENCECount Products with RFID: Count DiffCCSPRCNTDIFFRNCE
C_CSPRCOUNTFORCESUBMITAUTHZNCheck if user has auth. to force the submit of an RFID CountCCSPRFRCSBMTCNT
C_CSPRCOUNTGTINCount Products with RFID: Count GTINCCSPRCOUNTGTIN
C_CSPRCOUNTPRODUCTINSTANCECount Products with RFID: Count Prd InstCCSPRCNTPRDINSTC
C_CSPRCOUNTSUBMITAUTHORIZATIONCheck if the user has authorization to submit an RFID CountCCSPRSUBMITCNT
C_CSPRPRODUCTCount Products with RFID: ProductCCSPRPRODUCT
C_CSPRPRODUCTBASEUOMGTINCount Products with RFID: Prd Base GTINCCSPRPRDBASEGTIN
C_CSPRPRODUCTIMAGECount Products with RFID: Product ImageCCSPRPRODUCTIMG
C_CSPRSETTINGSCount Products with RFID: SettingsCCSPRSETTINGS
C_CSPRSTORAGELOCATIONCount Products with RFID: Storage LocatnCCSPRSTRGELOCTN
C_CSPRSTORECount Products with RFID: StoreCCSPRSTORE
C_DAILYGROSSSALES_F4674Daily sum of gross sales by user-assigned storeCDLYGRSSLSF4674
C_HANDLINGUNITGDSRCPTSTS_F4674Handling Unit Goods Receipt Status for StoreCHUGRSTSF4674
C_MSPRASSIGNEDSTOREMove Products with RFID: Assigned StoreCMSPRASSGDSTORE
C_MSPRMOVEMENTMSPR: (goods) Movements with RFIDCMSPRMOVEMENT
C_MSPRSETTINGSMove Products with RFID: SettingsCMSPRSETTINGS
C_MSPRSTORAGELOCATIONMove Products w/ RFID: Storage LocationCMSPRSTRGELOCTN
C_MSPRSTOREMove Products with RFID: StoreCMSPRSTORE
C_MSPWASSIGNEDSTOREMPW: Assigned StoreCMSPWASSGDSTORE
C_MSPWSETTINGSMPW: Customizing SettingsCMSPWSETTINGS
C_MSPWSTORAGELOCATIONMPW: Storage LocationCMSPWSTORLOC
C_MSPWSTOREMPW: StoreCMSPWSTORE
C_RETAILPROMOTION_F4674Retail Promotion Overview by StoreCRTLPROMF4674
C_STOREHANDOVERORDERPRSNLZNStore Handover Order PersonalizationCSTRHNDPERSFRMWR
C_STOREMAINTPICKINGSQNCConsumption View on I_StoreMaintPickingSqncCSTMANTPICSEQ
C_STOREORDERPAYMENTSTATUSVHOrder Payment Status Value HelpCSTRORDPAYMSTVH
C_STOREORDERPICKINGSTATUSVHOrder Picking Status Value HelpCSTRORDPICKSTVH
C_STOREORDERREJECTIONREASONVHReason code for order cancellationCSTRORDCANRESVH
C_STOREPERSONALIZATION_F4959Store AdjustMassStock PersonalizationCSTRPRSNLZNFRW
C_STOREPICKINGPRODUCTSETTINGSManage Picking Configuration SettingsCPICKSTORESETT
C_STOREPICKINGREQBOXLBLFORMVHBox Label Form SettingsCBOXLABELLISTVH
C_STOREPICKINGREQREASSIGNVHFor reassigning usersCSTPKREQRASSVH
C_STOREPICKINGREQUESTPRSNLZNStore Picking Request PersonalizationCSTRPERSFRMWRK
C_STOREPICKINGREQUESTSTATUSVHPicking Request Status Value HelpCSTRPICKSTATUSVH
C_STOREPICKREQCNTNTLISTFORMVHContent List Form SettingsCCNTNTLISTVH
C_STOREPICKUPORDERVHStore Pickup Order Value HelpCSTRPICKUPORDVH
C_STOREPKNGREQSUBSTNITEMPicking Request Subst itemCSTRPKNGSBSTITEM
C_STOREPKNGREQTAKEOVRUSERSVHTake over of picking requests VHCSTPKRQTKVRUSRVH
E_STOREPICKINGREQUESTExtension view for RFM_ST_PICK_REQESTRPICKREQ
E_STOREPICKINGREQUESTITEMExtension view for RFM_ST_PICK_REQIESTRPICKREQITM
E_STORESTOCKADJUSTMENTITEMExtension View For StoreStkAdjmtItemESTRADJSTKITM
I_CNTSTOREPRODRFIDBSCSETTINGSBasic Settings Count Products with RFIDIRTSTCPRBSCSTGS
I_CNTSTOREPRODRFIDSTTGFORSTOREStore Settings in Cnt Products with RFIDIRTSTCPRSTRESTTG
I_MOVEPRODRFIDBASICSETTINGSBasic Settings Move Products with RFIDIMSPRBASICSTTGS
I_MOVEPRODRFIDSETTINGSFORSTOREStore Settings in Move Products w/ RFIDIMSPRSTORESTTG
I_MOVEPRODUCTSWLBASICSETTINGSBasic Customizing SettingsIMPWBSCSTTGS
I_MOVEPRODWLSETTINGSFORSTORESettings for StoreIMVPRDWLSTTGSTOR
I_PICKREQSCHEMAFORSTORERetail Store Customizng Schema for StoreIPKRQSCHMFORSTR
I_PICKREQSCHEMASTOREASSGMTPicking Rqst Customizng Schema AssgnmntIPKRQSCHMSTASGMT
I_PRODUCTSFORSALEINRTLSTORERetail Store Products available for saleIRTSTSELLABLPROD
I_RETAILSTOREAPPLICATIONApplication in Retail StoreIRTSTAPPLICATION
I_RETAILSTOREAPPLICATIONSTORERetail Store Application and StoreIRTSTAPPLSTORE
I_RETAILSTOREASSIGNABLEUSERAssignable Users per Store in Retail Store AppsIRTSTASSGBLUSER
I_RETAILSTOREIMAGETYPERetail Store Image TypeIRTSTIMAGETYPE
I_RETAILSTOREIMAGETYPETRetail Store Image Type TextIRTSTIMAGETYPET
I_RETAILSTOREPRODUCTIMAGERetail Store Product Image HelperIRTSTPRODIMAGE
I_RETAILSTORESCHEMARetail Store Customizing SchemaIRTSTSCHEMA
I_RETAILSTORESCHEMAFORSTORERetail Store Customizng Schema for StoreIRTSTSCHMAFORSTR
I_RETAILSTORESCHEMASTOREASSGMTRetail Store Customizing Schema AssgnmntIRTSTSCHEMASTORE
I_RETAILSTORESCHEMATYPERetail Store Customizing Schema TypeIRTSTSCHEMATYPE
I_RETAILSTORESCHEMATYPETRetail Store Customizing Schema Type TxtIRTSTSCHEMATYPET
I_RETAILSTORETASKRetail Store TaskIRETAILSTORETASK
I_RETAILSTORETASKLISTRetail Store Task ListIRTSTTASKLIST
I_RETAILSTORETASKTRetail Store CMP Task TxtIRTSTCMPTASKT
I_RETAILSTOREUSERASSIGNMENTUser-Assigned Store in Retail Store AppsIRTSTASSGNDSTORE
I_STORAGELOCATIONLASTRFIDCOUNTLast RFID Count for Storage LocationISTRGELCTNLSTCNT
I_STOREADJMASSSTKPRSNLZNStore Personalization SettingISTRASPRSNLZFRWK
I_STOREADJMASSSTKPRSNLZNSTTGprsnlz Setting for AdjustMassStockISTRPRSNLZNSTGG
I_STOREHANDOVERBASICSETTINGSHandover Products Basic SettingsIHANDOVERBASESET
I_STOREHANDOVERORDERPRSNLZNStore Handover Order PersonalizationISTRHNDPERSFRMWR
I_STOREHANDOVERORDERSETTINGSHandover Products Settings For StoreIHANDOVERSETT
I_STOREMAINTPICKINGSQNCComposite view on I_StoreMaintPickingSqncTypeISTMANTPICSEQ
I_STOREMAINTPICKINGSQNCTYPEBasic View on RFM_ST_PICK_SQNCISTMANTPICSQNTYP
I_STOREMNTNPICKSQNCBSCSETTINGSStore picking sequence basicISTMAINPICSQBSC
I_STOREMNTNPICKSQNCSETTINGSStore picking sequenceISTOMAINTPICSQSC
I_STOREORDERPAYMENTSTATUSTEXTOrder Picking Status TextISTRPAYMKSTATTXT
I_STOREORDERPAYMENTSTATUSVHOrder Payment Status Value HelpISTRORDPAYMSTVH
I_STOREORDERPICKINGSTATUSTEXTOrder Picking Status TextISTRPICKSTATTXT
I_STOREORDERPICKINGSTATUSVHOrder Picking Status Value HelpISTRORDPICKSTVH
I_STOREORDERREJECTIONREASONVHReason code for order cancellationISTRORDCANRESVH
I_STOREPERSONALIZATIONSETTINGSStore Personalization SettingsISTRPERSNLZNSTNG
I_STOREPICKINGBASICSETTINGSPicking Products Basic SettingsIPICKBASESET
I_STOREPICKINGPRODUCTSETTINGSPicking Products Settings For StoreIPICKSTORESETT
I_STOREPICKINGREQASSIGNABLEUSRList of Assignable user for storeISTRASSABLUSR
I_STOREPICKINGREQBOXLBLFORMVHBox Label Form Value HelpIBOXLABELLISTVH
I_STOREPICKINGREQSCHEMAStore Picking Req Customizing SchemaISTRPKREQSCHEMA
I_STOREPICKINGREQUESTStore Picking RequestISTRPICKREQ
I_STOREPICKINGREQUESTITEMStore Picking Request ItemISTRPICKITEM
I_STOREPICKINGREQUESTITEMCOUNTStore Picking Request Item CountISTRPKREQITMCNT
I_STOREPICKINGREQUESTITEMTPStore Picking Request ItemISTRPICKITEMTP
I_STOREPICKINGREQUESTPRSNLZNStore Picking Request PersonalizationISTRPERSFRMWRK
I_STOREPICKINGREQUESTSTATUSPicking Request Status TextISTRPKREQSTATUS
I_STOREPICKINGREQUESTSTATUSVHPicking Request Status Value HelpISTRPICKSTATUSVH
I_STOREPICKINGREQUESTTPStore Picking RequestISTRPICKREQTP
I_STOREPICKREQCNTNTLISTFORMVHContent List Form Value HelpICNTNTLISTVH
I_STOREPICKUPORDERStore Pickup OrderISTPICKUPORD
I_STOREPICKUPORDERBASICSETTINGPickup Order Basic SettingISTPKPORDBASESET
I_STOREPICKUPORDERITEMStore Pickup Order ItemsISTPICKORDITM
I_STOREPICKUPORDERITEMSTOTAggregated items for OrderISTPICKUPORDTOT
I_STOREPICKUPORDERPICKEDITEMTPPicked Items for OrderISTPKORDPKITM
I_STOREPICKUPORDERPICKREQTPPicking Request for Picked OrderISTPKORDPIKRQ
I_STOREPICKUPORDERREQDITEMSRequested Items in Store Pickup OrderISTPICKUPORDREQD
I_STOREPICKUPORDERSETTINGPickup Order Settings For StoreIPICKORDSETT
I_STOREPICKUPORDERTPStore Pickup OrderISTPICKUPORDTP
I_STOREPICKUPORDERVHStore Pickup Order Value HelpISTRPICKUPORDVH
I_STOREPICKUPORDEXCPTNITEMTPStore Pickup Order Exception ItemsISTPKORDEXITMTP
I_STOREPICKUPORDWTHCONFIGNPickup order with configurationISTPICKORDWTHC
I_STOREPKNGREQSUBSTNITEMPicking Request Subst itemISTRPKNGSBSTITEM
I_STOREPKUPORDAGGRGDEXCPTNITMSAggregated Items with Exception in OrderISTPICKUPORDEXAG
I_STOREPKUPORDSUBSTITUTEDITMSSubstituted Items in Store Pickup OrderISTPICKUPORDSUBS
I_STOREPRODRFIDCNTPRODINSTANCEStore Product RFID Count Product InstceIRTSTCPRCNTPRDIN
I_STOREPRODUCTRFIDCNTPRODNMBRSStore Product RFID Count Prod NumbersIRTSTCPRCNTPRDNB
I_STOREPRODUCTRFIDCOUNTStore Product RFID CountIRTSTCPRCOUNT
I_STOREPRODUCTRFIDCOUNTAPPLLOGStore Product RFID Count Application LogIRTSTCPRCNTAPLOG
I_STOREPRODUCTRFIDCOUNTNUMBERSStore Product RFID Count NumbersIRTSTCPRCNTNMBRS
I_STOREPRODUCTRFIDCOUNTPRDCSSRStore Product RFID Count PredecessorIRTSTCPRCNTPRDCR
I_STOREPRODUCTRFIDCOUNTPRODUCTStore Product RFID Count ProductIRTSTCPRCNTPRD
I_STOREPRODUCTRFIDMOVEMENTStore Product RFID MovementIMSPRMOVEMENT
I_STORERCVGDOCTRUSTEDPOSTGSTSTrusted Posting Status of Store Receiving DocumentISTRDOCTRSTDPOST
I_STORERECEIVINGDOCGRSTATUSStore Receiving Document Goods Receipt StatusISTRECVDOCGRSTS
I_STORERECEIVINGDOCGRSTATUSTStore Receiving Document Goods Receipt Status TextISTRECVDOCGRSTST
I_STORERECEIVINGDOCITEMMATLDOCMaterial Documents of Store Receiving Document ItemISTRDOCITMMDOC
I_STORESTOCKADJMTREASONVHStore Stock Adjustment ReasonISTSTKADJRSN
I_STORESTOCKADJMTSTATUSTEXTStore Stock Adjustment Status textISTRSTKADJSTATXT
I_STORESTOCKADJUSTMENTStore Stock AdjustmentISTORESTKADJ
I_STORESTOCKADJUSTMENTITEMStore Stock Adjustment ItemISTORESTKADJITM
I_STORESTOCKADJUSTMENTSTATUSSyore Stock Adjustment StatusISTORESTKADJSTAT
P_COCODECRCYBYSTORE_F4674Stores enriched by their company code currencyPCCCRCYBYSTF4674
P_CSPRAPPLICATIONLOGCount Products with RFID: Application Log helperPCSPRAPPLLOG
P_CSPRCOUNTGTINCount Products with RFID: GTIN helperPCSPRCOUNTGTIN
P_DAILYGROSSSALESBYSTORE_F4674Daily gross sales by store, including sales and returnsPDLYGRSSLSF4674
P_DAILYGROSSSLSPOSTGDTE_F4674Fixed list of posting dates for gross salesPDLYGRSLDTEF4674
P_DELIVHNDLGUNITFORSTORE_F4674Handling Units of Deliveries for StorePDELHUSTOREF4674
P_HANDLINGUNITAGGRGDQTY_F4674Aggregated Quantities for Handling UnitPHUAGGRQTYF4674
P_HANDLINGUNITHELPER_F4674Handling Unit Helper ViewPHUHELPERF4674
P_HANDLINGUNITITMQTY_F4674Quantities per Handling Unit ItemPHUITMQTYF4674
P_HNDLGUNITGOODSRCPTSTS_F4674Goods Receipt Status of Handling UnitPHUGRSTSSF4674
P_HNDLGUNITITMCMPTBLTY_F4674Handling Unit Item CompatibilityPHUITMCOMPTF4674
P_HNDLGUNITITMPOSTGSTS_F4674Store Receiving HU Posting StatusPHUITMPOSTSF4674
P_HNDLGUNITWTHTOPLEVELID_F4674Top Level Handling Unit per HUPHUTOPLEVELF4674
P_MATLDOCITEMCMPTBLTY_F4674Material Document Item with negative qty for cancellationsPMATDOCITMCF4674
P_MONTHTODATEOFYSTD_F4674Date range: begin of month to given date wrt yesterdayPMNTODTOFYDF4674
P_MSPWAGGREGATEDUNPROCESSDSALEAggregated Unprocessed SalesPMSPWAGGRSALE
P_MSPWMOVABLEPRODUCTMPW: Worklist of proposed movements (helper)PMSPWMOVABLEPROD
P_MSPWPRODUCTSTOCKMPW: Calculate stock per storage location and productPMSPWPRDSTCK
P_MSPWSELLABLEPRODUCTMPW: Products available for salePMSPWSELLABLPROD
P_MSPWSTOREPOSSTORAGELOCATIONMPW: POS Storage Location for StorePMSPWPOSSTORLOC
P_MSPWWORKITEMMPW: Worklist of proposed movements (helper)PMSPWWORKITEM
P_PACKEDDELIVERYFORSTORE_F4674Incoming Deliveries for StorePPCKDDELVSTF4674
P_REFSLSRETSSUMBYSTORE_F4674Reference gross sales and returns by storePREFSLSRETSF4674
P_RETAILSTOREASSIGNABLEUSERAssignable Users per Store in Retail Store AppsPRTSTASSGBLUSER
P_RETAILSTOREPRSNLZNFRAMEWORKRetail Store Personalization Framework helperPRTSTPERSFRMWRK
P_RETAILSTOREUSERASSIGNMENTRetail Store User-Assigned Store filter helperPRTSTUSERASSIGN
P_RLVTMATERIALDOCRECORD_F4674Filtered Material Document RecordsPRELMATDOCF4674
P_RTLPROMNAGGRGDPERSTORE_F4674Aggregated Retail Promotion Items by Store and PromotionPRTLPRMAGSTF4674
P_RTLPROMNITMSTORESLSUOM_F4674Retail Promotion Items with Qty in Sales UnitPRTLPRMSTSUF4674
P_SALESRETURNSSUMBYDAY_F4674Daily sum of gross sales and returns by storePSLSRETDAYF4674
P_STOREPERSONALIZATIONSETTINGPersnlzSetting For AdjustMassStockPSTRAMSFRW
P_STOREPICKINGREQAUTHZDUSERAuthrized users for picking appPSTRASSAUTHUSR
P_STOREPICKINGREQAUTHZDUSERALLAuthrized users for picking app AllPSTRASSAUTHUSRA
P_STOREPICKINGREQUESTPRSNLZNStore Picking Request PersonalizationPSTRPERSFRMWRK
P_STOREPOSMOVEMENTTYPES_F4674POS relevant movement types by storePPOSMVTTYSTF4674
P_STOREPRODUCTRFIDCNTPRODCALCCounted EPCs for RFID Count Prod helperPRTSTCPRCNTPRDCA
P_STOREPRODUCTRFIDCNTPRODNMBRSStore Product RFID Cnt Prd Nmbrs helperPRTSTCPRCNTPRDNB
P_STOREPRODUCTRFIDCOUNTCALCCounted EPCs for RFID Count helperPRTSTCPRCNTCALC
P_STORESTKADJMTSCHEMAFORSTOREStock adjustment Default schemaPSTRSTKADJSCHEMA
P_STORESTOCKADJMTPRODUCTCOUNTstore stock products countPSTRSTKPRDCNT
P_STORESTOCKADJUSTMENTBUSTRANSBusiness transactionPSTRSTKADJBUST
P_STORESTOCKADJUSTMENTSUMStore Stock Adjustment AggregationPSTORESTKADJSUM
R_STORESTOCKADJUSTMENTITEMTPStore Stock Adjustment ItemRSTORESTKADJITP
R_STORESTOCKADJUSTMENTTPStore Stock AdjustmentRSTORESTKADJTP

Other CDS Views