I_SVTPurgPrprocgDocument

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 I_SVTPurgPrprocgDocument.
-- 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: ISVTPREPROCPUR

CREATE VIEW I_SVTPurgPrprocgDocument AS
SELECT
  SVTConfirmedPurchasingDocUUID,
  PostingDate,
  Material,
  cast( materialquantity as ehpma_svt_subst_vol_ui ) AS Quantity,
  materialquantityunit AS QuantityUnit,
  MaterialDocument,
  MaterialDocumentItem,
  MaterialDocumentYear,
  ReceivingCompanyCode,
  ReceivingPlant,
  ReceivingStorageLocation,
  DeliveringPlant,
  DeliveringStorageLocation,
  creationtimelogsystem AS CreationTime,
  CreationDateTime,
  processedstatus AS SVTPreprocessingStatus,
  OrderQuantity,
  orderquantityuom AS OrderQuantityUnit,
  IsDeleted,
  GoodsMovementType,
  DebitCreditCode,
  AccountingDocumentType,
  InventoryTransactionType,
  ProdCmplncEventUUID,
  ProdCmplncExclCoPlntUUID,
  BusinessPartnerSupplier,
  SupplierAddressID,
  ReceivingCountry,
  DeliveringCountry,
  SupplierIsImporter,
  PurchaseOrder,
  PurchaseOrderItem,
  PurchasingDocumentCategory,
  PurchasingDocumentType,
  PurchasingDocumentItemCategory,
  DeliveringRegion,
  svtcalculatedsupplier AS SVTSelectedBusinessPartner,
  svtcalculatedsupplierid AS SVTSelectedSupplier,
  svtcalulatedsupplieraddressid AS SVTSelectedSupplierAddressID,
  ReceivingRegion,
  IsReturnsItem,
  imprtrespycalcdrespimporter AS SVTBizProcCatRespImporter,
  SVTBusinessProcessCategory,
  sourceisbondedwarehouse AS DlvgLocationIsBondedWarehouse,
  targetisbondedwarehouse AS RcvgLocationIsBondedWarehouse,
  sourceaddressid AS SVTSourceAddressID,
  sourceaddresstype AS SVTSourceAddressType,
  targetaddressid AS SVTTargetAddressID,
  targetaddresstype AS SVTTargetAddressType,
  cast( svtcalulatedsupplierfunction as ehpma_svt_calcd_suppl_function ) AS SVTSeldSupplierPartnerFunction
FROM ehpmad_svt_purco
LEFT OUTER JOIN I_Country AS _ReceivingCountry ON ReceivingCountry = _ReceivingCountry.Country  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON SVTSelectedSupplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_SVTSourceAddressType AS _SourceAddressType ON SVTSourceAddressType = _SourceAddressType.SVTSourceAddressType  -- association [0..1]
LEFT OUTER JOIN I_SVTTargetAddressType AS _TargetAddressType ON SVTTargetAddressType = _TargetAddressType.SVTTargetAddressType  -- association [0..1]
LEFT OUTER JOIN I_ImprtRespyRespImporter AS _ResponsibleImporter ON SVTBizProcCatRespImporter = _ResponsibleImporter.ImprtRespyRespImporter  -- association [0..1]
LEFT OUTER JOIN I_PurchasingDocumentCategory AS _PurgDocumentCategory ON PurchasingDocumentCategory = _PurgDocumentCategory.PurchasingDocumentCategory  -- association [0..1]
LEFT OUTER JOIN I_PurgDocumentItemCategory AS _PurgDocumentItemCategory ON PurchasingDocumentItemCategory = _PurgDocumentItemCategory.PurchasingDocumentItemCategory  -- association [0..1]
LEFT OUTER JOIN I_PurchasingDocumentType AS _PurgDocumentType ON PurchasingDocumentType = _PurgDocumentType.PurchasingDocumentType AND PurchasingDocumentCategory = _PurgDocumentType.PurchasingDocumentCategory AND PurchasingDocumentCategory = _PurgDocumentType.PurchasingDocumentCategory  -- association [0..1]
LEFT OUTER JOIN I_Region AS _ReceivingRegion ON ReceivingRegion = _ReceivingRegion.Region AND ReceivingCountry = _ReceivingRegion.Country  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON QuantityUnit = _UnitOfMeasure.UnitOfMeasure  -- association [1..1]
;