C_PhysInvtryDocItmCreate

CDS View for the creation of new PI documents | view: CPICREATEITM | TRAN | Extraction: Not supported | Component: VDM Physical Inventory
Tables used: IKPF, ISEG, PRTE, T001K, T001W, PROJ, PRPS, T150, T159C
Column Name Description
PhysicalInventoryDocument Physical Inventory Document
FiscalYear Fiscal Year
PhysicalInventoryDocumentItem Physical Inventory Item Number
Column Name Description
Column Name Description
Column Name Description
DocumentDate Document Date in Document
PhysInventoryPlannedCountDate Planned Date of Inventory Count
Column Name Description
PhysicalInventoryType Physical Inventory Type Show values
PhysicalInventoryGroupType Type of Grouping Criterion Show values
PostingIsBlockedForPhysInvtry Set Posting Block Show values
PhysInvtryDocHasQtySnapshot Freeze Book Inventory Show values
Column Name Description Domain name
PhysicalInventoryGroup Grouping Criterion of Physical Inventory Document Item CHAR10
PhysicalInventoryNumber Physical Inventory Number XBLNR1
PhysInventoryReferenceNumber Physical Inventory Reference XBLNR1
PhysicalInventoryDocumentDesc Description of Physical Inventory Document TEXT40
SalesOrder Sales Order Number VBELN
SalesOrderItem Sales Order Item NUM06
StockOwner Owner of stock LIFNR
WBSElement Work Breakdown Structure Element (WBS Element) PS_POSID
LinkedSAPObjectKey Document Management Object Key OBJKY
Master Data Relations Join Conditions
Batch Number
  • Batch Number
  • Client
  • Plant
  • Material Number
  • C_PHYSINVTRYDOCITMCREATE.BATCH == MCHA.CHARG
  • C_PHYSINVTRYDOCITMCREATE.MANDT == MCHA.MANDT
  • C_PHYSINVTRYDOCITMCREATE.PLANT == MCHA.WERKS
  • C_PHYSINVTRYDOCITMCREATE.MATERIAL == MCHA.MATNR
Customer Number
  • Client
  • Customer Number
  • C_PHYSINVTRYDOCITMCREATE.MANDT == KNA1.MANDT
  • C_PHYSINVTRYDOCITMCREATE.CUSTOMER == KNA1.KUNNR
Special Stock Indicator
  • Client
  • Special Stock Indicator
  • C_PHYSINVTRYDOCITMCREATE.MANDT == T148.MANDT
  • C_PHYSINVTRYDOCITMCREATE.INVENTORYSPECIALSTOCKTYPE == T148.SOBKZ
Inventory Transaction Type C_PHYSINVTRYDOCITMCREATE.INVENTORYTRANSACTIONTYPE == T158V.VGART
Material Number
  • Client
  • Material Number
  • C_PHYSINVTRYDOCITMCREATE.MANDT == MARA.MANDT
  • C_PHYSINVTRYDOCITMCREATE.MATERIAL == MARA.MATNR
Plant
  • Client
  • Plant
  • Material Number
  • C_PHYSINVTRYDOCITMCREATE.MANDT == MARC.MANDT
  • C_PHYSINVTRYDOCITMCREATE.PLANT == MARC.WERKS
  • C_PHYSINVTRYDOCITMCREATE.MATERIAL == MARC.MATNR
Storage location
  • Client
  • Plant
  • Storage location
  • C_PHYSINVTRYDOCITMCREATE.MANDT == T001L.MANDT
  • C_PHYSINVTRYDOCITMCREATE.PLANT == T001L.WERKS
  • C_PHYSINVTRYDOCITMCREATE.STORAGELOCATION == T001L.LGORT
Vendor's account number
  • Client
  • Vendor's account number
  • C_PHYSINVTRYDOCITMCREATE.MANDT == LFA1.MANDT
  • C_PHYSINVTRYDOCITMCREATE.SUPPLIER == LFA1.LIFNR