F_Mmim_Matdoc_Item

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_Matdoc_Item.
-- 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: FMMIMATDOCITEM
-- Parameters: P_Language : sylangu

CREATE VIEW F_Mmim_Matdoc_Item AS
SELECT
  mblnr AS MaterialDocument,
  mjahr AS MaterialDocumentYear,
  zeile AS MaterialDocumentItem,
  cancelled AS IsCancelled,
  ltrim(concat_with_space(ltrim(concat_with_space(mblnr, mjahr, 1), '0'), zeile, 1), '0' ) AS DocumentTitle,
  source_matnr AS Material,
  case when source_matnr = '' then _PurchasingDocumentItem.PurchasingDocumentItemText else _Material._Text[1: Language=$parameters.P_Language].MaterialName end as MaterialName AS MaterialNameendasMaterialName,
  _Material._Text[1: Language=$parameters.P_Language].MaterialName AS MaterialNameSearch,
  cast(_PurchasingDocumentItem.PurchasingDocumentItemText as mmim_pur_doc_item_txt) AS PurchasingDocumentItemText,
  bwart AS GoodsmovementType,
  _GoodsMvtTypeBySpclStkIndT[1: Language=$parameters.P_Language].GoodsMovementTypeName AS GoodsmovementTypeName,
  grund AS GoodsMovementReasonCode,
  resourcename_sid AS ResourceId,
  resourcename_cid AS IssgOrRcvgResourceID,
  charg AS Batch,
  lifnr AS Supplier,
  kdauf AS SalesOrder,
  kdpos AS SalesOrderItem,
  kunnr AS Customer,
  lbbsa_sid AS InventoryStockType,
  _InventoryStockType._Text[1: Language=$parameters.P_Language].InventoryStockTypeName AS InventoryStockTypeName,
  sobkz AS InventorySpecialStockType,
  _InventorySpecialStockType._Text[1: Language=$parameters.P_Language].InventorySpecialStockTypeName AS InventorySpecialStockTypeName,
  bwtar AS InventoryValuationType,
  aufnr AS OrderID,
  ps_psp_pnr AS WBSElementInternalID,
  case when posid <> '00000000' and xmacc <> '' then '*' else cast ( _WBSElementBasicData.WBSElement as ps_posid) end as WBSElement AS WBSElementasps_posidendasWBSElement,
  cast(work_item_id as mmim_work_item) AS WorkItem,
  pernr AS PersonnelNumber,
  sgtxt AS DocumentItemText,
  knttp_gr AS AcctAssignmentCategory,
  _AcctAssignmentCategoryText[1:Language = $parameters.P_Language].AcctAssignmentCategoryName AS AcctAssignmentCategoryName,
  cast(vfdat as mmim_shelf_life_exp_date) AS ShelfLifeExpirationDate,
  cast(hsdat as mmim_production_date) AS ManufactureDate,
  weunb AS GoodsReceiptIsNonValuated,
  cast(xmacc as mmim_xmacc_3) AS HasMultipleAccountAssignment,
  cast(ebeln as mmim_purg_doc) AS PurchaseOrder,
  ebelp AS PurchaseOrderItem,
  vbeln_im AS DeliveryDocument,
  vbelp_im AS DeliveryDocumentItem,
  ummat AS IssuingOrReceivingMaterial,
  _Ir_Material._Text[1: Language=$parameters.P_Language].MaterialName AS IssuingOrReceivingMatName,
  umwrk AS IssuingOrReceivingPlant,
  umlgo AS IssuingOrReceivingStorageLoc,
  umcha AS IssgOrRcvgBatch,
  cast(umbar as mmim_rcv_val_type) AS IssgOrRcvgValuationType,
  lbbsa_cid AS IssuingOrReceivingStockType,
  _InventoryIrStockType._Text[1: Language=$parameters.P_Language].InventoryStockTypeName AS IssuingOrReceivStockTypeName,
  shkzg AS DebitCreditCode,
  erfme AS EntryUnit,
  erfmg AS QuantityInEntryUnit,
  line_id AS LineId,
  parent_id AS ParentId,
  weanz AS NumberOfGrSlips,
  nroflabels AS NumberOfLabels,
  kzbew AS GoodsMovementRefDocType,
  kzzug AS GoodsReceiptType,
  kzvbr AS ConsumptionPosting,
  cast(_SerialNumExist.MatDocHasNoSrlNmbrForPInv as boolean preserving type ) AS UICT_MatDocHasNoSrlNmbrForPInv,
  StockSegment,
  ProductSeasonYear,
  ProductSeason,
  ProductCollection,
  ProductTheme,
  F_Mmim_Matdoc_Item_H2._Material.CrossPlantConfigurableProduct AS CrossPlantConfigurableProduct,
  ProductCharacteristic1,
  ProductCharacteristic2,
  ProductCharacteristic3,
  ewm_lgnum AS Warehouse,
  _Warehouse._Text[1:Language = $session.system_language].WarehouseName AS WarehouseName,
  ewm_gmdoc AS WhseGoodsMovementDocument,
  _CharValTexts1[1: Language=$parameters.P_Language].RetailCharacteristicValueDesc AS ProductCharacteristic1Desc,
  _CharValTexts2[1: Language=$parameters.P_Language].RetailCharacteristicValueDesc AS ProductCharacteristic2Desc,
  _CharValTexts2[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,
  _CrossPlantConfigurableProduct._Text[1: Language=$parameters.P_Language].MaterialName AS CrossPlantConfProductName,
  F_Mmim_Matdoc_Item_H2.werks AS Plant,
  F_Mmim_Matdoc_Item_H2.lgort AS StorageLocation,
  _Customer.CustomerName AS CustomerName,
  _Customer.AuthorizationGroup AS CustomerBasicAuthorizationGrp,
  _F3_Mmim_ReasonCT.GoodsMovementReasonName AS GoodsMovementReasonName,
  _F_Mmim_T156t.btext_l AS GoodsMovementTypeLongName,
  _Ir_Plant.PlantName AS IssuingOrReceivingPlantName,
  _Ir_StorageLocation.StorageLocationName AS IssuingOrReceivingStLocName,
  _Plant.PlantName AS PlantName,
  _SerialNumExist.MatlDocHasNoSerializedMaterial AS UICT_MatlDocHasNoSerialNumbers,
  _StorageLocation.StorageLocationName AS StorageLocationName,
  _StorLocAuth.xblgo AS IsStorLocAuthznCheckActive,
  _StorLocAuth_Tr.xblgo AS IsIssgOrRcvgStorLocAuthChkActv,
  _Supplier.SupplierName AS SupplierName,
  _Supplier.AuthorizationGroup AS SupplierBasicAuthorizationGrp,
  _WBSElementBasicData.WBSDescription AS WBSDescription
FROM F_Mmim_Matdoc_Item_H2
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_Account AS _Matdoc_Item_Account ON MaterialDocument = _Matdoc_Item_Account.MaterialDocument AND MaterialDocumentYear = _Matdoc_Item_Account.MaterialDocumentYear AND ( ( MaterialDocumentItem = _Matdoc_Item_Account.MaterialDocumentItem AND HasMultipleAccountAssignment = '' ) OR ( HasMultipleAccountAssignment <> '' AND MaterialDocumentItem = _Matdoc_Item_Account.MultiAcctAssgmtOriglMatlDocItm ) )  -- association [0..*]
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 I_Material AS _Material ON Material = _Material.Material  -- association [1..1]
LEFT OUTER JOIN I_Material AS _Ir_Material ON IssuingOrReceivingMaterial = _Ir_Material.Material  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [1..1]
LEFT OUTER JOIN I_Plant AS _Ir_Plant ON IssuingOrReceivingPlant = _Ir_Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_StorageLocation AS _Ir_StorageLocation ON IssuingOrReceivingPlant = _Ir_StorageLocation.Plant AND IssuingOrReceivingStorageLoc = _Ir_StorageLocation.StorageLocation  -- association [0..1]
LEFT OUTER JOIN I_StorageLocation AS _StorageLocation ON Plant = _StorageLocation.Plant AND StorageLocation = _StorageLocation.StorageLocation  -- association [0..1]
LEFT OUTER JOIN F3_Mmim_ReasonCT AS _F3_Mmim_ReasonCT ON GoodsmovementType = _F3_Mmim_ReasonCT.GoodsMovementType AND GoodsMovementReasonCode = _F3_Mmim_ReasonCT.GoodsMovementReasonCode  -- association [1..1]
LEFT OUTER JOIN I_InventoryStockType AS _InventoryStockType ON InventoryStockType = _InventoryStockType.InventoryStockType  -- association [1..1]
LEFT OUTER JOIN I_InventoryStockType AS _InventoryIrStockType ON IssuingOrReceivingStockType = _InventoryIrStockType.InventoryStockType  -- association [1..1]
LEFT OUTER JOIN I_InventorySpecialStockType AS _InventorySpecialStockType ON InventorySpecialStockType = _InventorySpecialStockType.InventorySpecialStockType  -- association [0..1]
LEFT OUTER JOIN F3_Mmim_Supplier_Vh AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN F3_Mmim_Customer_Vh AS _Customer ON Customer = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN I_SupplierCompanyByPlant AS _SupplierCompanyByPlant ON Supplier = _SupplierCompanyByPlant.Supplier AND Plant = _SupplierCompanyByPlant.Plant  -- association [0..1]
LEFT OUTER JOIN I_CustomerCompanyByPlant AS _CustomerCompanyByPlant ON Customer = _CustomerCompanyByPlant.Customer AND Plant = _CustomerCompanyByPlant.Plant  -- association [0..1]
LEFT OUTER JOIN I_AcctAssignmentCategoryText AS _AcctAssignmentCategoryText ON AcctAssignmentCategory = _AcctAssignmentCategoryText.AccountAssignmentCategory  -- association [0..*]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElementBasicData ON WBSElementInternalID = _WBSElementBasicData.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN F_Mmm_Docflow AS _F_Mmm_Docflow ON MaterialDocument = _F_Mmm_Docflow.MaterialDocument AND MaterialDocumentYear = _F_Mmm_Docflow.MaterialDocumentYear AND MaterialDocumentItem = _F_Mmm_Docflow.MaterialDocumentItem  -- association [0..*]
LEFT OUTER JOIN I_EWM_WarehouseNumber AS _Warehouse ON Warehouse = _Warehouse.Warehouse  -- association [0..1]
LEFT OUTER JOIN I_ProductPlantBasic AS _ProductPlantBasic ON Material = _ProductPlantBasic.Product AND Plant = _ProductPlantBasic.Plant  -- association [1]
LEFT OUTER JOIN I_MatDocOvwItmSerialNumber AS _SerialNo ON MaterialDocument = _SerialNo.MaterialDocument AND MaterialDocumentYear = _SerialNo.MaterialDocumentYear AND MaterialDocumentItem = _SerialNo.MaterialDocumentItem AND Material = _SerialNo.Material  -- association [0..*]
LEFT OUTER JOIN I_MatlDocOvwItmSrlNmbrPInv AS _SerialNoPI ON MaterialDocument = _SerialNoPI.MaterialDocument AND MaterialDocumentYear = _SerialNoPI.MaterialDocumentYear AND MaterialDocumentItem = _SerialNoPI.MaterialDocumentItem AND Material = _SerialNoPI.Material  -- association [0..*]
LEFT OUTER JOIN I_ExistenceCheckOnMatlDocItem AS _SerialNumExist ON MaterialDocument = _SerialNumExist.MaterialDocument AND MaterialDocumentYear = _SerialNumExist.MaterialDocumentYear AND MaterialDocumentItem = _SerialNumExist.MaterialDocumentItem  -- association [0..1]
;