C_PhysInvtryMngItmListDocItemQ

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_PhysInvtryMngItmListDocItemQ.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- Parameters: P_Language : sylangu

CREATE VIEW C_PhysInvtryMngItmListDocItemQ AS
SELECT
  cast(_PhysicalInventoryDocumentItem.FiscalYear as fis_gjahr_no_conv preserving type) AS FiscalYear,
  PhysicalInventoryDocument,
  PhysicalInventoryDocumentItem,
  Material,
  cast(_Product._Text[1: Language = $parameters.P_Language].ProductName as maktx preserving type ) AS ProductName,
  MaterialDocumentYear,
  MaterialDocument,
  MaterialDocumentItem,
  ChangeDocObject,
  Plant,
  _Plant.PlantName AS PlantName,
  StorageLocation,
  _StorageLocation.StorageLocationName AS StorageLocationName,
  WarehouseStorageBin,
  Batch,
  InventorySpecialStockType,
  _InventorySpecialStockType._Text[1: Language = $parameters.P_Language].InventorySpecialStockTypeName AS InventorySpecialStockTypeName,
  PhysicalInventoryStockType,
  _PhysicalInventoryStockType._Text[1: Language = $parameters.P_Language].PhysicalInventoryStockTypeName AS PhysicalInventoryStockTypeName,
  SalesOrder,
  SalesOrderItem,
  ScheduleLine,
  Supplier,
  _Supplier.SupplierName AS SupplierName,
  Customer,
  _Customer.CustomerName AS CustomerName,
  LastChangedByUser,
  cast(_LastChangeUser.UserDescription as im_pi_changed_by_user_desc) AS LastChangedByUserDescription,
  LastChangeDate,
  _PhysicalInventoryDocument(P_Language: $parameters.P_Language).LastChangeDateTime AS LastChangeDateTime,
  CountedByUser,
  _CountedByUserContactCard.FullName AS CountedByUserDescription,
  PhysicalInventoryLastCountDate,
  AdjustmentPostingMadeByUser,
  cast(_AdjustmentPostingMadeByUser.UserDescription as pi_adjustment_posting_usr_desc) AS AdjmtPostingMadeByUserDesc,
  PostingDate,
  PhysicalInventoryItemIsCounted,
  PhysInvtryItemIsDeleted,
  PhysicalInventoryItemIsZero,
  PhysInvtryRecountDocument,
  cast(Quantity as pi_item_cntd_qty_16_3) AS Quantity,
  MaterialBaseUnit,
  Currency,
  cast(CycleCountType as mmim_cycle_count_type preserving type) AS CycleCountType,
  NmbrOfPhysInvtryPerFiscalYear,
  PhysInvtryIntvlForCycCounting,
  PhysInvtryFloatTimeCycCounting,
  ReasonForPhysInvtryDifference,
  _PhysInvtryReasonCode._PhysInvtryReasonCodeText[1: Language = $parameters.P_Language].ReasonForPhysInvtryDiffText AS ReasonForPhysInvtryDiffText,
  cast(BookQtyAmountInCoCodeCrcy as pi_item_book_value_16) AS BookQtyAmountInCoCodeCrcy,
  cast(EnteredSlsAmtInCoCodeCrcy as pi_item_ext_value_sp_16) AS EnteredSlsAmtInCoCodeCrcy,
  cast(SlsPrcAmtInclVATInCoCodeCrcy as pi_vkwrt_16) AS SlsPrcAmtInclVATInCoCodeCrcy,
  cast(SlsPriceAmountInCoCodeCrcy as pi_item_sp_of_book_value_16) AS SlsPriceAmountInCoCodeCrcy,
  DiffSlsPrcAmtInCoCodeCrcy,
  CrossPlantConfigurableMaterial,
  _CrossPlantConfigurableMatl._Text[1: Language = $parameters.P_Language].MaterialName AS CrossPlantConfigurableMatlName,
  PhysInvtryDifferenceIsPosted,
  PhysInvtryItemIsRecounted,
  ProductCategory,
  _ProductCategory._Text[1: Language = $parameters.P_Language].Name AS ProductCategoryDescription,
  UnitOfEntry,
  WBSElementExternalID,
  WBSDescription,
  cast(DifferenceAmountInCoCodeCrcy as pi_item_diff_value_16) AS DifferenceAmountInCoCodeCrcy,
  cast(PhysInvtryCtAmtInCoCodeCrcy as pi_item_counted_qty_value_16) AS PhysInvtryCtAmtInCoCodeCrcy,
  MovementTypeForReasonCode,
  GoodsMovementType,
  _GoodsMovementType._Text[1: Language = $parameters.P_Language].GoodsMovementTypeName AS GoodsMovementTypeName,
  _GoodsMovementReasonControl.GoodsMovementReasonControl AS GoodsMovementReasonControl,
  cast(BookQtyBfrCountInMatlBaseUnit as pi_buchm_16_3) AS BookQtyBfrCountInMatlBaseUnit,
  ValuationType,
  _PhysicalInventoryDocument(P_Language: $parameters.P_Language).PhysInventoryPlannedCountDate AS PhysInventoryPlannedCountDate,
  _PhysicalInventoryDocument(P_Language: $parameters.P_Language).PhysicalInventoryDocumentDesc AS PhysicalInventoryDocumentDesc,
  _PhysicalInventoryDocument(P_Language: $parameters.P_Language).PhysInventoryReferenceNumber AS PhysInventoryReferenceNumber,
  _PhysicalInventoryDocument(P_Language: $parameters.P_Language).PhysicalInventoryNumber AS PhysicalInventoryNumber,
  _PhysicalInventoryDocument(P_Language: $parameters.P_Language).InventoryTransactionType AS InventoryTransactionType,
  _PhysicalInventoryDocument(P_Language: $parameters.P_Language)._InventoryTransactionType._Text[1: Language = $parameters.P_Language].InventoryTransactionTypeText AS InventoryTransactionTypeText,
  _PhysicalInventoryDocument(P_Language: $parameters.P_Language).DocumentDate AS DocumentDate,
  _PhysicalInventoryDocument(P_Language: $parameters.P_Language).PostingFiscalPeriod AS PostingFiscalPeriod,
  _PhysicalInventoryDocument(P_Language: $parameters.P_Language).CreatedByUserName AS CreatedByUserName,
  _PhysicalInventoryDocument(P_Language: $parameters.P_Language)._CreatedByUser.UserDescription AS CreatedByUserDescription,
  _PhysicalInventoryDocument(P_Language: $parameters.P_Language).PostingIsBlockedForPhysInvtry AS PostingIsBlockedForPhysInvtry,
  _PhysicalInventoryDocument(P_Language: $parameters.P_Language).PhysInvtryDocHasQtySnapshot AS PhysInvtryDocHasQtySnapshot,
  _PhysicalInventoryDocument(P_Language: $parameters.P_Language).PhysicalInventoryGroupType AS PhysicalInventoryGroupType,
  _PhysicalInventoryDocument(P_Language: $parameters.P_Language)._PhysInvtryGroupType._Text[1: Language = $parameters.P_Language].PhysicalInventoryGroupTypeName AS PhysicalInventoryGroupTypeName,
  _PhysicalInventoryDocument(P_Language: $parameters.P_Language).PhysicalInventoryGroup AS PhysicalInventoryGroup,
  _PhysicalInventoryDocument(P_Language: $parameters.P_Language).PhysicalInventoryType AS PhysicalInventoryType,
  cast(DifferenceQuantity as pi_item_diff_qty_i_base_unit16) AS DifferenceQuantity,
  cast(DiffCountedBookAmtInCoCodeCry as mmim_pi_dif_count_book_value16) AS DiffCountedBookAmtInCoCodeCry,
  PhysInvtryDifferenceInPercent,
  _PhysInvtryStatusT[1: Language = $parameters.P_Language].PhysicalInventoryStatusText AS PhysicalInventoryStatusText,
  cast(' ' as pi_source_document preserving type) AS PhysInvtryRecountSourceDoc,
  cast('' as boole_d preserving type) AS PhysInvtryRecountSrceDocIsHdn,
  cast('' as boole_d preserving type) AS PostPhysInvtryDifferenceIsHdn,
  cast('' as boole_d preserving type) AS RecountPhysInvtryDocItmIsHdn,
  cast('' as boole_d preserving type) AS DeleteLogicallyIsHidden,
  PhysInvtryDocumentIsPrinted,
  ChangeDocumentsIsDisabled,
  case when Batch = '' then 'X' else ' ' end as UICT_Batch AS casewhenBatchthenXelseendasUICT_Batch,
  _PhysicalInventoryDocumentItem._CrossPlantConfigurableMatl AS _CrossPlantConfigurableMatl,
  _PhysicalInventoryDocumentItem._CrossPlantConfigurableProd AS _CrossPlantConfigurableProd,
  _PhysicalInventoryDocumentItem._Currency AS _Currency,
  _PhysicalInventoryDocumentItem._Customer AS _Customer,
  _PhysicalInventoryDocumentItem._CustomerCompanyByPlant AS _CustomerCompanyByPlant,
  _PhysicalInventoryDocumentItem._InventorySpecialStockType AS _InventorySpecialStockType,
  _PhysicalInventoryDocumentItem._Material AS _Material,
  _PhysicalInventoryDocumentItem._MaterialBaseUnit AS _MaterialBaseUnit,
  _PhysicalInventoryDocumentItem._PhysicalInventoryStockType AS _PhysicalInventoryStockType,
  _PhysicalInventoryDocumentItem._PhysInvtryDocFiscalYear AS _PhysInvtryDocFiscalYear,
  _PhysicalInventoryDocumentItem._PhysInvtryDocHeader AS _PhysInvtryDocHeader,
  _PhysicalInventoryDocumentItem._PhysInvtryStatusT AS _PhysInvtryStatusT,
  _PhysicalInventoryDocumentItem._Plant AS _Plant,
  _PhysicalInventoryDocumentItem._Product AS _Product,
  _PhysicalInventoryDocumentItem._ProductCategory AS _ProductCategory,
  _PhysicalInventoryDocumentItem._SalesOrder AS _SalesOrder,
  _PhysicalInventoryDocumentItem._SalesOrderItem AS _SalesOrderItem,
  _PhysicalInventoryDocumentItem._SalesOrderScheduleLine AS _SalesOrderScheduleLine,
  _PhysicalInventoryDocumentItem._StorageLocation AS _StorageLocation,
  _PhysicalInventoryDocumentItem._Supplier AS _Supplier,
  _PhysicalInventoryDocumentItem._SupplierCompanyByPlant AS _SupplierCompanyByPlant,
  _PhysicalInventoryDocumentItem._UnitOfEntry AS _UnitOfEntry,
  _PhysicalInventoryDocumentItem._ProductPlantBasic AS _ProductPlantBasic
FROM P_PhysInvtryMngItmListDocItemQ AS _PhysicalInventoryDocumentItem
LEFT OUTER JOIN C_PhysInvtryMngItemListDocQry AS _PhysicalInventoryDocument ON PhysicalInventoryDocument = _PhysicalInventoryDocument.PhysicalInventoryDocument AND FiscalYear = _PhysicalInventoryDocument.FiscalYear  -- association [1..1]
LEFT OUTER JOIN C_PhysInvtryMngItmListSrlNmbrQ AS _SerialNumbers ON PhysicalInventoryDocument = _SerialNumbers.PhysicalInventoryDocument AND FiscalYear = _SerialNumbers.FiscalYear AND PhysicalInventoryDocumentItem = _SerialNumbers.PhysicalInventoryDocumentItem  -- association [0..*]
LEFT OUTER JOIN C_PhysInvtryMngItmListOutpReqQ AS _PhysInvtryOutpRequestItem ON PhysicalInventoryDocument = _PhysInvtryOutpRequestItem.PhysicalInventoryDocument AND FiscalYear = _PhysInvtryOutpRequestItem.FiscalYear AND _PhysInvtryOutpRequestItem.OperationIsPrinted <> 'N'  -- association [0..*]
LEFT OUTER JOIN C_ChangeDocument_2 AS _ChangeDocumentsComponent ON _ChangeDocumentsComponent.ChangeDocObjectClassForEdit = 'INV_BELEG' AND _ChangeDocumentsComponent.ChangeDocObjectForEdit = ChangeDocObject  -- association [0..*]
LEFT OUTER JOIN I_GoodsMovementReasonControl AS _GoodsMovementReasonControl ON MovementTypeForReasonCode = _GoodsMovementReasonControl.GoodsMovementType  -- association [1..1]
LEFT OUTER JOIN I_GoodsMovementType AS _GoodsMovementType ON GoodsMovementType = _GoodsMovementType.GoodsMovementType  -- association [0..1]
LEFT OUTER JOIN C_PhysInvtryReasonCode AS _PhysInvtryReasonCode ON MovementTypeForReasonCode = _PhysInvtryReasonCode.MovementTypeForReasonCode AND ReasonForPhysInvtryDifference = _PhysInvtryReasonCode.ReasonForPhysInvtryDifference  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _CountedByUserContactCard ON CountedByUser = _CountedByUserContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _CreatedByUserContactCard ON CreatedByUserName = _CreatedByUserContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _AdjustmentByUserContactCard ON AdjustmentPostingMadeByUser = _AdjustmentByUserContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _LastChangedByUserContactCard ON LastChangedByUser = _LastChangedByUserContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_Batch AS _Batch ON Material = _Batch.Material AND Plant = _Batch.Plant AND Batch = _Batch.Batch  -- association [0..1]
;