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.
-- 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,
  cast (case when Material = '' then _Mmim_Findmatdoch._PurchasingDocumentItem.PurchasingDocumentItemText else _Material._Text[1: Language=$parameters.P_Language].MaterialName end as maktx) as MaterialName AS MaterialNameendasmaktxasMaterialName,
  cast(_Mmim_Findmatdoch._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,
  _Mmim_Findmatdoch._Plant.PlantName AS PlantName,
  Batch,
  InventoryValuationType,
  StorageLocation,
  IsAutomaticallyCreated AS IsAutoCreatedTransPost,
  cast(IsAutomaticallyCreated as mmmim_auto_created_ind) AS IsAutomaticallyCreated,
  cast(_Mmim_Findmatdoch._I_AutoCrtedIdfrVH.MatlDocLineItmAutoCrtedIdfrTxt as mmim_matdoc_aut_crted_ind_text) AS MatlDocLineItmAutoCrtedIdfrTxt,
  _Mmim_Findmatdoch._StorageLocation.StorageLocationName AS StorageLocationName,
  Supplier,
  cast(_Mmim_Findmatdoch._Supplier.SupplierName as mmim_supplier_name) AS SupplierName,
  SalesOrder,
  SalesOrderItem,
  SpecialStockIdfgSalesOrder,
  SpecialStockIdfgSalesOrderItem,
  SalesOrderScheduleLine,
  WBSElement,
  WBSElementInternalID,
  _Mmim_Findmatdoch._WBSElement.WBSDescription AS WBSDescription,
  SpecialStockIdfgWBSElement,
  SpclStockIdfgWBSElementIntID,
  _Mmim_Findmatdoch._SpecialStockIdfgWBSElement.WBSDescription AS SpclStkIdfgWBSElmntDescription,
  Customer,
  cast(_Mmim_Findmatdoch._Customer.CustomerName as mmim_customer_name) 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,
  cast(_Mmim_Findmatdoch._F3_Mmim_ReasonCT.GoodsMovementReasonName as mmim_reason_code_text) 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,
  cast(_Mmim_Findmatdoch._CreatedByUser.UserDescription as im_pi_created_by_user_desc) AS CreatedByUserDescription,
  AccountingDocumentType,
  cast(_Mmim_Findmatdoch._F_Mmim_Blart.AccountingDocumentTypeName as mmim_acc_doc_type_name) AS AccountingDocumentTypeName,
  InventoryTransactionType,
  _InventoryTransactionTypeT[1: Language=$parameters.P_Language].InventoryTransactionTypeText AS InventoryTransactionTypeText,
  DocumentReferenceId,
  BillOfLading,
  MaterialDocumentHeaderText,
  CompanyCode,
  PurchaseOrder,
  PurchaseOrderItem,
  DeliveryDocument,
  DeliveryDocumentItem,
  OrderID,
  MaintOrderRoutingNumber,
  Reservation,
  ReservationItem,
  MultiAcctAssgmtOriglMatlDocItm,
  UnloadingPointName,
  GoodsRecipientName,
  IssuingOrReceivingMaterial,
  cast(_Ir_Material._Text[1: Language=$parameters.P_Language].MaterialName as mmim_transfer_material_name) AS IssuingOrReceivingMaterialName,
  IssuingOrReceivingPlant,
  cast(_Mmim_Findmatdoch._Ir_Plant.PlantName as mmim_transfer_plant_name) AS IssuingOrReceivingPlantName,
  IssuingOrReceivingStorageLoc,
  cast(_Mmim_Findmatdoch._Ir_StorageLocation.StorageLocationName as mmim_transfer_sloc_name) AS IssuingOrReceivingStLocName,
  IssuingOrReceivingStockType,
  cast(_InventoryIrStockType._Text[1: Language=$parameters.P_Language].InventoryStockTypeName as mmim_transfer_stock_type_name) AS IssuingOrReceivStockTypeName,
  IssgOrRcvgValuationType,
  IssgOrRcvgSpclStkIdfgSupplier,
  cast(_IRSpclStkIdfgSupplier.SupplierName as mmim_ir_sid_splr_name) AS IssgOrRcvgSpclStkIdfgSuplrName,
  IssgOrRcvgSalesOrder,
  IssgOrRcvgSalesOrderItem,
  IssgOrRcvgWBSElement,
  cast(_IssgOrRcvgWBSElement.WBSDescription as mmim_ir_wbs_element_descr) AS IssgOrRcvgWBSDescription,
  IssgOrRcvgStkIdfgSpclStkType,
  cast(_IRStkIdfgSpclStkType._Text[1: Language=$parameters.P_Language].InventorySpecialStockTypeName as mmim_ir_sid_spcl_stk_type_name) AS IssgOrRcvgSpclStkTypeName,
  IssgOrRcvgSpclStkIdfgCustomer,
  cast(_IRSpclStkIdfgCustomer.CustomerName as mmim_ir_spcl_stk_idfg_cust_nam) AS IssgOrRcvgSpclStkIdfgCustName,
  DebitCreditCode,
  _DebitCreditCode._Text[1: Language=$parameters.P_Language].DebitCreditCodeName AS DebitCreditCodeName,
  EntryUnit,
  QuantityInEntryUnit,
  MaterialBaseUnit,
  MatlStkChangeQtyInBaseUnit,
  OrderPriceUnit,
  QtyInPurchaseOrderPriceUnit,
  OrderQuantityUnit,
  GoodsReceiptQtyInOrderUnit,
  CompanyCodeCurrency,
  GoodsMovementStkAmtInCCCrcy,
  GdsMvtExtAmtInCoCodeCrcy,
  EnteredSlsAmtInCoCodeCrcy,
  GoodsReceiptIsNonValuated,
  cast(HasMultipleAccountAssignment as mmim_xmacc_3) AS HasMultipleAccountAssignment,
  CostCenter,
  _CostCenter._Text[1:Language = $parameters.P_Language].CostCenterName AS CostCenterName,
  MasterFixedAsset,
  cast(_Mmim_Findmatdoch._FixedAsset.FixedAssetDescription as mmim_fixed_asset_description) AS FixedAssetDescription,
  GLAccount,
  WhseGoodsMovementDocument,
  Warehouse,
  cast(_WarehouseVH._Text[1:Language = $session.system_language].WarehouseName as mmim_warehouse_name) AS WarehouseName,
  _GLAccount[1:ChartOfAccounts = ChartOfAccounts]._Text[1:Language = $session.system_language].GLAccountLongName AS GLAccountLongName,
  _StorLocAuth.xblgo AS IsStorLocAuthznCheckActive,
  _StorLocAuth_Tr.xblgo AS IsIssgOrRcvgStorLocAuthChkActv,
  case when _ExistenceCheckOnMaterialDoc.MatlDocHasMatlDocSrlNmbrs = 'X' then '' else 'X' end AS MatlDocSrlNmbrsFacetIsHidden,
  case when _ExistenceCheckOnMaterialDoc.MatlDocHasPhysInvtrySrlNmbrs ='X' then '' else 'X' end AS PhysInvtrySrlNmbrFacetIsHidden,
  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_ProductPlantBasic AS _IssgOrRcvgProductPlantBasic ON IssuingOrReceivingMaterial = _IssgOrRcvgProductPlantBasic.Product AND IssuingOrReceivingPlant = _IssgOrRcvgProductPlantBasic.Plant  -- association [0..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_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_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 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]
LEFT OUTER JOIN I_UserContactCard AS _CreatedByUserContactCard ON CreatedByUser = _CreatedByUserContactCard.ContactCardID  -- association [0..1]
;