P_PhysInvtryDocItmCreateTP

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 P_PhysInvtryDocItmCreateTP.
-- 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.
-- SQL view name: PPICREATEITMTP

CREATE VIEW P_PhysInvtryDocItmCreateTP AS
SELECT
  item.PhysicalInventoryDocument AS PhysicalInventoryDocument,
  item.FiscalYear AS FiscalYear,
  item.PhysicalInventoryDocumentItem AS PhysicalInventoryDocumentItem,
  item.Plant AS Plant,
  header.StorageLocation AS StorageLocation,
  header.InventorySpecialStockType AS InventorySpecialStockType,
  header.PhysicalInventoryType AS PhysicalInventoryType,
  header.InventoryTransactionType AS InventoryTransactionType,
  header.PhysicalInventoryGroupType AS PhysicalInventoryGroupType,
  header.PhysicalInventoryGroup AS PhysicalInventoryGroup,
  header.PhysicalInventoryNumber AS PhysicalInventoryNumber,
  header.PhysInventoryReferenceNumber AS PhysInventoryReferenceNumber,
  cast(header.PhysicalInventoryDocumentDesc as pi_document_description preserving type) AS PhysicalInventoryDocumentDesc,
  cast(header.PostingIsBlockedForPhysInvtry as pi_set_posting_block preserving type) AS PostingIsBlockedForPhysInvtry,
  cast(header.PhysInvtryDocHasQtySnapshot as pi_freeze_book_inventory preserving type) AS PhysInvtryDocHasQtySnapshot,
  header.DocumentDate AS DocumentDate,
  header.PhysInventoryPlannedCountDate AS PhysInventoryPlannedCountDate,
  item.Material AS Material,
  item.Batch AS Batch,
  item.RealProductBatch AS RealProductBatch,
  item.ValuationType AS ValuationType,
  item.PhysicalInventoryStockType AS PhysicalInventoryStockType,
  item.SalesOrder AS SalesOrder,
  item.SalesOrderItem AS SalesOrderItem,
  item.Supplier AS Supplier,
  item.Customer AS Customer,
  item.StockOwner AS StockOwner,
  item.WBSElementInternalID AS WBSElementInternalID,
  _WBSElement.WBSElement AS WBSElement,
  _WBSElement.WBSDescription AS WBSDescription,
  item._Supplier AS _Supplier,
  item._SupplierCompanyByPlant AS _SupplierCompanyByPlant,
  item._Customer AS _Customer,
  item._CustomerCompanyByPlant AS _CustomerCompanyByPlant
FROM P_PhysInvtryDocItem AS item
INNER JOIN I_PhysInvtryDocHeader AS header ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_WBSElementByInternalKey AS _WBSElement ON WBSElementInternalID = _WBSElement.WBSElementInternalID AND WBSElementInternalID <> '00000000'  -- association [0..1]
;