I_MATERIALDOCUMENTRECORD

@EndUserText.label: 'Basis view for MATDOC table'
@AccessControl: {
                  authorizationCheck: #CHECK,
                  personalData.blocking: #BLOCKED_DATA_EXCLUDED
                }
@ObjectModel: {
                usageType: {
                             sizeCategory: #XXL,
                             serviceQuality: #A,
                             dataClass:#TRANSACTIONAL
                           }
              }
@VDM: {
        private: false,
        viewType: #BASIC,
        lifecycle.contract.type: #SAP_INTERNAL_API           
        }

define view entity I_MaterialDocumentRecord
  as select from matdoc

  association [0..1] to I_Material                  as _Material                      on  $projection.Material = _Material.Material
  association [0..1] to I_Material                  as _StockIdentifyingMaterial      on  $projection.StockIdentifyingMaterial = _StockIdentifyingMaterial.Material
  association [0..1] to I_Material                  as _IssgOrRcvgMaterial            on  $projection.IssgOrRcvgMaterial = _IssgOrRcvgMaterial.Material
//  association [0..1] to I_Product                   as _Product                       on  $projection.Material = _Product.Product

//  association [0..1] to I_Product                   as _StockIdentifyingProduct       on  $projection.StockIdentifyingMaterial = _StockIdentifyingProduct.Product

//  association [0..1] to I_Product                   as _IssgOrRcvgProduct             on  $projection.IssgOrRcvgMaterial = _IssgOrRcvgProduct.Product


  association [0..1] to I_Plant                     as _Plant                         on  $projection.Plant = _Plant.Plant
  association [0..1] to I_Plant                     as _IssuingOrReceivingPlant       on  $projection.IssuingOrReceivingPlant = _IssuingOrReceivingPlant.Plant
  association [0..1] to I_StorageLocation           as _StorageLocation               on  $projection.StorageLocation = _StorageLocation.StorageLocation
                                                                                      and $projection.Plant           = _StorageLocation.Plant
  association [0..1] to I_StorageLocation           as _IssuingOrReceivingStorageLoc  on  $projection.IssuingOrReceivingStorageLoc = _IssuingOrReceivingStorageLoc.StorageLocation
                                                                                      and $projection.IssuingOrReceivingPlant      = _IssuingOrReceivingStorageLoc.Plant
  association [0..1] to I_StorageLocation           as _StockIdfgStorageLocation      on  $projection.StockIdfgStorageLocation = _StockIdfgStorageLocation.StorageLocation
                                                                                      and $projection.Plant                    = _StockIdfgStorageLocation.Plant

  association [0..1] to I_Supplier                  as _Supplier                      on  $projection.Supplier = _Supplier.Supplier
  association [0..1] to I_Supplier                  as _SpecialStockIdfgSupplier      on  $projection.SpecialStockIdfgSupplier = _SpecialStockIdfgSupplier.Supplier

  association [0..1] to I_Customer                  as _Customer                      on  $projection.Customer = _Customer.Customer
  association [0..1] to I_Customer                  as _SpecialStockIdfgCustomer      on  $projection.SpecialStockIdfgCustomer = _SpecialStockIdfgCustomer.Customer

  association [0..1] to I_SupplierCompanyByPlant    as _SupplierCompanyByPlant      on  $projection.Supplier = _SupplierCompanyByPlant.Supplier
                                                                                    and $projection.Plant = _SupplierCompanyByPlant.Plant
  association [0..1] to I_CustomerCompanyByPlant    as _CustomerCompanyByPlant      on  $projection.Customer = _CustomerCompanyByPlant.Customer
                                                                                    and $projection.Plant    = _CustomerCompanyByPlant.Plant

  association [0..1] to I_Supplier                  as _BPStockOwner                  on  $projection.StockOwner = _BPStockOwner.Supplier
  association [0..1] to I_Supplier                  as _SpecialStockIdfgStockOwner    on  $projection.SpecialStockIdfgStockOwner = _SpecialStockIdfgStockOwner.Supplier

  association [0..1] to I_InventorySpecialStockType as _InventorySpecialStockType     on  $projection.InventorySpecialStockType = _InventorySpecialStockType.InventorySpecialStockType
  association [0..1] to I_InventorySpecialStockType as _IssgOrRcvgSpclStockInd        on  $projection.IssgOrRcvgSpclStockInd = _IssgOrRcvgSpclStockInd.InventorySpecialStockType
  association [0..1] to I_InventoryStockType        as _InventoryStockType            on  $projection.InventoryStockType = _InventoryStockType.InventoryStockType
  association [0..1] to I_InventoryStockType        as _IssuingOrReceivingStockType   on  $projection.IssuingOrReceivingStockType = _IssuingOrReceivingStockType.InventoryStockType
  association [0..1] to I_InventoryValuationType    as _InventoryValuationType        on  $projection.InventoryValuationType = _InventoryValuationType.InventoryValuationType

  association [0..1] to I_GoodsMovementType         as _GoodsMovementType             on  $projection.GoodsMovementType = _GoodsMovementType.GoodsMovementType
  association [0..1] to I_PhysInvtryReasonCode      as _GoodsMovementReasonCode       on  $projection.GoodsMovementType = _GoodsMovementReasonCode.GoodsMovementType
                                                                                      and $projection.GoodsMovementReasonCode = _GoodsMovementReasonCode.ReasonForPhysInvtryDifference

  association [0..1] to I_DebitCreditCode           as _DebitCreditCode               on  $projection.DebitCreditCode = _DebitCreditCode.DebitCreditCode
  -- View I_StockType is deprecated; I_StockType_2 is the successor
  association [0..1] to I_StockType                 as _StockType                     on  $projection.InventoryUsabilityCode = _StockType.StockType
  -- View I_StockType_2 is deprecated; I_InventoryUsabilityCode is the successor
  association [0..1] to I_StockType_2               as _StockType_2                   on  $projection.InventoryUsabilityCode = _StockType_2.StockType
  association [0..1] to I_InventoryUsabilityCode    as _InventoryUsabilityCode        on  $projection.InventoryUsabilityCode = _InventoryUsabilityCode.InventoryUsabilityCode

  association [0..1] to I_UnitOfMeasure             as _MaterialBaseUnit              on  $projection.MaterialBaseUnit = _MaterialBaseUnit.UnitOfMeasure
  association [0..1] to I_UnitOfMeasure             as _EntryUnit                     on  $projection.EntryUnit = _EntryUnit.UnitOfMeasure

  association [0..1] to I_GLAccount                 as _GLAccount                     on  $projection.GLAccount   = _GLAccount.GLAccount
                                                                                      and $projection.CompanyCode = _GLAccount.CompanyCode

  association [0..*] to I_CostCenter                as _CostCenter                    on  $projection.CostCenter      = _CostCenter.CostCenter
                                                                                      and $projection.ControllingArea = _CostCenter.ControllingArea
                                                                                      and $projection.PostingDate    <= _CostCenter.ValidityEndDate
                                                                                      and $projection.PostingDate    >= _CostCenter.ValidityStartDate

  --valid date range not included, multiple entries can be returned
  association [0..*] to I_ProfitCenter              as _ProfitCenter                  on  $projection.ControllingArea = _ProfitCenter.ControllingArea
                                                                                      and $projection.ProfitCenter    = _ProfitCenter.ProfitCenter
                                                                                      and $projection.PostingDate    <= _ProfitCenter.ValidityEndDate
                                                                                      and $projection.PostingDate    >= _ProfitCenter.ValidityStartDate
  association [0..*] to I_ProfitCenter              as _PartnerProfitCenter           on  $projection.ControllingArea = _PartnerProfitCenter.ControllingArea
                                                                                      and $projection.PartnerProfitCenter    = _PartnerProfitCenter.ProfitCenter
                                                                                      and $projection.PostingDate    <= _PartnerProfitCenter.ValidityEndDate
                                                                                      and $projection.PostingDate    >= _PartnerProfitCenter.ValidityStartDate
  association [0..1] to I_BusinessPartner           as _BusinessPartner               on  $projection.ServicePerformer = _BusinessPartner.BusinessPartner
  association [0..1] to I_Employment                as _Employment                    on  $projection.EmploymentInternalID = _Employment.EmploymentInternalID
  association [0..1] to I_PersonWorkAgreement_1     as _PersonWorkAgreement           on  $projection.PersonWorkAgreement = _PersonWorkAgreement.PersonWorkAgreement
  association [0..1] to I_AccountAssignmentCategory as _AccountAssignmentCategory     on  $projection.AccountAssignmentCategory = _AccountAssignmentCategory.AccountAssignmentCategory
  association [0..1] to I_WorkItem                  as _WorkItem                      on  $projection.WorkItem = _WorkItem.WorkItem

  association [0..1] to I_MasterFixedAsset          as _MasterFixedAsset              on  $projection.CompanyCode      = _MasterFixedAsset.CompanyCode
                                                                                      and $projection.MasterFixedAsset = _MasterFixedAsset.MasterFixedAsset
  association [0..1] to I_FixedAsset                as _FixedAsset                    on  $projection.CompanyCode = _FixedAsset.CompanyCode
                                                                                      and $projection.MasterFixedAsset = _FixedAsset.MasterFixedAsset
                                                                                      and $projection.FixedAsset       = _FixedAsset.FixedAsset

  association [0..1] to I_CompanyCode               as _CompanyCode                   on  $projection.CompanyCode = _CompanyCode.CompanyCode
  association [0..1] to I_BusinessArea              as _BusinessArea                  on  $projection.BusinessArea = _BusinessArea.BusinessArea
  association [0..1] to I_ControllingArea           as _ControllingArea               on  $projection.ControllingArea = _ControllingArea.ControllingArea
  association [0..1] to I_FunctionalArea            as _FunctionalArea                on  $projection.FunctionalArea = _FunctionalArea.FunctionalArea

  // CE2111 service document for aac R

  association [0..1] to I_ServiceDocumentType       as _ServiceDocumentType           on  $projection.ServiceDocumentType = _ServiceDocumentType.ServiceDocumentType

  association [0..1] to I_SalesOrder                as _SalesOrder                    on  $projection.SalesOrder = _SalesOrder.SalesOrder
  association [0..1] to I_SalesOrder                as _SpecialStockIdfgSalesOrder    on  $projection.SpecialStockIdfgSalesOrder = _SpecialStockIdfgSalesOrder.SalesOrder

  association [0..1] to I_SalesOrderItem            as _SalesOrderItem                on  $projection.SalesOrder     = _SalesOrderItem.SalesOrder
                                                                                      and $projection.SalesOrderItem = _SalesOrderItem.SalesOrderItem
  association [0..1] to I_SalesOrderItem            as _SpecialStockIdfgSalesOrderItm on  $projection.SpecialStockIdfgSalesOrder     = _SpecialStockIdfgSalesOrderItm.SalesOrder
                                                                                      and $projection.SpecialStockIdfgSalesOrderItem = _SpecialStockIdfgSalesOrderItm.SalesOrderItem
  association [0..1] to I_SalesOrderScheduleLine    as _SalesOrderScheduleLine        on  $projection.SalesOrder     = _SalesOrderScheduleLine.SalesOrder
                                                                                      and $projection.SalesOrderItem = _SalesOrderScheduleLine.SalesOrderItem
                                                                                      and $projection.SalesOrderScheduleLine = _SalesOrderScheduleLine.ScheduleLine
// Deprecated view; replaced by I_WBSElementBasicData

  association [0..1] to I_WBSElementByInternalKey   as _SpecialStockIdfgWBSElement    on  $projection.SpecialStockIdfgWBSElement = _SpecialStockIdfgWBSElement.WBSElementInternalID
// Deprecated view; replaced by I_WBSElementBasicData 

  association [0..1] to I_WBSElementByInternalKey   as _WBSElement                    on  $projection.WBSElementInternalID = _WBSElement.WBSElementInternalID
  association [0..1] to I_WBSElementBasicData       as _SpclStkIdfgWBSElmntBasicData  on  $projection.SpecialStockIdfgWBSElement = _SpclStkIdfgWBSElmntBasicData.WBSElementInternalID
  association [0..1] to I_WBSElementBasicData       as _WBSElementBasicData           on  $projection.WBSElementInternalID = _WBSElementBasicData.WBSElementInternalID


  association [0..1] to I_PurchaseOrder             as _PurchaseOrder                 on  $projection.PurchaseOrder = _PurchaseOrder.PurchaseOrder
  association [0..1] to I_PurchaseOrderItem         as _PurchaseOrderItem             on  $projection.PurchaseOrder     = _PurchaseOrderItem.PurchaseOrder
                                                                                      and $projection.PurchaseOrderItem = _PurchaseOrderItem.PurchaseOrderItem
  association [0..1] to I_ProjectNetwork            as _ProjectNetwork                on  $projection.ProjectNetwork = _ProjectNetwork.ProjectNetwork
// Deprecated view; replaced by I_ManufacturingOrder

  association [0..1] to I_MfgOrder                  as _MfgOrder                      on  $projection.ManufacturingOrder = _MfgOrder.ManufacturingOrder
// Deprecated view; replaced by I_ManufacturingOrderItem

  association [0..1] to I_MfgOrderItem              as _MfgOrderItem                  on  $projection.ManufacturingOrder     = _MfgOrderItem.ManufacturingOrder
                                                                                      and $projection.ManufacturingOrderItem = _MfgOrderItem.ManufacturingOrderItem

  association [0..1] to I_ManufacturingOrder        as _ManufacturingOrder            on  $projection.ManufacturingOrder = _ManufacturingOrder.ManufacturingOrder
  association [0..1] to I_ManufacturingOrderItem    as _ManufacturingOrderItem        on  $projection.ManufacturingOrder     = _ManufacturingOrderItem.ManufacturingOrder
                                                                                      and $projection.ManufacturingOrderItem = _ManufacturingOrderItem.ManufacturingOrderItem

  association [0..1] to I_LogisticsOrder            as _LogisticsOrder                on  $projection.OrderID = _LogisticsOrder.OrderID
// The field AUFPS is not assigned to the field POSNR of table AFPO, AUFPS is only filled in case of a goods receipt to a Production Order

//  association [0..1] to I_OrderItem                 as _OrderItem                     on  $projection.OrderID = _OrderItem.OrderID

//                                                                                      and $projection.OrderItem = _OrderItem.OrderItem

  association [0..1] to I_DeliveryDocument          as _DeliveryDocument              on  $projection.DeliveryDocument = _DeliveryDocument.DeliveryDocument
  association [0..1] to I_DeliveryDocumentItem      as _DeliveryDocumentItem          on  $projection.DeliveryDocument     = _DeliveryDocumentItem.DeliveryDocument
                                                                                      and $projection.DeliveryDocumentItem = _DeliveryDocumentItem.DeliveryDocumentItem
  association [0..1] to I_DeliveryDocument          as _DeliveryInMatlDocumentHeader  on  $projection.DeliveryInMatlDocumentHeader = _DeliveryInMatlDocumentHeader.DeliveryDocument

  association [0..1] to I_User                      as _User                          on  $projection.CreatedByUser = _User.UserID
  association [0..1] to I_AccountingDocumentType    as _AccountingDocumentType        on  $projection.AccountingDocumentType = _AccountingDocumentType.AccountingDocumentType
  association [0..1] to I_InventoryTransactionType  as _InventoryTransactionType      on  $projection.InventoryTransactionType = _InventoryTransactionType.InventoryTransactionType
                                                                                      and _InventoryTransactionType.IsMaterialDocumentRelevant = 'X'
  association [0..1] to I_Currency                  as _Currency                      on  $projection.CompanyCodeCurrency = _Currency.Currency
  
  association [0..*] to I_GoodsMvtTypeBySpclStkIndT as _GoodsMvtTypeBySpclStkIndT     on  $projection.GoodsMovementType         = _GoodsMvtTypeBySpclStkIndT.GoodsMovementType
                                                                                      and $projection.InventorySpecialStockType = _GoodsMvtTypeBySpclStkIndT.InventorySpecialStockType
                                                                                      and $projection.GoodsMovementRefDocType   = _GoodsMvtTypeBySpclStkIndT.GoodsMovementRefDocType
                                                                                      and $projection.GoodsReceiptType          = _GoodsMvtTypeBySpclStkIndT.GoodsReceiptType
                                                                                      and $projection.ConsumptionPosting        = _GoodsMvtTypeBySpclStkIndT.ConsumptionPosting 
  association [0..*] to I_ResourceBasic             as _ResourceBasic                 on  $projection.ResourceID                = _ResourceBasic.ResourceID
  association [0..*] to I_ResourceBasic             as _IssgOrRcvgResourceBasic       on  $projection.IssgOrRcvgResourceID      = _IssgOrRcvgResourceBasic.ResourceID
  association [0..1] to I_GoodsMvtCancelationTypeVH as _CancelationType               on  $projection.GoodsMovementCancellationType = _CancelationType.GoodsMovementCancellationType
{

// The technical key fields from table MATDOC are only inserted here to make them available for the CDS based BW extraction via CDC

// GTNC field names are alligned with R.D. and centrally approved

  @Consumption.hidden: true
  cast(key1 as nsdm_key1   preserving type ) as MaterialDocumentKey1,
  @Consumption.hidden: true
  cast(key2 as nsdm_key2   preserving type ) as MaterialDocumentKey2,
  @Consumption.hidden: true
  cast(key3 as nsdm_key3   preserving type ) as MaterialDocumentKey3,
  @Consumption.hidden: true
  cast(key4 as nsdm_key4   preserving type ) as MaterialDocumentKey4,
  @Consumption.hidden: true
  cast(key5 as nsdm_key5   preserving type ) as MaterialDocumentKey5,
  @Consumption.hidden: true
  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,

  cast(matbf as nsdm_matbf preserving type ) as StockIdentifyingMaterial,
  werks             as Plant,
  cast(lgort_sid as nsdm_lgort_l   preserving type )  as StockIdfgStorageLocation,
  charg_sid         as StockIdentifyingBatch,
  lifnr_sid         as SpecialStockIdfgSupplier,
  cast(mat_kdauf as nsdm_mat_kdauf preserving type )  as SpecialStockIdfgSalesOrder,
  cast(mat_kdpos as nsdm_mat_kdpos preserving type )  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,     //v2834623

  cast(umwrk_cid as nsdm_plant_cid_l           preserving type ) as IssgOrRcvgStkIdfgPlant,
  cast(lgort_cid as nsdm_lgort_cid_l           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, //^2834623,

  cast(resourcename_cid as nsdm_resourcename_cid_l preserving type )  as IssgOrRcvgResourceID,
  kzzug             as GoodsReceiptType,


  -- with records of type MDOC_CP, AG_MDOC_CF etc there is no unique key except the technical GUID key, so we don't use any key fields at all

  matnr             as Material,
  lgort             as StorageLocation,
  charg             as Batch,
  cast(lifnr as mmim_supplier                      preserving type )  as Supplier,
  kdauf             as SalesOrder,
  cast(kdpos as nsdm_sales_order_item              preserving type )  as SalesOrderItem,
  cast(kdein as nsdm_kdein                         preserving type )  as SalesOrderScheduleLine,
  cast(kunnr as mmim_customer                      preserving type )  as Customer,
  cast(disub_owner as nsdm_add_spcl_stock_supplier preserving type )  as StockOwner,
  cast(ps_psp_pnr as nsdm_wbs_internal_id          preserving type )  as WBSElementInternalID,

  cast(ummat as nsdm_umat  preserving type )        as IssgOrRcvgMaterial,
  cast(umwrk as nsdm_plant preserving type )        as IssuingOrReceivingPlant,
  cast(umlgo as nsdm_umlgo preserving type )        as IssuingOrReceivingStorageLoc,
  cast(umcha as nsdm_umcha preserving type )        as IssgOrRcvgBatch,
  umsok             as IssgOrRcvgSpclStockInd,
  cast(umbar as nsdm_umbar preserving type )        as IssuingOrReceivingValType,

  cast(kzbew as nsdm_kzbew_l preserving type )      as GoodsMovementRefDocType,
  cast(kzvbr as nsdm_kzvbr   preserving type )      as ConsumptionPosting,
  grund             as GoodsMovementReasonCode,
  weanz             as NumberOfSlipsToBePrinted,
  cast(nroflabels as nsdm_labelstobeprinted preserving type ) as NumberOfLabelsToBePrinted,
  bwart             as GoodsMovementType,
  cast(shkzg as mmiv_shkzg preserving type )        as DebitCreditCode,
  cast(insmk as nsdm_insmk preserving type )        as InventoryUsabilityCode,
  @Semantics.quantity.unitOfMeasure: 'MaterialBaseUnit'
  @DefaultAggregation: #NONE
  menge             as QuantityInBaseUnit,
  meins             as MaterialBaseUnit,

  @DefaultAggregation:#NONE
  @Semantics.quantity.unitOfMeasure: 'MaterialBaseUnit'
  stock_qty         as MatlStkChangeQtyInBaseUnit,

  @DefaultAggregation:#NONE
  @Semantics.quantity.unitOfMeasure: 'MaterialBaseUnit'
  consumption_qty   as MatlCnsmpnQtyInMatlBaseUnit,
  
  @DefaultAggregation:#NONE
  @Semantics.quantity.unitOfMeasure: 'DeliveryQuantityUnit'
  cast(lsmng as nsdm_lsmng              preserving type ) as QuantityInDeliveryQtyUnit,
  lsmeh             as DeliveryQuantityUnit,

  @Semantics.businessDate.at: true
  bldat             as DocumentDate,
  blart             as AccountingDocumentType,
  cast(vgart as nsdm_vgart              preserving type ) as InventoryTransactionType,
  cast(kzbws as nsdm_separate_valn_type preserving type ) as InventorySpecialStockValnType,
  cast(xobew as nsdm_xobew              preserving type ) as IsSupplierStockValuation,

  cpudt             as CreationDate,
  cputm             as CreationTime,
  usnam             as CreatedByUser,
  bktxt             as MaterialDocumentHeaderText,
  sgtxt             as MaterialDocumentItemText,
  cast(le_vbeln as nsdm_delivery_on_header preserving type) as DeliveryInMatlDocumentHeader,
  frbnr             as BillOfLading,

  vfdat             as ShelfLifeExpirationDate,
  hsdat             as ManufactureDate,

  @Semantics.quantity.unitOfMeasure: 'EntryUnit'
  @DefaultAggregation: #NONE
  cast(erfmg as nsdm_erfmg preserving type )             as QuantityInEntryUnit,
  cast(erfme as nsdm_erfme preserving type )             as EntryUnit,
  bwtar             as InventoryValuationType,

  @Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'   //v2813353

  @DefaultAggregation: #NONE
  cast(bstmg as nsdm_mb_bstmg preserving type )          as GoodsReceiptQtyInOrderUnit,
  bstme             as OrderQuantityUnit,                  //^2813353


  cast(ebeln as nsdm_bstnr    preserving type )          as PurchaseOrder,
  ebelp             as PurchaseOrderItem,
  nplnr             as ProjectNetwork,
  cast(aufnr as nsdm_manufacturing_order preserving type) as ManufacturingOrder,
  cast(aufps as nsdm_manufacturing_order_item preserving type) as ManufacturingOrderItem,
  aufnr             as OrderID,
  cast(aufps as nsdm_co_posnr preserving type ) as OrderItem,
  cast(rsnum as nsdm_rsnum    preserving type ) as Reservation,
  cast(rspos as nsdm_rspos    preserving type ) as ReservationItem,
  cast(kzear as nsdm_kzear_l  preserving type ) as ReservationIsFinallyIssued,
  vbeln_im          as DeliveryDocument,
  cast(vbelp_im as nsdm_delivery_document_item preserving type) as DeliveryDocumentItem,
  elikz             as IsCompletelyDelivered,

  cast(sjahr as nsdm_sjahr_l preserving type ) as ReversedMaterialDocumentYear,
  cast(smbln as nsdm_smbln_l preserving type ) as ReversedMaterialDocument,
  cast(smblp as nsdm_smblp_l preserving type ) as ReversedMaterialDocumentItem,
  cast(xwsbr as nsdm_xwsbr   preserving type ) as RvslOfGoodsReceiptIsAllowed,
  cast(reversal_movement as nsdm_xstbw preserving type) as IsReversalMovementType,
  cancelled         as GoodsMovementIsCancelled,
  cast(cancellation_type as nsdm_cancellation_type_l preserving type ) as GoodsMovementCancellationType,

  wempf             as GoodsRecipientName,
  ablad             as UnloadingPointName,
  kostl             as CostCenter,
  sakto             as GLAccount,
  kstrg             as CostObject,
  @VDM.lifecycle.status: #DEPRECATED
  @VDM.lifecycle.successor: 'ProfitabilitySegment_2'
  cast( case when paobjnr > '9999999999' then '9999999999' else lpad( paobjnr, 10, '0' ) end as rkeobjnr_numc ) as ProfitabilitySegment,
  cast(paobjnr as rkeobjnr_char preserving type ) as ProfitabilitySegment_2,
  pprctr            as PartnerProfitCenter,
  prctr             as ProfitCenter,
  cast(kalnr as nsdm_kalnr1 preserving type )             as CostEstimate,

  xblnr             as ReferenceDocument,
  serviceperformer  as ServicePerformer,
  @VDM.lifecycle.status: #DEPRECATED
  @VDM.lifecycle.successor: 'PersonWorkAgreement'
  cast(pernr    as nsdm_employment_id preserving type ) as EmploymentInternalID,
  pernr             as PersonWorkAgreement,
  cast(knttp_gr as nsdm_knttp         preserving type ) as AccountAssignmentCategory,
  work_item_id      as WorkItem,
  cast(fbuda    as nsdm_fbuda         preserving type ) as ServicesRenderedDate,
  zekkn             as AccountAssignmentNumber,

  bukrs             as CompanyCode,
  gsber             as BusinessArea,
  kokrs             as ControllingArea,
  fkber             as FunctionalArea,
  cast(urzei as nsdm_urzei            preserving type )   as OriginalMaterialDocumentItem,
  maa_urzei         as MultiAcctAssgmtOriglMatlDocItm,
  weunb             as GoodsReceiptIsNonValuated,
  @VDM.lifecycle.status: #DEPRECATED
  @VDM.lifecycle.successor: 'MultipleAccountAssignmentCode'
  cast(xmacc        as mmim_xmacc_2    preserving type )  as HasMultipleAccountAssignment,
  cast(xmacc        as nsdm_xmacc_code preserving type )  as MultipleAccountAssignmentCode,
  anln1             as MasterFixedAsset,
  cast(anln2        as nsdm_anln2      preserving type )  as FixedAsset,
  @Semantics.businessDate.at: true
  cast(budat        as mmim_postingdate preserving type ) as PostingDate,
  @Semantics.fiscal.yearPeriod: true
  cast(gjper as nsdm_jahrper            preserving type)  as FiscalYearPeriod,
  @Semantics.fiscal.yearVariant: true
  periv             as FiscalYearVariant,

  fistl             as FundsCenter,
  geber             as Fund,
  @VDM.lifecycle.status: #DEPRECATED
  @VDM.lifecycle.successor: 'CommitmentItemShortID'  
  fipos             as CommitmentItem,
  cast(fipos as fmis_ci_internalname    preserving type)  as CommitmentItemShortID,
  grant_nbr         as GrantID,

  lgtyp             as StorageType,
  lgpla             as StorageBin,
  cast(bfwms as nsdm_bfwms             preserving type )  as CtrlPostgForExtWhseMgmtSyst,
  
  --Reference Fields
  cast(lfbja as nsdm_lfbja             preserving type )  as ReferenceDocumentFiscalYear,
  lfbnr             as InvtryMgmtReferenceDocument,
  cast(lfpos as mmiv_lfpos             preserving type )  as InvtryMgmtRefDocumentItem, 

  --EWM Fields
  ewm_lgnum         as EWMWarehouse,
  ewm_lgpla         as EWMStorageBin,
  cast(ewm_huident  as exidv            preserving type)  as HandlingUnitExternalID,

  --Service Document Fields
  service_doc_id    as ServiceDocument,
  cast(service_doc_item_id as nsdm_fco_srvdoc_item_id preserving type ) as ServiceDocumentItem,
  cast(service_doc_type    as nsdm_fco_srvdoc_type    preserving type ) as ServiceDocumentType,
  
  --Fields for print documents
  cast(aufpl as nsdm_co_aufpl  preserving type )          as MaintOrderRoutingNumber,
  cast(aplzl as nsdm_cim_count preserving type )          as MaintOrderOperationCounter,
  ematn             as ManufacturerMaterial,
  cast(xblvs as nsdm_xblvs    preserving type )           as ActivityInWarehouseIsPending,
  lgnum             as WarehouseNumber,
  cast(tbnum as nsdm_tbnum    preserving type )           as TransferRequirementNumber,
  tbpri             as TransferPriority,
  wever             as VersionForPrintingSlip,  
  xprint            as ManualPrintIsTriggered,   
  evers             as ShippingInstruction,
  evere             as ShipgInstrnSupplierCompliance,
  @Semantics.quantity.unitOfMeasure: 'OrderPriceUnit'
  cast(bpmng as mmiv_bpmng_po preserving type )           as QtyInPurchaseOrderPriceUnit,
  bprme             as OrderPriceUnit,

  yearday_budat     as YearDay,
  @Semantics.calendar.yearWeek: true
  yearweek_budat    as YearWeek,
  @Semantics.calendar.yearMonth: true
  yearmonth_budat   as YearMonth,
  @Semantics.calendar.yearQuarter: true
  yearquarter_budat as YearQuarter,
  @Semantics.calendar.year: true
  year_budat        as DocumentYear,
  @Semantics.calendar.quarter: true
  quarter_budat     as CalendarQuarter,
  @Semantics.calendar.month: true
  month_budat       as CalendarMonth,
  @Semantics.calendar.week: true
  week_budat        as CalendarWeek,
  @Semantics.calendar.dayOfYear: true
  cast(day_budat as nsdm_day_of_year preserving type)     as CalendarDay,
  cast(weekday_budat as nsdm_day_of_week preserving type) as WeekDay,
  gjahr             as FiscalYear,
  cast(gjper_curr_per as fins_fyearperiod preserving type) as YearPeriod,

  @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
  @DefaultAggregation: #NONE
  cast(dmbtr       as nsdm_dmbtr_cs      preserving type )  as TotalGoodsMvtAmtInCCCrcy,
  @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
  @DefaultAggregation: #NONE
  cast(dmbtr_stock as nsdm_dmbtr_stock_l preserving type )  as GoodsMovementStkAmtInCCCrcy,
  @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
  @DefaultAggregation: #NONE
  cast(dmbtr_cons  as nsdm_dmbtr_cons_l  preserving type )  as GoodsMvtCnsmpnAmtInCCCrcy,
  cast(waers as nsdm_comp_code_currency  preserving type)   as CompanyCodeCurrency,

  @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
  @DefaultAggregation: #NONE
  cast(exbwr as nsdm_exbwr preserving type )              as GdsMvtExtAmtInCoCodeCrcy,
  @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
  @DefaultAggregation: #NONE
  cast(vkwrt as nsdm_vkwrt preserving type )              as SlsPrcAmtInclVATInCoCodeCrcy,
  @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
  @DefaultAggregation: #NONE
  exvkw             as EnteredSlsAmtInCoCodeCrcy,
  
  cast(xabln as nsdm_xabln preserving type )              as GoodsIssueOrReceiptSlipNumber,

  @Consumption.hidden: true
  tcode2            as TransactionCode,

  @Consumption.hidden: true
  cast(xauto as nsdm_xauto_l      preserving type) as IsAutomaticallyCreated,
  @Consumption.hidden: true
  cast(line_id as nsdm_mb_line_id preserving type) as MaterialDocumentLine,
  @Consumption.hidden: true
  parent_id         as MaterialDocumentParentLine,
  @Consumption.hidden: true
  cast(line_depth as nsdm_mb_line_depth        preserving type ) as HierarchyNodeLevel,

  @Consumption.hidden: true
  record_type       as MaterialDocumentRecordType,
  @Consumption.hidden: true
  cast(header_counter as nsdm_header_counter_l preserving type ) as IsMaterialDocumentHeader,
  
  @DefaultAggregation: #NONE  
  cast(rsart as nsdm_reservation_record_type   preserving type ) as ReservationRecordType,
  
  cast(xsaut as nsdm_xsaut                     preserving type ) as SerialNumbersAreCreatedAutomly,
  cast(xstor as nsdm_kzsto                     preserving type ) as MaterialDocumentPostingType,
  awsys             as LogicalSystem,
  
  _Material,
  _StockIdentifyingMaterial,
  _IssgOrRcvgMaterial,
//  _Product,

//  _StockIdentifyingProduct,

//  _IssgOrRcvgProduct,


  _Plant,
  _IssuingOrReceivingPlant,
  _StorageLocation,
  _IssuingOrReceivingStorageLoc,
  _StockIdfgStorageLocation,

  _Supplier,
  _SpecialStockIdfgSupplier,

  _Customer,
  _SpecialStockIdfgCustomer,

  @Consumption.hidden: true
  _SupplierCompanyByPlant,
  @Consumption.hidden: true
  _CustomerCompanyByPlant,

  _BPStockOwner,
  _SpecialStockIdfgStockOwner,

  _InventorySpecialStockType,
  _IssgOrRcvgSpclStockInd,
  _InventoryStockType,
  _IssuingOrReceivingStockType,
  _InventoryValuationType,

  _GoodsMovementType,
  _GoodsMovementReasonCode,
  _DebitCreditCode,
  @API.element.releaseState: #DEPRECATED
  @API.element.successor: '_StockType_2'
  @VDM.lifecycle.status: #DEPRECATED
  @VDM.lifecycle.successor: '_StockType_2'
  _StockType,
  @API.element.releaseState: #DEPRECATED
  @API.element.successor: '_InventoryUsabilityCode'
  @VDM.lifecycle.status: #DEPRECATED
  @VDM.lifecycle.successor: '_InventoryUsabilityCode'
  _StockType_2,
  _InventoryUsabilityCode,

  _MaterialBaseUnit,
  _EntryUnit,

  _BusinessPartner,
  @VDM.lifecycle.status: #DEPRECATED
  @VDM.lifecycle.successor: '_PersonWorkAgreement'
  _Employment,
  _PersonWorkAgreement,
  _AccountAssignmentCategory,
  _WorkItem,
  _MasterFixedAsset,
  _FixedAsset,
  _CompanyCode,
  _BusinessArea,
  _ControllingArea,
  _GLAccount,
  _CostCenter,
  _FunctionalArea,
  _ProfitCenter,

  _ServiceDocumentType,

  _SalesOrder,
  _SpecialStockIdfgSalesOrder,

  _SalesOrderItem,
  _SpecialStockIdfgSalesOrderItm,

  _SalesOrderScheduleLine,

  @VDM.lifecycle.status: #DEPRECATED
  @VDM.lifecycle.successor: '_WBSElementBasicData'
  _WBSElement,
  @VDM.lifecycle.status: #DEPRECATED
  @VDM.lifecycle.successor: '_SpclStkIdfgWBSElmntBasicData'
  _SpecialStockIdfgWBSElement,
  _WBSElementBasicData,
  _SpclStkIdfgWBSElmntBasicData,

  _PurchaseOrder,
  _PurchaseOrderItem,
  _ProjectNetwork,
  @VDM.lifecycle.status: #DEPRECATED
  @VDM.lifecycle.successor: '_ManufacturingOrder'
  _MfgOrder,
  @VDM.lifecycle.status: #DEPRECATED
  @VDM.lifecycle.successor: '_ManufacturingOrderItem'
  _MfgOrderItem,
  _ManufacturingOrder,
  _ManufacturingOrderItem,
  _LogisticsOrder,
  _DeliveryDocument,
  _DeliveryDocumentItem,
  _DeliveryInMatlDocumentHeader,

  _User,
  _AccountingDocumentType,
  _InventoryTransactionType,
  _Currency,
  _GoodsMvtTypeBySpclStkIndT,
  
  _ResourceBasic,
  _IssgOrRcvgResourceBasic,
  _PartnerProfitCenter,
  _CancelationType
}