F_Mmim_Findmatdoc

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 F_Mmim_Findmatdoc.
-- 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: FMMIMFINDMATDOC
-- Parameters: P_Language : sylangu

CREATE VIEW F_Mmim_Findmatdoc AS
SELECT
  MaterialDocument,
  MaterialDocumentYear,
  MaterialDocumentItem,
  StockChangeType,
  StockChangeContext,
  StockChangeSelectionType,
  CalculatedStockChangeType,
  IsCancelled,
  DocumentTitle,
  cast(CalculatedStockChangeTypeName as mmim_stock_change_seltypename) AS CalculatedStockChangeTypeName,
  Material,
  case when Material = '' then _PurchasingDocumentItem.PurchasingDocumentItemText else _Material._Text[1: Language=$parameters.P_Language].MaterialName end as MaterialName AS MaterialNameendasMaterialName,
  cast(_PurchasingDocumentItem.PurchasingDocumentItemText as mmim_pur_doc_item_txt) AS PurchasingDocumentItemText,
  MaterialGroup,
  _MaterialGroup._Text[1: Language=$parameters.P_Language].MaterialGroupName AS MaterialGroupName,
  MaterialType,
  _MaterialType._Text[1: Language=$parameters.P_Language].MaterialTypeName AS MaterialTypeName,
  Plant,
  _Plant.PlantName AS PlantName,
  Batch,
  StorageLocation,
  IsAutomaticallyCreated AS IsAutoCreatedTransPost,
  cast(IsAutomaticallyCreated as mmmim_auto_created_ind) AS IsAutomaticallyCreated,
  _I_AutoCrtedIdfrVH.MatlDocLineItmAutoCrtedIdfrTxt AS MatlDocLineItmAutoCrtedIdfrTxt,
  _StorageLocation.StorageLocationName AS StorageLocationName,
  Supplier,
  _Supplier.SupplierName AS SupplierName,
  SalesOrder,
  SalesOrderItem,
  WBSElement,
  WBSElementInternalID,
  _WBSElement.WBSDescription AS WBSDescription,
  Customer,
  _Customer.CustomerName AS CustomerName,
  InventoryStockType,
  _InventoryStockType._Text[1: Language=$parameters.P_Language].InventoryStockTypeName AS InventoryStockTypeName,
  InventorySpecialStockType,
  _InventorySpecialStockType._Text[1: Language=$parameters.P_Language].InventorySpecialStockTypeName AS InventorySpecialStockTypeName,
  GoodsMovementType,
  GoodsMovementRefDocType,
  GoodsReceiptType,
  ConsumptionPosting,
  _GoodsMvtTypeBySpclStkIndT[1: Language=$parameters.P_Language].GoodsMovementTypeName AS GoodsMovementTypeName,
  GoodsMovementReasonCode,
  _F3_Mmim_ReasonCT.GoodsMovementReasonName AS GoodsMovementReasonName,
  WorkItem,
  PersonnelNumber,
  DocumentItemText,
  DocumentDate,
  PostingDate,
  _Mmim_Findmatdoch.CreationDate AS CreationDate,
  _Mmim_Findmatdoch.CreationTime AS CreationTime,
  cast(dats_tims_to_tstmp(CreationDate, CreationTime, abap_system_timezone($session.client, 'NULL'), $session.client, 'NULL') as timestamp) as CreationDateTime AS clientNULLastimestampasCreationDateTime,
  ResourceId,
  IssgOrRcvgResourceID,
  CreatedByUser,
  _CreatedByUser.UserDescription AS CreatedByUserDescription,
  AccountingDocumentType,
  _F_Mmim_Blart.AccountingDocumentTypeName AS AccountingDocumentTypeName,
  InventoryTransactionType,
  _InventoryTransactionTypeT[1: Language=$parameters.P_Language].InventoryTransactionTypeText AS InventoryTransactionTypeText,
  DocumentReferenceId,
  BillOfLading,
  MaterialDocumentHeaderText,
  PurchaseOrder,
  PurchaseOrderItem,
  DeliveryDocument,
  DeliveryDocumentItem,
  OrderID,
  IssuingOrReceivingMaterial,
  _Ir_Material._Text[1: Language=$parameters.P_Language].MaterialName AS IssuingOrReceivingMaterialName,
  IssuingOrReceivingPlant,
  _Ir_Plant.PlantName AS IssuingOrReceivingPlantName,
  IssuingOrReceivingStorageLoc,
  _Ir_StorageLocation.StorageLocationName AS IssuingOrReceivingStLocName,
  IssuingOrReceivingStockType,
  _InventoryIrStockType._Text[1: Language=$parameters.P_Language].InventoryStockTypeName AS IssuingOrReceivStockTypeName,
  DebitCreditCode,
  EntryUnit,
  QuantityInEntryUnit,
  MaterialBaseUnit,
  GoodsReceiptIsNonValuated,
  cast(HasMultipleAccountAssignment as mmim_xmacc_3) AS HasMultipleAccountAssignment,
  CostCenter,
  _CostCenter._Text[1:Language = $parameters.P_Language].CostCenterName AS CostCenterName,
  MasterFixedAsset,
  _FixedAsset.FixedAssetDescription AS FixedAssetDescription,
  GLAccount,
  WhseGoodsMovementDocument,
  Warehouse,
  _WarehouseVH._Text[1:Language = $session.system_language].WarehouseName AS WarehouseName,
  _GLAccount[1:ChartOfAccounts = ChartOfAccounts]._Text[1:Language = $session.system_language].GLAccountLongName AS GLAccountLongName,
  _StorLocAuth.xblgo AS IsStorLocAuthznCheckActive,
  _StorLocAuth_Tr.xblgo AS IsIssgOrRcvgStorLocAuthChkActv,
  _ExistenceCheckOnMaterialDoc.MatlDocHasNoSerializedMaterial AS UICT_MatlDocHasNoSerialNumbers,
  cast( _ExistenceCheckOnMaterialDoc.MatDocHasNoSrlNmbrForPInv as boolean preserving type ) AS UICT_MatDocHasNoSrlNmbrForPInv,
  StockSegment,
  ProductSeasonYear,
  ProductSeason,
  ProductCollection,
  ProductTheme,
  _Material.CrossPlantConfigurableProduct AS CrossPlantConfigurableProduct,
  ProductCharacteristic1,
  ProductCharacteristic2,
  ProductCharacteristic3,
  _CrossPlantConfigurableProduct._Text[1: Language=$session.system_language].MaterialName AS MaterialText,
  _CharValTexts1[1: Language=$parameters.P_Language].RetailCharacteristicValueDesc AS ProductCharacteristic1Desc,
  _CharValTexts2[1: Language=$parameters.P_Language].RetailCharacteristicValueDesc AS ProductCharacteristic2Desc,
  _CharValTexts3[1: Language=$parameters.P_Language].RetailCharacteristicValueDesc AS ProductCharacteristic3Desc,
  _Season._SeasonText[1: Language=$parameters.P_Language].ProductSeasonText AS SeasonDescription,
  _Collection._SeasonText[1: Language=$parameters.P_Language].ProductSeasonText AS CollectionDescription,
  _Theme._SeasonText[1: Language=$parameters.P_Language].ProductSeasonText AS ThemeDescription
FROM F_Mmim_Findmatdoch AS _Mmim_Findmatdoch
LEFT OUTER JOIN E_MaterialDocumentItem AS _ProcessExtension ON MaterialDocument = _ProcessExtension.MaterialDocument AND MaterialDocumentYear = _ProcessExtension.MaterialDocumentYear AND MaterialDocumentItem = _ProcessExtension.MaterialDocumentItem AND _ProcessExtension.MaterialDocumentRecordType = 'MDOC'  -- association [1..1]
LEFT OUTER JOIN E_MaterialDocumentItem_2 AS _ProcessExtensionMatdoc ON MaterialDocument = _ProcessExtensionMatdoc.MaterialDocument AND MaterialDocumentYear = _ProcessExtensionMatdoc.MaterialDocumentYear AND MaterialDocumentItem = _ProcessExtensionMatdoc.MaterialDocumentItem AND _ProcessExtensionMatdoc.MaterialDocumentRecordType = 'MDOC'  -- association [1..1]
LEFT OUTER JOIN F_Mmim_Matdoc_Item AS _Mdoc_Item ON MaterialDocument = _Mdoc_Item.MaterialDocument AND MaterialDocumentYear = _Mdoc_Item.MaterialDocumentYear  -- association [0..*]
LEFT OUTER JOIN F_Mmim_Mdoc_Revstat AS _Reversed_Status ON MaterialDocument = _Reversed_Status.MaterialDocument AND MaterialDocumentYear = _Reversed_Status.MaterialDocumentYear  -- association [0..1]
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [1..1]
LEFT OUTER JOIN I_Product AS _Product ON Material = _Product.Product  -- association [1..1]
LEFT OUTER JOIN I_ProductPlant AS _ProductPlant ON Material = _ProductPlant.Product AND Plant = _ProductPlant.Plant  -- association [1..1]
LEFT OUTER JOIN I_ProductPlant AS _ProductIsRecPlant ON Material = _ProductIsRecPlant.Product AND IssuingOrReceivingPlant = _ProductIsRecPlant.Plant  -- association [1..1]
LEFT OUTER JOIN I_Batch AS _Batch ON Material = _Batch.Material AND Plant = _Batch.Plant AND Batch = _Batch.Batch  -- association [1..1]
LEFT OUTER JOIN F_Mmim_Matgrp_Vh2 AS _F_Mmim_Matgrp_Vh2 ON MaterialGroup = _F_Mmim_Matgrp_Vh2.MaterialGroup  -- association [1..1]
LEFT OUTER JOIN F_Mmim_Mattyp_Vh2 AS _F_Mmim_Mattyp_Vh2 ON MaterialType = _F_Mmim_Mattyp_Vh2.MaterialType  -- association [1..1]
LEFT OUTER JOIN F_Mmim_T001l_Auth AS _StorLocAuth ON Plant = _StorLocAuth.werks AND StorageLocation = _StorLocAuth.lgort AND _StorLocAuth.xblgo = 'X'  -- association [0..1]
LEFT OUTER JOIN F_Mmim_T001l_Auth AS _StorLocAuth_Tr ON IssuingOrReceivingPlant = _StorLocAuth_Tr.werks AND IssuingOrReceivingStorageLoc = _StorLocAuth_Tr.lgort AND _StorLocAuth_Tr.xblgo = 'X'  -- association [0..1]
LEFT OUTER JOIN C_MatlDocOvwStockSegmentVH AS _StockSeg_Vh2 ON StockSegment = _StockSeg_Vh2.StockSegment  -- association [0..1]
LEFT OUTER JOIN C_MatlDocOvwSeasonVH AS _Season_Vh2 ON ProductSeasonYear = _Season_Vh2.ProductSeasonYear AND ProductSeason = _Season_Vh2.ProductSeason AND ProductCollection = _Season_Vh2.ProductCollection AND ProductTheme = _Season_Vh2.ProductTheme  -- association [0..1]
LEFT OUTER JOIN C_MatlDocOvwCharValueVH AS _CharValue_VH ON ProductCharacteristic1 = _CharValue_VH.ProductCharacteristic1 AND ProductCharacteristic2 = _CharValue_VH.ProductCharacteristic2 AND ProductCharacteristic3 = _CharValue_VH.ProductCharacteristic3  -- association [0..1]
LEFT OUTER JOIN C_MatlDocOvwGenericProdVH AS _CrossPlantConfProd_VH ON CrossPlantConfigurableProduct = _CrossPlantConfProd_VH.CrossPlantConfigurableProduct  -- association [0..1]
LEFT OUTER JOIN I_EWM_WarehouseNumber AS _WarehouseVH ON Warehouse = _WarehouseVH.Warehouse  -- association [0..1]
LEFT OUTER JOIN I_MaterialDocumentOvwSerialNo AS _SerialNo ON MaterialDocument = _SerialNo.MaterialDocument AND MaterialDocumentYear = _SerialNo.MaterialDocumentYear  -- association [0..*]
LEFT OUTER JOIN I_MatlDocOvwSrlNmbrPhysInvtry AS _SerialNoPI ON MaterialDocument = _SerialNoPI.MaterialDocument AND MaterialDocumentYear = _SerialNoPI.MaterialDocumentYear  -- association [0..*]
LEFT OUTER JOIN I_ExistenceCheckOnMaterialDoc AS _ExistenceCheckOnMaterialDoc ON MaterialDocument = _ExistenceCheckOnMaterialDoc.MaterialDocument AND MaterialDocumentYear = _ExistenceCheckOnMaterialDoc.MaterialDocumentYear  -- association [0..1]
;