I_MaterialDocumentRecord

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_MaterialDocumentRecord.
-- 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.

CREATE VIEW I_MaterialDocumentRecord AS
SELECT
  cast(key1 as nsdm_key1 preserving type ) AS MaterialDocumentKey1,
  cast(key2 as nsdm_key2 preserving type ) AS MaterialDocumentKey2,
  cast(key3 as nsdm_key3 preserving type ) AS MaterialDocumentKey3,
  cast(key4 as nsdm_key4 preserving type ) AS MaterialDocumentKey4,
  cast(key5 as nsdm_key5 preserving type ) AS MaterialDocumentKey5,
  cast(key6 as nsdm_key6 preserving type ) AS MaterialDocumentKey6,
  cast(mjahr as nsdm_mjahr preserving type) AS MaterialDocumentYear,
  mblnr AS MaterialDocument,
  cast(zeile as nsdm_mblpo preserving type) AS MaterialDocumentItem,
  matbf AS StockIdentifyingMaterial,
  werks AS Plant,
  lgort_sid AS StockIdfgStorageLocation,
  charg_sid AS StockIdentifyingBatch,
  lifnr_sid AS SpecialStockIdfgSupplier,
  mat_kdauf AS SpecialStockIdfgSalesOrder,
  mat_kdpos AS SpecialStockIdfgSalesOrderItem,
  mat_pspnr AS SpecialStockIdfgWBSElement,
  kunnr_sid AS SpecialStockIdfgCustomer,
  cast(sobkz as nsdm_spcl_stock_type preserving type) AS InventorySpecialStockType,
  lbbsa_sid AS InventoryStockType,
  cast(disub_owner_sid as nsdm_disub_owner_sid preserving type) AS SpecialStockIdfgStockOwner,
  resourcename_sid AS ResourceID,
  ummab_cid AS IssgOrRcvgStkIdfgMaterial,
  cast(umwrk_cid as nsdm_plant_cid preserving type) AS IssgOrRcvgStkIdfgPlant,
  cast(lgort_cid as nsdm_lgort_cid preserving type) AS IssgOrRcvgStkIdfgStorLoc,
  cast(charg_cid as nsdm_batch_cid preserving type) AS IssgOrRcvgStkIdfgBatch,
  cast(lifnr_cid as nsdm_lifnr_cid preserving type) AS IssgOrRcvgSpclStkIdfgSupplier,
  mat_kdauf_cid AS IssgOrRcvgSalesOrder,
  mat_kdpos_cid AS IssgOrRcvgSalesOrderItem,
  mat_pspnr_cid AS IssgOrRcvgWBSElement,
  cast(kunnr_cid as nsdm_kunnr_cid preserving type) AS IssgOrRcvgSpclStkIdfgCustomer,
  cast(umsok_cid as nsdm_sobkz_cid preserving type) AS IssgOrRcvgStkIdfgSpclStkType,
  cast(lbbsa_cid as nsdm_lbbsa_cid preserving type) AS IssuingOrReceivingStockType,
  cast(disub_owner_cid as nsdm_disub_owner_cid preserving type) AS IssgOrRcvgSpclStkIdfgStkOwner,
  resourcename_cid AS IssgOrRcvgResourceID,
  kzzug AS GoodsReceiptType
FROM matdoc
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [0..1]
LEFT OUTER JOIN I_Material AS _StockIdentifyingMaterial ON StockIdentifyingMaterial = _StockIdentifyingMaterial.Material  -- association [0..1]
LEFT OUTER JOIN I_Material AS _IssgOrRcvgMaterial ON IssgOrRcvgMaterial = _IssgOrRcvgMaterial.Material  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _IssuingOrReceivingPlant ON IssuingOrReceivingPlant = _IssuingOrReceivingPlant.Plant  -- association [0..1]
LEFT OUTER JOIN I_StorageLocation AS _StorageLocation ON StorageLocation = _StorageLocation.StorageLocation AND Plant = _StorageLocation.Plant  -- association [0..1]
LEFT OUTER JOIN I_StorageLocation AS _IssuingOrReceivingStorageLoc ON IssuingOrReceivingStorageLoc = _IssuingOrReceivingStorageLoc.StorageLocation AND IssuingOrReceivingPlant = _IssuingOrReceivingStorageLoc.Plant  -- association [0..1]
LEFT OUTER JOIN I_StorageLocation AS _StockIdfgStorageLocation ON StockIdfgStorageLocation = _StockIdfgStorageLocation.StorageLocation AND Plant = _StockIdfgStorageLocation.Plant  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _SpecialStockIdfgSupplier ON SpecialStockIdfgSupplier = _SpecialStockIdfgSupplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _SpecialStockIdfgCustomer ON SpecialStockIdfgCustomer = _SpecialStockIdfgCustomer.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_Supplier AS _BPStockOwner ON StockOwner = _BPStockOwner.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _SpecialStockIdfgStockOwner ON SpecialStockIdfgStockOwner = _SpecialStockIdfgStockOwner.Supplier  -- association [0..1]
LEFT OUTER JOIN I_InventorySpecialStockType AS _InventorySpecialStockType ON InventorySpecialStockType = _InventorySpecialStockType.InventorySpecialStockType  -- association [0..1]
LEFT OUTER JOIN I_InventorySpecialStockType AS _IssgOrRcvgSpclStockInd ON IssgOrRcvgSpclStockInd = _IssgOrRcvgSpclStockInd.InventorySpecialStockType  -- association [0..1]
LEFT OUTER JOIN I_InventoryStockType AS _InventoryStockType ON InventoryStockType = _InventoryStockType.InventoryStockType  -- association [0..1]
LEFT OUTER JOIN I_InventoryStockType AS _IssuingOrReceivingStockType ON IssuingOrReceivingStockType = _IssuingOrReceivingStockType.InventoryStockType  -- association [0..1]
LEFT OUTER JOIN I_InventoryValuationType AS _InventoryValuationType ON InventoryValuationType = _InventoryValuationType.InventoryValuationType  -- association [0..1]
LEFT OUTER JOIN I_GoodsMovementType AS _GoodsMovementType ON GoodsMovementType = _GoodsMovementType.GoodsMovementType  -- association [0..1]
LEFT OUTER JOIN I_PhysInvtryReasonCode AS _GoodsMovementReasonCode ON GoodsMovementType = _GoodsMovementReasonCode.GoodsMovementType AND GoodsMovementReasonCode = _GoodsMovementReasonCode.ReasonForPhysInvtryDifference  -- association [0..1]
LEFT OUTER JOIN I_DebitCreditCode AS _DebitCreditCode ON DebitCreditCode = _DebitCreditCode.DebitCreditCode  -- association [0..1]
LEFT OUTER JOIN I_StockType AS _StockType ON InventoryUsabilityCode = _StockType.StockType  -- association [0..1]
LEFT OUTER JOIN I_StockType_2 AS _StockType_2 ON InventoryUsabilityCode = _StockType_2.StockType  -- association [0..1]
LEFT OUTER JOIN I_InventoryUsabilityCode AS _InventoryUsabilityCode ON InventoryUsabilityCode = _InventoryUsabilityCode.InventoryUsabilityCode  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _MaterialBaseUnit ON MaterialBaseUnit = _MaterialBaseUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _EntryUnit ON EntryUnit = _EntryUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_GLAccount AS _GLAccount ON GLAccount = _GLAccount.GLAccount AND CompanyCode = _GLAccount.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_CostCenter AS _CostCenter ON CostCenter = _CostCenter.CostCenter AND ControllingArea = _CostCenter.ControllingArea AND PostingDate <= _CostCenter.ValidityEndDate AND PostingDate >= _CostCenter.ValidityStartDate  -- association [0..*]
LEFT OUTER JOIN I_ProfitCenter AS _ProfitCenter ON ControllingArea = _ProfitCenter.ControllingArea AND ProfitCenter = _ProfitCenter.ProfitCenter AND PostingDate <= _ProfitCenter.ValidityEndDate AND PostingDate >= _ProfitCenter.ValidityStartDate  -- association [0..*]
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON ServicePerformer = _BusinessPartner.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_Employment AS _Employment ON EmploymentInternalID = _Employment.EmploymentInternalID  -- association [0..1]
LEFT OUTER JOIN I_PersonWorkAgreement_1 AS _PersonWorkAgreement ON PersonWorkAgreement = _PersonWorkAgreement.PersonWorkAgreement  -- association [0..1]
LEFT OUTER JOIN I_AccountAssignmentCategory AS _AccountAssignmentCategory ON AccountAssignmentCategory = _AccountAssignmentCategory.AccountAssignmentCategory  -- association [0..1]
LEFT OUTER JOIN I_WorkItem AS _WorkItem ON WorkItem = _WorkItem.WorkItem  -- association [0..1]
LEFT OUTER JOIN I_MasterFixedAsset AS _MasterFixedAsset ON CompanyCode = _MasterFixedAsset.CompanyCode AND MasterFixedAsset = _MasterFixedAsset.MasterFixedAsset  -- association [0..1]
LEFT OUTER JOIN I_FixedAsset AS _FixedAsset ON CompanyCode = _FixedAsset.CompanyCode AND MasterFixedAsset = _FixedAsset.MasterFixedAsset AND FixedAsset = _FixedAsset.FixedAsset  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_BusinessArea AS _BusinessArea ON BusinessArea = _BusinessArea.BusinessArea  -- association [0..1]
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON ControllingArea = _ControllingArea.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_FunctionalArea AS _FunctionalArea ON FunctionalArea = _FunctionalArea.FunctionalArea  -- association [0..1]
LEFT OUTER JOIN I_ServiceDocumentType AS _ServiceDocumentType ON ServiceDocumentType = _ServiceDocumentType.ServiceDocumentType  -- association [0..1]
LEFT OUTER JOIN I_SalesOrder AS _SalesOrder ON SalesOrder = _SalesOrder.SalesOrder  -- association [0..1]
LEFT OUTER JOIN I_SalesOrder AS _SpecialStockIdfgSalesOrder ON SpecialStockIdfgSalesOrder = _SpecialStockIdfgSalesOrder.SalesOrder  -- association [0..1]
LEFT OUTER JOIN I_SalesOrderItem AS _SalesOrderItem ON SalesOrder = _SalesOrderItem.SalesOrder AND SalesOrderItem = _SalesOrderItem.SalesOrderItem  -- association [0..1]
LEFT OUTER JOIN I_SalesOrderItem AS _SpecialStockIdfgSalesOrderItm ON SpecialStockIdfgSalesOrder = _SpecialStockIdfgSalesOrderItm.SalesOrder AND SpecialStockIdfgSalesOrderItem = _SpecialStockIdfgSalesOrderItm.SalesOrderItem  -- association [0..1]
LEFT OUTER JOIN I_SalesOrderScheduleLine AS _SalesOrderScheduleLine ON SalesOrder = _SalesOrderScheduleLine.SalesOrder AND SalesOrderItem = _SalesOrderScheduleLine.SalesOrderItem AND SalesOrderScheduleLine = _SalesOrderScheduleLine.ScheduleLine  -- association [0..1]
LEFT OUTER JOIN I_WBSElementByInternalKey AS _SpecialStockIdfgWBSElement ON SpecialStockIdfgWBSElement = _SpecialStockIdfgWBSElement.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementByInternalKey AS _WBSElement ON WBSElementInternalID = _WBSElement.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _SpclStkIdfgWBSElmntBasicData ON SpecialStockIdfgWBSElement = _SpclStkIdfgWBSElmntBasicData.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElementBasicData ON WBSElementInternalID = _WBSElementBasicData.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_PurchaseOrder AS _PurchaseOrder ON PurchaseOrder = _PurchaseOrder.PurchaseOrder  -- association [0..1]
LEFT OUTER JOIN I_PurchaseOrderItem AS _PurchaseOrderItem ON PurchaseOrder = _PurchaseOrderItem.PurchaseOrder AND PurchaseOrderItem = _PurchaseOrderItem.PurchaseOrderItem  -- association [0..1]
LEFT OUTER JOIN I_ProjectNetwork AS _ProjectNetwork ON ProjectNetwork = _ProjectNetwork.ProjectNetwork  -- association [0..1]
LEFT OUTER JOIN I_MfgOrder AS _MfgOrder ON ManufacturingOrder = _MfgOrder.ManufacturingOrder  -- association [0..1]
LEFT OUTER JOIN I_MfgOrderItem AS _MfgOrderItem ON ManufacturingOrder = _MfgOrderItem.ManufacturingOrder AND ManufacturingOrderItem = _MfgOrderItem.ManufacturingOrderItem  -- association [0..1]
LEFT OUTER JOIN I_ManufacturingOrder AS _ManufacturingOrder ON ManufacturingOrder = _ManufacturingOrder.ManufacturingOrder  -- association [0..1]
LEFT OUTER JOIN I_ManufacturingOrderItem AS _ManufacturingOrderItem ON ManufacturingOrder = _ManufacturingOrderItem.ManufacturingOrder AND ManufacturingOrderItem = _ManufacturingOrderItem.ManufacturingOrderItem  -- association [0..1]
LEFT OUTER JOIN I_LogisticsOrder AS _LogisticsOrder ON OrderID = _LogisticsOrder.OrderID  -- association [0..1]
LEFT OUTER JOIN I_DeliveryDocument AS _DeliveryDocument ON DeliveryDocument = _DeliveryDocument.DeliveryDocument  -- association [0..1]
LEFT OUTER JOIN I_DeliveryDocumentItem AS _DeliveryDocumentItem ON DeliveryDocument = _DeliveryDocumentItem.DeliveryDocument AND DeliveryDocumentItem = _DeliveryDocumentItem.DeliveryDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_DeliveryDocument AS _DeliveryInMatlDocumentHeader ON DeliveryInMatlDocumentHeader = _DeliveryInMatlDocumentHeader.DeliveryDocument  -- association [0..1]
LEFT OUTER JOIN I_User AS _User ON CreatedByUser = _User.UserID  -- association [0..1]
LEFT OUTER JOIN I_AccountingDocumentType AS _AccountingDocumentType ON AccountingDocumentType = _AccountingDocumentType.AccountingDocumentType  -- association [0..1]
LEFT OUTER JOIN I_InventoryTransactionType AS _InventoryTransactionType ON InventoryTransactionType = _InventoryTransactionType.InventoryTransactionType AND _InventoryTransactionType.IsMaterialDocumentRelevant = 'X'  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _Currency ON CompanyCodeCurrency = _Currency.Currency  -- association [0..1]
LEFT OUTER JOIN I_GoodsMvtTypeBySpclStkIndT AS _GoodsMvtTypeBySpclStkIndT ON GoodsMovementType = _GoodsMvtTypeBySpclStkIndT.GoodsMovementType AND InventorySpecialStockType = _GoodsMvtTypeBySpclStkIndT.InventorySpecialStockType AND GoodsMovementRefDocType = _GoodsMvtTypeBySpclStkIndT.GoodsMovementRefDocType AND GoodsReceiptType = _GoodsMvtTypeBySpclStkIndT.GoodsReceiptType AND ConsumptionPosting = _GoodsMvtTypeBySpclStkIndT.ConsumptionPosting  -- association [0..*]
LEFT OUTER JOIN I_ResourceBasic AS _ResourceBasic ON ResourceID = _ResourceBasic.ResourceID  -- association [0..*]
LEFT OUTER JOIN I_ResourceBasic AS _IssgOrRcvgResourceBasic ON IssgOrRcvgResourceID = _IssgOrRcvgResourceBasic.ResourceID  -- association [0..*]
;