CDS Views for VDM Physical Inventory (MM-IM-VDM-PI)

CDS View NameDescriptionSQL View Name
A_PHYSINVENTORYDOCHEADERDocument HeaderAPI_PIDOCHEADER
A_PHYSINVENTORYDOCITEMDocument ItemsAPI_PIDOCITEM
C_MATERIALKPIFORCYCLECOUNTINGC View Material KPIs for Cycle CountingCMATKPIFORCYC
C_PHYSINVENTORYSITUATIONPhys Inventory Situation Anchor/TriggerCPHYSINVSITN
C_PHYSINVTRYDOCHDRITEMTOTALSPI Document Header Item TotalsCPIDOCHDRITMTOT
C_PHYSINVTRYDOCHDROBJPAGEPI Document Header Object PageCPIDOCHEADEROP
C_PHYSINVTRYDOCITEMOBJPAGEPI Document Item Object PageCPIDOCITEMOP
C_PHYSINVTRYDOCITMCREATECDS View for the creation of new PI documentsCPICREATEITM
C_PHYSINVTRYDOCSRLNMBROBJPAGEPI Document Serial Number Object PageCPIDOCSNOP
C_PHYSINVTRYPROPOSALProposals for new PI countsCPIPROPOSAL
C_PHYSINVTRYQUERYPhysical Inventory AnalysisCPHYSINVTRYQUERY
I_ADJMTPOSTINGMOVEMENTTYPEPI Stock Adjustment Movement TypeIPIADJMVT
I_AUGMENTEDPHYSINVTRYDOCITEMAugmented Physical Inventory Doc ItemIAUPIDOCITEM
I_GOODSMOVEMENTREASONCONTROLControl fields for Goods Movement ReasonIMVMNTRSNCNTRL
I_INVENTORYTRANSACTIONTYPEInventory Transaction TypeIINVTRANSTYPE
I_INVENTORYTRANSACTIONTYPETInventory Transaction Type TextIINVTRANSTYPET
I_MATERIALKPIFORCYCLECOUNTINGI View Material KPIs fory Cycle CountingIMATKPIFORCYC
I_PHYSINVENTORYSITUATIONPhys Inventory Situation Anchor/TriggerIPHYSINVSITN
I_PHYSINVTRYCOUNTSTSPhysical Inventory Count StatusIPICTSTS
I_PHYSINVTRYCOUNTSTSTXTPhysical Inventory Count Status TextIPICTSTST
I_PHYSINVTRYCUBEPhysical Inventory CubeIPHYINVTRYCUBE
I_PHYSINVTRYDELETIONSTSPhysical Inventory Deletion StatusIPIDELSTS
I_PHYSINVTRYDELETIONSTSTXTPhysical Inventory Deletion Status TextIPIDELSTST
I_PHYSINVTRYDOCHDRFISCALYEARVHPhysical Inventory Document Hdr FYear VHIPIDOCHDRYVH
I_PHYSINVTRYDOCHDRKEYVHPhysical Inventory Document KeyIPIDOCHDRKVH
I_PHYSINVTRYDOCHEADERPhysical Inventory Document HeaderIPIDOCHEADER
I_PHYSINVTRYDOCITEMPhysical Inventory Document ItemIPIDOCITEM
I_PHYSINVTRYDOCSRLNMBRPhysical Inventory Doc Serial NumberIPIDOCSN
I_PHYSINVTRYGROUPTYPEPhysical Inventory Group TypeIPIGRPTYPE
I_PHYSINVTRYGROUPTYPETEXTPhysical Inventory Group Type TextIPIGRPTYPET
I_PHYSINVTRYPOSTSTSPhysical Inventory Posting StatusIPIPOSTSTS
I_PHYSINVTRYPOSTSTSTXTPhysical Inventory Posting Status TextIPIPOSTSTST
I_PHYSINVTRYREASONCODEPhysical Inventory Reason TypeIPIREASON
I_PHYSINVTRYREASONCODETEXTPhysical Inventory Reason Type TextIPIREASONT
I_PHYSINVTRYSTATUSTPhysical Inventory Status TextIPISTST
I_PHYSINVTRYSTOCKTYPEPhysical Inventory Stock TypeIPISTOCKTYPE
I_PHYSINVTRYSTOCKTYPETEXTPhysical Inventory Stock Type TextIPISTOCKTYPET
I_PHYSINVTRYTYPEPhysical Inventory TypeIPITYPE
I_PHYSINVTRYTYPETEXTPhysical Inventory Type TextIPITYPET
I_STOCKTAKINGTRANSACTIONTYPETrans. Types For Inventory/Stock TakingISTCKTKNGTRNSTYP
P_ENHPHYSINVTRYACTVSTKSEPAdditional fields for P_EnhPhysInvtryActvStkSeparatorPENHACTVSTOCKSEP
P_ENHPHYSINVTRYACTVSTKSEPVALActive stock separators for which a PI count can be donePPIEACTSTKSEPVL
P_MAPPEDPHYSINVTRYITEMPI Items with mapped stock typePMAPPEDPIITEM
P_MATDOCEXTRACTSUPPLIERSTKVALMatdoc_Extract Supplier Stock ValuationPMATDOCEXTSUPPSV
P_MATDOCRECMaterial Documents without Link to PI ItemPMATDOCREC
P_MATERIALDOCUMENTEXTRACTBasis view for MATDOC EXTRACT tablePMATDOCEXT
P_MATERIALKPICNSMPNOFSTOCKConsumption + Cons Value of StockPMATKPICOVASTK
P_MATERIALKPICONSUMPTIONConsumption + Cons Value of MaterialPMATKPICONSMAT
P_MATERIALKPICONSUMPTIONSTOCKSCons stocks which are used in Phys InvPMATKPICONSSTK
P_MATERIALKPIFORCYCLECOUNTINGAll KPIs of Material for Cycle CountingPMATKPIFORCYC
P_MATERIALKPIPHYSINVTRYDIFFPhysical Inv Differences for materialsPMATKPIPIFORMAT
P_MATERIALKPIQTYVALAVGQuantity and VAlue + AVG of MaterialPMATKPIMATAVG
P_MATERIALKPIQTYVALAVGOFSTOCKQuantity and Value + AVG of StocksPMATKPISTKAVG
P_MATERIALKPISTOCKSFORPHYSINVAll Stocks with are used in Phys InvPMATKPISTKPIN
P_PHYSINTRYCURRENTPERIODPrivate Consumption View for Fiscal Years / PeriodsPPIMARV
P_PHYSINTRYVALUATIONAREAPrivate Consumption View for Valuation AreaPPIVALAREA
P_PHYSINVENTORYSITUATIONPhysical Inventory SituationPPHYSINVSITN
P_PHYSINVTRYACTVSTKSEPARATORActive stock separators for which a PI count can be donePPIACTVSTOCKSEP
P_PHYSINVTRYCOUNTSITNINSTOFDOCPhysical Inv count Situation InstancesPPICOUNTSITN
P_PHYSINVTRYDOCHDRITEMTOTALSPI Document Header Item TotalsPPIDOCHDRITMTOT
P_PHYSINVTRYDOCITEMPI Document Calculate Difference ValuesPPIDOCITEM
P_PHYSINVTRYDOCITEMPERYEARPI Difference per yearPPIDIFFPY
P_PHYSINVTRYDOCITMCREATETPCDS View for the creation of new PI documentsPPICREATEITMTP
P_PHYSINVTRYDOCSRLNMBRPhysical Inventory Doc Serial NumberPPIDOCSN
P_PHYSINVTRYKEYFIGURESBASEBasis for the calc. of PI Key Figures for a Stock Sep. Comb.PPIKEYFIGBASE
P_PLANTKPIFORCYCLECOUNTINGPlant KPIs For Cycle CountingPMATKPIFORPLNT
P_PLANTMAINTOBJECTLISTPlant Maintenance Object ListPLNTMNTOBJ
P_PLANTSWITHCYCLECOUNTINDPlants with Cycle Counting IndicatorsPPLANTWITHCCIND