I_MaintObjectListCollection

DDL: I_MAINTOBJECTLISTCOLLECTION Type: view_entity COMPOSITE

Maintenance Object List Collection

I_MaintObjectListCollection is a Composite CDS View that provides data about "Maintenance Object List Collection" in SAP S/4HANA. It reads from 11 data sources and exposes 648 fields with key field MaintenanceObjectList. It has 10 associations to related views.

Data Sources (11)

SourceAliasJoin Type
I_MaintObjListDeliveryDocument I_MaintObjListDeliveryDocument from
I_MaintObjListHandlingUnit I_MaintObjListHandlingUnit union_all
I_MaintObjListInbDelivItmComp I_MaintObjListInbDelivItmComp union_all
I_MaintObjListInspectionLot I_MaintObjListInspectionLot union_all
I_MaintObjListJITCall I_MaintObjListJITCall union_all
I_MaintObjListLogisticsOrder I_MaintObjListLogisticsOrder union_all
I_MaintObjListMaterialDocument I_MaintObjListMaterialDocument union_all
I_MaintObjListPhysInventoryDoc I_MaintObjListPhysInventoryDoc union_all
I_MaintObjListPurchaseOrder I_MaintObjListPurchaseOrder union_all
I_MaintObjListPurchaseReqn I_MaintObjListPurchaseReqn union_all
I_MaintObjListSalesOrder I_MaintObjListSalesOrder union_all

Associations (10)

CardinalityTargetAliasCondition
[0..1] I_Movement_TypeText _MovementTypeText $projection.GoodsMovementType = _MovementTypeText.MovementType and _MovementTypeText.Language = $session.system_language
[1..1] I_Customer _Customer $projection.Customer = _Customer.Customer
[0..1] I_SalesDocumentTypeText _Text $projection.SalesOrderType = _Text.SalesDocumentType and _Text.Language = $session.system_language
[1..1] I_AccountingDocumentTypeText _DocumentType $projection.AccountingDocumentType = _DocumentType.AccountingDocumentType and _DocumentType.Language = $session.system_language
[1..1] I_DebitCreditCodeText _DebitCreditText $projection.DebitCreditCode = _DebitCreditText.DebitCreditCode and _DebitCreditText.Language = $session.system_language
[1..1] I_Supplier _Supplier $projection.Supplier = _Supplier.Supplier
[1..1] I_Plant _Plant $projection.Plant = _Plant.Plant
[1..1] I_StorageLocation _StorageLocation $projection.Plant = _StorageLocation.Plant and $projection.StorageLocation = _StorageLocation.StorageLocation
[0..1] I_OrderTypeText _OrderText $projection.OrderType = _OrderText.OrderType and _OrderText.Language = $session.system_language
[0..1] I_BusinessPartner _ShipToParty $projection.ShipToParty = _ShipToParty.BusinessPartner

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
EndUserText.label Maintenance Object List Collection view
Metadata.ignorePropagatedAnnotations true view

Fields (648)

KeyFieldSource TableSource FieldDescription
KEY MaintenanceObjectList MaintenanceObjectList
DeliveryDocument DeliveryDocument
DeliveryDocumentItem DeliveryDocumentItem
SalesOrder
SalesOrderItem
MaterialDocument
MaterialDocumentItem
MaterialDocumentYear
InspectionLot
LogisticsOrder
OrderItem
HandlingUnitExternalID
PhysicalInventoryDocument
PhysicalInventoryDocumentItem
FiscalYear
PurchaseOrder
PurchaseOrderItem
PurchaseRequisition
PurchaseRequisitionItem
InternalJITCallNumber
JITCallItemNumber
CompGrpNumber
SerialNumberAssignmentDate SerialNumberAssignmentDate
SerialNumberAssignmentTime SerialNumberAssignmentTime
Customer Customer
CustomerName _Customer CustomerName
Supplier
SupplierName
NumberOfSerialNumbers NumberOfSerialNumbers
SDDocumentCategory SDDocumentCategory
GoodsMovementType GoodsMovementType
MovementTypeDescription _MovementTypeText MovementTypeDescription
SalesOrderType
SalesDocumentTypeName
SalesOrderItemCategory
AccountingDocumentType
AccountingDocumentTypeName
Plant
PlantName
StorageLocation
StorageLocationName
Batch
DebitCreditCode
DebitCreditCodeName
OrderCategory
OrderType
OrderTypeName
OrderIsRefurbishmentOrder
SerialNumberPhysicalInvtryType
PhysicalInventoryStockType
PhysicalInventoryStockTypeName
PurchasingDocumentCategory
PurchasingDocumentType
PurchasingDocumentTypeName
PurchasingDocumentItemCategory
ExternalJITCallNumber
ShipToParty
BusinessPartnerName
SubcontrgCompOfInbDelivItem
system_languagekeyMaintenanceObjectList
DeliveryDocument
DeliveryDocumentItem
SalesOrder SalesOrder
SalesOrderItem SalesOrderItem
MaterialDocument
MaterialDocumentItem
MaterialDocumentYear
InspectionLot
LogisticsOrder
OrderItem
HandlingUnitExternalID
PhysicalInventoryDocument
PhysicalInventoryDocumentItem
FiscalYear
PurchaseOrder
PurchaseOrderItem
PurchaseRequisition
PurchaseRequisitionItem
InternalJITCallNumber
JITCallItemNumber
CompGrpNumber
SerialNumberAssignmentDate SerialNumberAssignmentDate
SerialNumberAssignmentTime
Customer Customer
CustomerName _Customer CustomerName
Supplier
SupplierName
NumberOfSerialNumbers NumberOfSerialNumbers
SDDocumentCategory SDDocumentCategory
GoodsMovementType
MovementTypeDescription
SalesOrderType SalesOrderType
SalesDocumentTypeName _Text SalesDocumentTypeName
SalesOrderItemCategory SalesOrderItemCategory
AccountingDocumentType
AccountingDocumentTypeName
Plant
PlantName
StorageLocation
StorageLocationName
Batch
DebitCreditCode
DebitCreditCodeName
OrderCategory
OrderType
OrderTypeName
OrderIsRefurbishmentOrder
SerialNumberPhysicalInvtryType
PhysicalInventoryStockType
PhysicalInventoryStockTypeName
PurchasingDocumentCategory
PurchasingDocumentType
PurchasingDocumentTypeName
PurchasingDocumentItemCategory
ExternalJITCallNumber
ShipToParty
BusinessPartnerName
SubcontrgCompOfInbDelivItem
StorageLocationkeyMaintenanceObjectList
DeliveryDocument
DeliveryDocumentItem
SalesOrder
SalesOrderItem
MaterialDocument MaterialDocument
MaterialDocumentItem MaterialDocumentItem
MaterialDocumentYear MaterialDocumentYear
InspectionLot
LogisticsOrder
OrderItem
HandlingUnitExternalID
PhysicalInventoryDocument
PhysicalInventoryDocumentItem
FiscalYear
PurchaseOrder
PurchaseOrderItem
PurchaseRequisition
PurchaseRequisitionItem
InternalJITCallNumber
JITCallItemNumber
CompGrpNumber
SerialNumberAssignmentDate SerialNumberAssignmentDate
SerialNumberAssignmentTime SerialNumberAssignmentTime
Customer Customer
CustomerName _Customer CustomerName
Supplier Supplier
SupplierName _Supplier SupplierName
NumberOfSerialNumbers NumberOfSerialNumbers
SDDocumentCategory
GoodsMovementType GoodsMovementType
MovementTypeDescription _MovementTypeText MovementTypeDescription
SalesOrderType
SalesDocumentTypeName
SalesOrderItemCategory
AccountingDocumentType AccountingDocumentType
AccountingDocumentTypeName _DocumentType AccountingDocumentTypeName
Plant Plant
PlantName _Plant PlantName
StorageLocation StorageLocation
StorageLocationName _StorageLocation StorageLocationName
Batch Batch
DebitCreditCode DebitCreditCode
DebitCreditCodeName _DebitCreditText DebitCreditCodeName
OrderCategory
OrderType
OrderTypeName
OrderIsRefurbishmentOrder
SerialNumberPhysicalInvtryType
PhysicalInventoryStockType
PhysicalInventoryStockTypeName
PurchasingDocumentCategory
PurchasingDocumentType
PurchasingDocumentTypeName
PurchasingDocumentItemCategory
ExternalJITCallNumber
ShipToParty
BusinessPartnerName
SubcontrgCompOfInbDelivItem
DeliveryDocument
DeliveryDocumentItem
SalesOrder
SalesOrderItem
MaterialDocument
MaterialDocumentItem
MaterialDocumentYear
InspectionLot InspectionLot
LogisticsOrder
OrderItem
HandlingUnitExternalID
PhysicalInventoryDocument
PhysicalInventoryDocumentItem
FiscalYear
PurchaseOrder
PurchaseOrderItem
PurchaseRequisition
PurchaseRequisitionItem
InternalJITCallNumber
JITCallItemNumber
CompGrpNumber
SerialNumberAssignmentDate SerialNumberAssignmentDate
SerialNumberAssignmentTime SerialNumberAssignmentTime
Customer
CustomerName
Supplier
SupplierName
NumberOfSerialNumbers NumberOfSerialNumbers
SDDocumentCategory
GoodsMovementType
MovementTypeDescription
SalesOrderType
SalesDocumentTypeName
SalesOrderItemCategory
AccountingDocumentType
AccountingDocumentTypeName
Plant
PlantName
StorageLocation
StorageLocationName
Batch
DebitCreditCode
DebitCreditCodeName
OrderCategory
OrderType
OrderTypeName
OrderIsRefurbishmentOrder
SerialNumberPhysicalInvtryType
PhysicalInventoryStockType
PhysicalInventoryStockTypeName
PurchasingDocumentCategory
PurchasingDocumentType
PurchasingDocumentTypeName
PurchasingDocumentItemCategory
ExternalJITCallNumber
ShipToParty
BusinessPartnerName
SubcontrgCompOfInbDelivItem
system_languagekeyMaintenanceObjectList
DeliveryDocument
DeliveryDocumentItem
SalesOrder
SalesOrderItem
MaterialDocument
MaterialDocumentItem
MaterialDocumentYear
InspectionLot
LogisticsOrder LogisticsOrder
OrderItem OrderItem
HandlingUnitExternalID
PhysicalInventoryDocument
PhysicalInventoryDocumentItem
FiscalYear
PurchaseOrder
PurchaseOrderItem
PurchaseRequisition
PurchaseRequisitionItem
InternalJITCallNumber
JITCallItemNumber
CompGrpNumber
SerialNumberAssignmentDate SerialNumberAssignmentDate
SerialNumberAssignmentTime SerialNumberAssignmentTime
Customer
CustomerName
Supplier
SupplierName
NumberOfSerialNumbers NumberOfSerialNumbers
SDDocumentCategory
GoodsMovementType
MovementTypeDescription
SalesOrderType
SalesDocumentTypeName
SalesOrderItemCategory
AccountingDocumentType
AccountingDocumentTypeName
Plant
PlantName
StorageLocation
StorageLocationName
Batch
DebitCreditCode
DebitCreditCodeName
OrderCategory OrderCategory
OrderType OrderType
OrderTypeName _OrderText OrderTypeName
OrderIsRefurbishmentOrder OrderIsRefurbishmentOrder
SerialNumberPhysicalInvtryType
PhysicalInventoryStockType
PhysicalInventoryStockTypeName
PurchasingDocumentCategory
PurchasingDocumentType
PurchasingDocumentTypeName
PurchasingDocumentItemCategory
ExternalJITCallNumber
ShipToParty
BusinessPartnerName
SubcontrgCompOfInbDelivItem
DeliveryDocument
DeliveryDocumentItem
SalesOrder
SalesOrderItem
MaterialDocument
MaterialDocumentItem
MaterialDocumentYear
InspectionLot
LogisticsOrder
OrderItem
HandlingUnitExternalID HandlingUnitExternalID
PhysicalInventoryDocument
PhysicalInventoryDocumentItem
FiscalYear
PurchaseOrder
PurchaseOrderItem
PurchaseRequisition
PurchaseRequisitionItem
InternalJITCallNumber
JITCallItemNumber
CompGrpNumber
SerialNumberAssignmentDate SerialNumberAssignmentDate
SerialNumberAssignmentTime SerialNumberAssignmentTime
Customer
CustomerName
Supplier
SupplierName
NumberOfSerialNumbers NumberOfSerialNumbers
SDDocumentCategory
GoodsMovementType
MovementTypeDescription
SalesOrderType
SalesDocumentTypeName
SalesOrderItemCategory
AccountingDocumentType
AccountingDocumentTypeName
Plant
PlantName
StorageLocation
StorageLocationName
Batch
DebitCreditCode
DebitCreditCodeName
OrderCategory
OrderType
OrderTypeName
OrderIsRefurbishmentOrder
SerialNumberPhysicalInvtryType
PhysicalInventoryStockType
PhysicalInventoryStockTypeName
PurchasingDocumentCategory
PurchasingDocumentType
PurchasingDocumentTypeName
PurchasingDocumentItemCategory
ExternalJITCallNumber
ShipToParty
BusinessPartnerName
SubcontrgCompOfInbDelivItem
StorageLocationkeyMaintenanceObjectList
DeliveryDocument
DeliveryDocumentItem
SalesOrder
SalesOrderItem
MaterialDocument
MaterialDocumentItem
MaterialDocumentYear
InspectionLot
LogisticsOrder
OrderItem
HandlingUnitExternalID
PhysicalInventoryDocument PhysicalInventoryDocument
PhysicalInventoryDocumentItem PhysicalInventoryDocumentItem
FiscalYear FiscalYear
PurchaseOrder
PurchaseOrderItem
PurchaseRequisition
PurchaseRequisitionItem
InternalJITCallNumber
JITCallItemNumber
CompGrpNumber
SerialNumberAssignmentDate SerialNumberAssignmentDate
SerialNumberAssignmentTime
Customer
CustomerName
Supplier
SupplierName
NumberOfSerialNumbers NumberOfSerialNumbers
SDDocumentCategory
GoodsMovementType
MovementTypeDescription
SalesOrderType
SalesDocumentTypeName
SalesOrderItemCategory
AccountingDocumentType
AccountingDocumentTypeName
Plant Plant
PlantName _Plant PlantName
StorageLocation StorageLocation
StorageLocationName _StorageLocation StorageLocationName
Batch Batch
DebitCreditCode
DebitCreditCodeName
OrderCategory
OrderType
OrderTypeName
OrderIsRefurbishmentOrder
SerialNumberPhysicalInvtryType SerialNumberPhysicalInvtryType
PhysicalInventoryStockType PhysicalInventoryStockType
PhysicalInventoryStockTypeName _Text PhysicalInventoryStockTypeName
PurchasingDocumentCategory
PurchasingDocumentType
PurchasingDocumentTypeName
PurchasingDocumentItemCategory
ExternalJITCallNumber
ShipToParty
BusinessPartnerName
SubcontrgCompOfInbDelivItem
system_languagekeyMaintenanceObjectList
DeliveryDocument
DeliveryDocumentItem
SalesOrder
SalesOrderItem
MaterialDocument
MaterialDocumentItem
MaterialDocumentYear
InspectionLot
LogisticsOrder
OrderItem
HandlingUnitExternalID
PhysicalInventoryDocument
PhysicalInventoryDocumentItem
FiscalYear
PurchaseOrder PurchaseOrder
PurchaseOrderItem PurchaseOrderItem
PurchaseRequisition
PurchaseRequisitionItem
InternalJITCallNumber
JITCallItemNumber
CompGrpNumber
SerialNumberAssignmentDate SerialNumberAssignmentDate
SerialNumberAssignmentTime
Customer
CustomerName
Supplier
SupplierName
NumberOfSerialNumbers NumberOfSerialNumbers
SDDocumentCategory
GoodsMovementType
MovementTypeDescription
SalesOrderType
SalesDocumentTypeName
SalesOrderItemCategory
AccountingDocumentType
AccountingDocumentTypeName
Plant Plant
PlantName _Plant PlantName
StorageLocation
StorageLocationName
Batch
DebitCreditCode
DebitCreditCodeName
OrderCategory
OrderType
OrderTypeName
OrderIsRefurbishmentOrder
SerialNumberPhysicalInvtryType
PhysicalInventoryStockType
PhysicalInventoryStockTypeName
PurchasingDocumentCategory PurchasingDocumentCategory
PurchasingDocumentType PurchasingDocumentType
PurchasingDocumentTypeName _Text PurchasingDocumentTypeName
PurchasingDocumentItemCategory PurchasingDocumentItemCategory
ExternalJITCallNumber
ShipToParty
BusinessPartnerName
SubcontrgCompOfInbDelivItem
system_languagekeyMaintenanceObjectList
DeliveryDocument
DeliveryDocumentItem
SalesOrder
SalesOrderItem
MaterialDocument
MaterialDocumentItem
MaterialDocumentYear
InspectionLot
LogisticsOrder
OrderItem
HandlingUnitExternalID
PhysicalInventoryDocument
PhysicalInventoryDocumentItem
FiscalYear
PurchaseOrder
PurchaseOrderItem
PurchaseRequisition PurchaseRequisition
PurchaseRequisitionItem PurchaseRequisitionItem
InternalJITCallNumber
JITCallItemNumber
CompGrpNumber
SerialNumberAssignmentDate SerialNumberAssignmentDate
SerialNumberAssignmentTime
Customer
CustomerName
Supplier
SupplierName
NumberOfSerialNumbers NumberOfSerialNumbers
SDDocumentCategory
GoodsMovementType
MovementTypeDescription
SalesOrderType
SalesDocumentTypeName
SalesOrderItemCategory
AccountingDocumentType
AccountingDocumentTypeName
Plant Plant
PlantName _Plant PlantName
StorageLocation
StorageLocationName
Batch
DebitCreditCode
DebitCreditCodeName
OrderCategory
OrderType
OrderTypeName
OrderIsRefurbishmentOrder
SerialNumberPhysicalInvtryType
PhysicalInventoryStockType
PhysicalInventoryStockTypeName
PurchasingDocumentCategory PurchasingDocumentCategory
PurchasingDocumentType PurchasingDocumentType
PurchasingDocumentTypeName _Text PurchasingDocumentTypeName
PurchasingDocumentItemCategory PurchasingDocumentItemCategory
ExternalJITCallNumber
ShipToParty
BusinessPartnerName
SubcontrgCompOfInbDelivItem
BusinessPartnerkeyMaintenanceObjectList
DeliveryDocument
DeliveryDocumentItem
SalesOrder
SalesOrderItem
MaterialDocument
MaterialDocumentItem
MaterialDocumentYear
InspectionLot
LogisticsOrder
OrderItem
HandlingUnitExternalID
PhysicalInventoryDocument
PhysicalInventoryDocumentItem
FiscalYear
PurchaseOrder
PurchaseOrderItem
PurchaseRequisition
PurchaseRequisitionItem
InternalJITCallNumber InternalJITCallNumber
JITCallItemNumber JITCallItemNumber
CompGrpNumber CompGrpNumber
SerialNumberAssignmentDate SerialNumberAssignmentDate
SerialNumberAssignmentTime SerialNumberAssignmentTime
Customer
CustomerName
Supplier
SupplierName
NumberOfSerialNumbers NumberOfSerialNumbers
SDDocumentCategory
GoodsMovementType
MovementTypeDescription
SalesOrderType
SalesDocumentTypeName
SalesOrderItemCategory
AccountingDocumentType
AccountingDocumentTypeName
Plant
PlantName
StorageLocation
StorageLocationName
Batch
DebitCreditCode
DebitCreditCodeName
OrderCategory
OrderType
OrderTypeName
OrderIsRefurbishmentOrder
SerialNumberPhysicalInvtryType
PhysicalInventoryStockType
PhysicalInventoryStockTypeName
PurchasingDocumentCategory
PurchasingDocumentType
PurchasingDocumentTypeName
PurchasingDocumentItemCategory
ExternalJITCallNumber ExternalJITCallNumber
ShipToParty ShipToParty
BusinessPartnerName _ShipToParty BusinessPartnerName
SubcontrgCompOfInbDelivItem
system_languagekeyMaintenanceObjectList
DeliveryDocument DeliveryDocument
DeliveryDocumentItem DeliveryDocumentItem
SalesOrder
SalesOrderItem
MaterialDocument
MaterialDocumentItem
MaterialDocumentYear
InspectionLot
LogisticsOrder
OrderItem
HandlingUnitExternalID
PhysicalInventoryDocument
PhysicalInventoryDocumentItem
FiscalYear
PurchaseOrder
PurchaseOrderItem
PurchaseRequisition
PurchaseRequisitionItem
InternalJITCallNumber
JITCallItemNumber
CompGrpNumber
SerialNumberAssignmentDate SerialNumberAssignmentDate
SerialNumberAssignmentTime SerialNumberAssignmentTime
Customer
CustomerName
Supplier
SupplierName
NumberOfSerialNumbers NumberOfSerialNumbers
SDDocumentCategory SDDocumentCategory
GoodsMovementType GoodsMovementType
MovementTypeDescription _MovementTypeText MovementTypeDescription
SalesOrderType
SalesDocumentTypeName
SalesOrderItemCategory
AccountingDocumentType
AccountingDocumentTypeName
Plant
PlantName
StorageLocation
StorageLocationName
Batch
DebitCreditCode
DebitCreditCodeName
OrderCategory
OrderType
OrderTypeName
OrderIsRefurbishmentOrder
SerialNumberPhysicalInvtryType
PhysicalInventoryStockType
PhysicalInventoryStockTypeName
PurchasingDocumentCategory
PurchasingDocumentType
PurchasingDocumentTypeName
PurchasingDocumentItemCategory
ExternalJITCallNumber
ShipToParty
BusinessPartnerName
SubcontrgCompOfInbDelivItem SubcontrgCompOfInbDelivItem
SrlNmbrBizDocumentObjectType
@AccessControl: { authorizationCheck: #MANDATORY,
                  personalData.blocking: #NOT_REQUIRED }

@VDM.viewType: #COMPOSITE

@ObjectModel.usageType: {
        dataClass:      #TRANSACTIONAL,
        serviceQuality: #C,
        sizeCategory:   #XL }
@ObjectModel.supportedCapabilities: [
  #SQL_DATA_SOURCE,
  #CDS_MODELING_DATA_SOURCE,
  #CDS_MODELING_ASSOCIATION_TARGET
]
@EndUserText.label: 'Maintenance Object List Collection'
@Metadata.ignorePropagatedAnnotations: true

define view entity I_MaintObjectListCollection
  as select from I_MaintObjListDeliveryDocument
  association [0..1] to I_Movement_TypeText as _MovementTypeText on  $projection.GoodsMovementType = _MovementTypeText.MovementType
                                                                 and _MovementTypeText.Language    = $session.system_language
  association [1..1] to I_Customer          as _Customer         on  $projection.Customer = _Customer.Customer
{
  key MaintenanceObjectList,
      DeliveryDocument                                     as DeliveryDocument,
      DeliveryDocumentItem                                 as DeliveryDocumentItem,
      cast( '' as abap.char( 10 ) )                        as SalesOrder,
      cast( '' as abap.numc( 6 ) )                         as SalesOrderItem,
      cast( '' as abap.char( 10 ) )                        as MaterialDocument,
      cast( '' as abap.numc( 4 ) )                         as MaterialDocumentItem,
      cast( '' as abap.numc( 4 ) )                         as MaterialDocumentYear,
      cast('' as abap.numc( 12 ) )                         as InspectionLot,
      cast( '' as abap.char( 12 ) )                        as LogisticsOrder,
      cast( '' as abap.numc( 4 ) )                         as OrderItem,
      cast( '' as abap.char( 20 ) )                        as HandlingUnitExternalID,
      cast( '' as abap.char( 10 ) )                        as PhysicalInventoryDocument,
      cast( '' as abap.numc( 3 ) )                         as PhysicalInventoryDocumentItem,
      cast( '' as abap.numc( 4 ) )                         as FiscalYear,
      cast( '' as abap.char( 10 ) )                        as PurchaseOrder,
      cast( '' as abap.numc( 5 )  )                        as PurchaseOrderItem,
      cast( '' as abap.char( 10 ) )                        as PurchaseRequisition,
      cast( '' as abap.numc( 5 ) )                         as PurchaseRequisitionItem,
      cast( '' as abap.numc( 10 ) )                        as InternalJITCallNumber,
      cast( '' as abap.numc( 4 ) )                         as JITCallItemNumber,
      cast( '' as abap.char( 60 ) )                        as CompGrpNumber,

      SerialNumberAssignmentDate,
      SerialNumberAssignmentTime,
      Customer,
      _Customer.CustomerName,
      cast( '' as abap.char( 10 ) )                        as Supplier,
      cast( '' as abap.char( 80 ) )                        as SupplierName,
      NumberOfSerialNumbers,
      SDDocumentCategory,
      GoodsMovementType,
      _MovementTypeText.MovementTypeDescription,
      cast('' as abap.char( 4 ) )                          as SalesOrderType,
      cast('' as abap.char( 20 ) )                         as SalesDocumentTypeName,
      cast('' as abap.char( 4 ) )                          as SalesOrderItemCategory,
      cast('' as abap.char( 2 ) )                          as AccountingDocumentType,
      cast('' as abap.char( 20 ) )                         as AccountingDocumentTypeName,
      cast('' as abap.char( 4 ) )                          as Plant,
      cast('' as abap.char( 30 ) )                         as PlantName,
      cast('' as abap.char( 4 ) )                          as StorageLocation,
      cast('' as abap.char( 16 ) )                         as StorageLocationName,
      cast('' as abap.char( 10) )                          as Batch,
      ''                                                   as DebitCreditCode,
      cast('' as abap.char( 60) )                          as DebitCreditCodeName,
      cast('' as abap.numc( 2 ) )                          as OrderCategory,
      cast('' as abap.char( 4 ) )                          as OrderType,
      cast('' as abap.char( 40 ) )                         as OrderTypeName,
      cast('' as rsord preserving type )                   as OrderIsRefurbishmentOrder,
      ''                                                   as SerialNumberPhysicalInvtryType,
      ''                                                   as PhysicalInventoryStockType,
      cast('' as abap.char( 20 ) )                         as PhysicalInventoryStockTypeName,
      ''                                                   as PurchasingDocumentCategory,
      cast('' as abap.char( 4 ) )                          as PurchasingDocumentType,
      cast('' as abap.char( 20 ) )                         as PurchasingDocumentTypeName,
      ''                                                   as PurchasingDocumentItemCategory,
      cast('' as abap.char( 35 ) )                         as ExternalJITCallNumber,
      cast('' as abap.char( 10 ) )                         as ShipToParty,
      cast('' as abap.char( 81 ) )                         as BusinessPartnerName,
      cast('' as abap.numc( 6 ) )                          as SubcontrgCompOfInbDelivItem,
      cast(case(SDDocumentCategory)
        when 'T' then 'RTDL'
        when '7' then 'INBD'
        when 'J' then 'OTBD'
          end as srlnmbrbizdocobjecttype preserving type ) as SrlNmbrBizDocumentObjectType

}

union all select from I_MaintObjListSalesOrder
association [1..1] to I_Customer              as _Customer on  $projection.Customer = _Customer.Customer
association [0..1] to I_SalesDocumentTypeText as _Text     on  $projection.SalesOrderType = _Text.SalesDocumentType
                                                           and _Text.Language             = $session.system_language
{
  key MaintenanceObjectList,
      cast('' as abap.char( 10 ) )                             as DeliveryDocument,
      cast('' as abap.numc( 6 ) )                              as DeliveryDocumentItem,
      SalesOrder                                               as SalesOrder,
      SalesOrderItem                                           as SalesOrderItem,
      cast( '' as abap.char( 10 ) )                            as MaterialDocument,
      cast( '' as abap.numc( 4 ) )                             as MaterialDocumentItem,
      cast( '' as abap.numc( 4 ) )                             as MaterialDocumentYear,
      cast('' as abap.numc( 12 ) )                             as InspectionLot,
      cast( '' as abap.char( 12 ) )                            as LogisticsOrder,
      cast( '' as abap.numc( 4 ) )                             as OrderItem,
      cast( '' as abap.char( 20 ) )                            as HandlingUnitExternalID,
      cast( '' as abap.char( 10 ) )                            as PhysicalInventoryDocument,
      cast( '' as abap.numc( 3 ) )                             as PhysicalInventoryDocumentItem,
      cast( '' as abap.numc( 4 ) )                             as FiscalYear,
      cast( '' as abap.char( 10 ) )                            as PurchaseOrder,
      cast( '' as abap.numc( 5 )  )                            as PurchaseOrderItem,
      cast( '' as abap.char( 10 ) )                            as PurchaseRequisition,
      cast( '' as abap.numc( 5 ) )                             as PurchaseRequisitionItem,
      cast( '' as abap.numc( 10 ) )                            as InternalJITCallNumber,
      cast( '' as abap.numc( 4 ) )                             as JITCallItemNumber,
      cast( '' as abap.char( 60 ) )                            as CompGrpNumber,

      SerialNumberAssignmentDate,
      cast( '000000' as uzeit )                                as SerialNumberAssignmentTime,
      Customer,
      _Customer.CustomerName,
      cast( '' as abap.char( 10 ) )                            as Supplier,
      cast( '' as abap.char( 80 ) )                            as SupplierName,
      NumberOfSerialNumbers,
      SDDocumentCategory,
      cast('' as abap.char( 3 ) )                              as GoodsMovementType,
      cast('' as abap.char( 20 ) )                             as MovementTypeDescription,
      SalesOrderType,
      _Text.SalesDocumentTypeName,
      SalesOrderItemCategory,
      cast('' as abap.char( 2 ) )                              as AccountingDocumentType,
      cast('' as abap.char( 20 ) )                             as AccountingDocumentTypeName,
      cast('' as abap.char( 4 ) )                              as Plant,
      cast('' as abap.char( 30 ) )                             as PlantName,
      cast('' as abap.char( 4 ) )                              as StorageLocation,
      cast('' as abap.char( 16 ) )                             as StorageLocationName,
      cast('' as abap.char( 10) )                              as Batch,
      ''                                                       as DebitCreditCode,
      cast('' as abap.char( 60) )                              as DebitCreditCodeName,
      cast('' as abap.numc( 2 ) )                              as OrderCategory,
      cast('' as abap.char( 4 ) )                              as OrderType,
      cast('' as abap.char( 40 ) )                             as OrderTypeName,
      cast('' as rsord preserving type )                       as OrderIsRefurbishmentOrder,
      ''                                                       as SerialNumberPhysicalInvtryType,
      ''                                                       as PhysicalInventoryStockType,
      cast('' as abap.char( 20 ) )                             as PhysicalInventoryStockTypeName,
      ''                                                       as PurchasingDocumentCategory,
      cast('' as abap.char( 4 ) )                              as PurchasingDocumentType,
      cast('' as abap.char( 20 ) )                             as PurchasingDocumentTypeName,
      ''                                                       as PurchasingDocumentItemCategory,
      cast('' as abap.char( 35 ) )                             as ExternalJITCallNumber,
      cast('' as abap.char( 10 ) )                             as ShipToParty,
      cast('' as abap.char( 81 ) )                             as BusinessPartnerName,
      cast('' as abap.numc( 6 ) )                              as SubcontrgCompOfInbDelivItem,
      cast('SLOR' as srlnmbrbizdocobjecttype preserving type ) as SrlNmbrBizDocumentObjectType
}

union all select from I_MaintObjListMaterialDocument
association [1..1] to I_Movement_TypeText          as _MovementTypeText on  $projection.GoodsMovementType = _MovementTypeText.MovementType
                                                                        and _MovementTypeText.Language    = $session.system_language
association [1..1] to I_AccountingDocumentTypeText as _DocumentType     on  $projection.AccountingDocumentType = _DocumentType.AccountingDocumentType
                                                                        and _DocumentType.Language             = $session.system_language
association [1..1] to I_DebitCreditCodeText        as _DebitCreditText  on  $projection.DebitCreditCode = _DebitCreditText.DebitCreditCode
                                                                        and _DebitCreditText.Language   = $session.system_language
association [1..1] to I_Customer                   as _Customer         on  $projection.Customer = _Customer.Customer
association [1..1] to I_Supplier                   as _Supplier         on  $projection.Supplier = _Supplier.Supplier
association [1..1] to I_Plant                      as _Plant            on  $projection.Plant = _Plant.Plant
association [1..1] to I_StorageLocation            as _StorageLocation  on  $projection.Plant           = _StorageLocation.Plant
                                                                        and $projection.StorageLocation = _StorageLocation.StorageLocation
{
  key MaintenanceObjectList,
      cast('' as abap.char( 10 ) )                                           as DeliveryDocument,
      cast('' as abap.numc( 6 ) )                                            as DeliveryDocumentItem,
      cast( '' as abap.char( 10 ) )                                          as SalesOrder,
      cast( '' as abap.numc( 6 ) )                                           as SalesOrderItem,
      MaterialDocument                                                       as MaterialDocument,
      MaterialDocumentItem                                                   as MaterialDocumentItem,
      MaterialDocumentYear                                                   as MaterialDocumentYear,
      cast('' as abap.numc( 12 ) )                                           as InspectionLot,
      cast( '' as abap.char( 12 ) )                                          as LogisticsOrder,
      cast( '' as abap.numc( 4 ) )                                           as OrderItem,
      cast( '' as abap.char( 20 ) )                                          as HandlingUnitExternalID,
      cast( '' as abap.char( 10 ) )                                          as PhysicalInventoryDocument,
      cast( '' as abap.numc( 3 ) )                                           as PhysicalInventoryDocumentItem,
      cast( '' as abap.numc( 4 ) )                                           as FiscalYear,
      cast( '' as abap.char( 10 ) )                                          as PurchaseOrder,
      cast( '' as abap.numc( 5 )  )                                          as PurchaseOrderItem,
      cast( '' as abap.char( 10 ) )                                          as PurchaseRequisition,
      cast( '' as abap.numc( 5 ) )                                           as PurchaseRequisitionItem,
      cast( '' as abap.numc( 10 ) )                                          as InternalJITCallNumber,
      cast( '' as abap.numc( 4 ) )                                           as JITCallItemNumber,
      cast( '' as abap.char( 60 ) )                                          as CompGrpNumber,

      SerialNumberAssignmentDate,
      SerialNumberAssignmentTime,
      Customer,
      _Customer.CustomerName,
      Supplier,
      _Supplier.SupplierName,
      NumberOfSerialNumbers,
      cast('' as abap.char( 4 ) )                                            as SDDocumentCategory,
      GoodsMovementType,
      _MovementTypeText.MovementTypeDescription,
      cast('' as abap.char( 4 ) )                                            as SalesOrderType,
      cast('' as abap.char( 20 ) )                                           as SalesDocumentTypeName,
      cast('' as abap.char( 4 ) )                                            as SalesOrderItemCategory,
      AccountingDocumentType,
      _DocumentType.AccountingDocumentTypeName,
      Plant,
      _Plant.PlantName,
      StorageLocation,
      _StorageLocation.StorageLocationName,
      Batch,
      DebitCreditCode,
      _DebitCreditText.DebitCreditCodeName,
      cast( '' as abap.numc( 2 ) )                                           as OrderCategory,
      cast('' as abap.char( 4 ) )                                            as OrderType,
      cast('' as abap.char( 40 ) )                                           as OrderTypeName,
      cast('' as rsord preserving type )                                     as OrderIsRefurbishmentOrder,
      ''                                                                     as SerialNumberPhysicalInvtryType,
      ''                                                                     as PhysicalInventoryStockType,
      cast('' as abap.char( 20 ) )                                           as PhysicalInventoryStockTypeName,
      ''                                                                     as PurchasingDocumentCategory,
      cast('' as abap.char( 4 ) )                                            as PurchasingDocumentType,
      cast('' as abap.char( 20 ) )                                           as PurchasingDocumentTypeName,
      ''                                                                     as PurchasingDocumentItemCategory,
      cast('' as abap.char( 35 ) )                                           as ExternalJITCallNumber,
      cast('' as abap.char( 10 ) )                                           as ShipToParty,
      cast('' as abap.char( 81 ) )                                           as BusinessPartnerName,
      cast( '' as abap.numc( 6 ) )                                           as SubcontrgCompOfInbDelivItem,
      cast(case(DebitCreditCode)
      when 'H' then 'GDIS'
      when 'S' then 'GDRP'  end as srlnmbrbizdocobjecttype preserving type ) as SrlNmbrBizDocumentObjectType
}

union all select from I_MaintObjListInspectionLot
{
  key MaintenanceObjectList,
      cast('' as abap.char( 10 ) )                             as DeliveryDocument,
      cast('' as abap.numc( 6 ) )                              as DeliveryDocumentItem,
      cast( '' as abap.char( 10 ) )                            as SalesOrder,
      cast( '' as abap.numc( 6 ) )                             as SalesOrderItem,
      cast( '' as abap.char( 10 ) )                            as MaterialDocument,
      cast( '' as abap.numc( 4 ) )                             as MaterialDocumentItem,
      cast( '' as abap.numc( 4 ) )                             as MaterialDocumentYear,
      InspectionLot                                            as InspectionLot,
      cast( '' as abap.char( 12 ) )                            as LogisticsOrder,
      cast( '' as abap.numc( 4 ) )                             as OrderItem,
      cast( '' as abap.char( 20 ) )                            as HandlingUnitExternalID,
      cast( '' as abap.char( 10 ) )                            as PhysicalInventoryDocument,
      cast( '' as abap.numc( 3 ) )                             as PhysicalInventoryDocumentItem,
      cast( '' as abap.numc( 4 ) )                             as FiscalYear,
      cast( '' as abap.char( 10 ) )                            as PurchaseOrder,
      cast( '' as abap.numc( 5 )  )                            as PurchaseOrderItem,
      cast( '' as abap.char( 10 ) )                            as PurchaseRequisition,
      cast( '' as abap.numc( 5 ) )                             as PurchaseRequisitionItem,
      cast( '' as abap.numc( 10 ) )                            as InternalJITCallNumber,
      cast( '' as abap.numc( 4 ) )                             as JITCallItemNumber,
      cast( '' as abap.char( 60 ) )                            as CompGrpNumber,

      SerialNumberAssignmentDate,
      SerialNumberAssignmentTime,
      cast( '' as abap.char( 10 ) )                            as Customer,
      cast( '' as abap.char( 80 ) )                            as CustomerName,
      cast( '' as abap.char( 10 ) )                            as Supplier,
      cast( '' as abap.char( 80 ) )                            as SupplierName,
      NumberOfSerialNumbers,
      cast('' as abap.char( 4 ) )                              as SDDocumentCategory,
      cast('' as abap.char( 3 ) )                              as GoodsMovementType,
      cast('' as abap.char( 20 ) )                             as MovementTypeDescription,
      cast('' as abap.char( 4 ) )                              as SalesOrderType,
      cast('' as abap.char( 20 ) )                             as SalesDocumentTypeName,
      cast('' as abap.char( 4 ) )                              as SalesOrderItemCategory,
      cast('' as abap.char( 2 ) )                              as AccountingDocumentType,
      cast('' as abap.char( 20 ) )                             as AccountingDocumentTypeName,
      cast('' as abap.char( 4 ) )                              as Plant,
      cast('' as abap.char( 30 ) )                             as PlantName,
      cast('' as abap.char( 4 ) )                              as StorageLocation,
      cast('' as abap.char( 16 ) )                             as StorageLocationName,
      cast('' as abap.char( 10) )                              as Batch,
      ''                                                       as DebitCreditCode,
      cast('' as abap.char( 60) )                              as DebitCreditCodeName,
      cast( '' as abap.numc( 2 ) )                             as OrderCategory,
      cast('' as abap.char( 4 ) )                              as OrderType,
      cast('' as abap.char( 40 ) )                             as OrderTypeName,
      cast('' as rsord preserving type )                       as OrderIsRefurbishmentOrder,
      ''                                                       as SerialNumberPhysicalInvtryType,
      ''                                                       as PhysicalInventoryStockType,
      cast('' as abap.char( 20 ) )                             as PhysicalInventoryStockTypeName,
      ''                                                       as PurchasingDocumentCategory,
      cast('' as abap.char( 4 ) )                              as PurchasingDocumentType,
      cast('' as abap.char( 20 ) )                             as PurchasingDocumentTypeName,
      ''                                                       as PurchasingDocumentItemCategory,
      cast('' as abap.char( 35 ) )                             as ExternalJITCallNumber,
      cast('' as abap.char( 10 ) )                             as ShipToParty,
      cast('' as abap.char( 81 ) )                             as BusinessPartnerName,
      cast( '' as abap.numc( 6 ) )                             as SubcontrgCompOfInbDelivItem,
      cast('ISPL' as srlnmbrbizdocobjecttype preserving type ) as SrlNmbrBizDocumentObjectType
}

union all select from I_MaintObjListLogisticsOrder
association [0..1] to I_OrderTypeText as _OrderText on  $projection.OrderType = _OrderText.OrderType
                                                    and _OrderText.Language   = $session.system_language
{
  key MaintenanceObjectList,
      cast('' as abap.char( 10 ) )                                   as DeliveryDocument,
      cast('' as abap.numc( 6 ) )                                    as DeliveryDocumentItem,
      cast( '' as abap.char( 10 ) )                                  as SalesOrder,
      cast( '' as abap.numc( 6 ) )                                   as SalesOrderItem,
      cast( '' as abap.char( 10 ) )                                  as MaterialDocument,
      cast( '' as abap.numc( 4 ) )                                   as MaterialDocumentItem,
      cast( '' as abap.numc( 4 ) )                                   as MaterialDocumentYear,
      cast('' as abap.numc( 12 ) )                                   as InspectionLot,
      LogisticsOrder                                                 as LogisticsOrder,
      OrderItem                                                      as OrderItem,
      cast( '' as abap.char( 20 ) )                                  as HandlingUnitExternalID,
      cast( '' as abap.char( 10 ) )                                  as PhysicalInventoryDocument,
      cast( '' as abap.numc( 3 ) )                                   as PhysicalInventoryDocumentItem,
      cast( '' as abap.numc( 4 ) )                                   as FiscalYear,
      cast( '' as abap.char( 10 ) )                                  as PurchaseOrder,
      cast( '' as abap.numc( 5 )  )                                  as PurchaseOrderItem,
      cast( '' as abap.char( 10 ) )                                  as PurchaseRequisition,
      cast( '' as abap.numc( 5 ) )                                   as PurchaseRequisitionItem,
      cast( '' as abap.numc( 10 ) )                                  as InternalJITCallNumber,
      cast( '' as abap.numc( 4 ) )                                   as JITCallItemNumber,
      cast( '' as abap.char( 60 ) )                                  as CompGrpNumber,

      SerialNumberAssignmentDate,
      SerialNumberAssignmentTime,
      cast( '' as abap.char( 10 ) )                                  as Customer,
      cast( '' as abap.char( 80 ) )                                  as CustomerName,
      cast( '' as abap.char( 10 ) )                                  as Supplier,
      cast( '' as abap.char( 80 ) )                                  as SupplierName,
      NumberOfSerialNumbers,
      cast('' as abap.char( 4 ) )                                    as SDDocumentCategory,
      cast('' as abap.char( 3 ) )                                    as GoodsMovementType,
      cast('' as abap.char( 20 ) )                                   as MovementTypeDescription,
      cast('' as abap.char( 4 ) )                                    as SalesOrderType,
      cast('' as abap.char( 20 ) )                                   as SalesDocumentTypeName,
      cast('' as abap.char( 4 ) )                                    as SalesOrderItemCategory,
      cast('' as abap.char( 2 ) )                                    as AccountingDocumentType,
      cast('' as abap.char( 20 ) )                                   as AccountingDocumentTypeName,
      cast('' as abap.char( 4 ) )                                    as Plant,
      cast('' as abap.char( 30 ) )                                   as PlantName,
      cast('' as abap.char( 4 ) )                                    as StorageLocation,
      cast('' as abap.char( 16 ) )                                   as StorageLocationName,
      cast('' as abap.char( 10) )                                    as Batch,
      ''                                                             as DebitCreditCode,
      cast('' as abap.char( 60) )                                    as DebitCreditCodeName,
      OrderCategory,
      OrderType,
      _OrderText.OrderTypeName,
      OrderIsRefurbishmentOrder,
      ''                                                             as SerialNumberPhysicalInvtryType,
      ''                                                             as PhysicalInventoryStockType,
      cast('' as abap.char( 20 ) )                                   as PhysicalInventoryStockTypeName,
      ''                                                             as PurchasingDocumentCategory,
      cast('' as abap.char( 4 ) )                                    as PurchasingDocumentType,
      cast('' as abap.char( 20 ) )                                   as PurchasingDocumentTypeName,
      ''                                                             as PurchasingDocumentItemCategory,
      cast('' as abap.char( 35 ) )                                   as ExternalJITCallNumber,
      cast('' as abap.char( 10 ) )                                   as ShipToParty,
      cast('' as abap.char( 81 ) )                                   as BusinessPartnerName,
      cast( '' as abap.numc( 6 ) )                                   as SubcontrgCompOfInbDelivItem,
      cast(case(OrderIsRefurbishmentOrder)
        when 'X' then 'REFB'
        else 'PROD' end as srlnmbrbizdocobjecttype preserving type ) as SrlNmbrBizDocumentObjectType
}

union all select from I_MaintObjListHandlingUnit
{
  key MaintenanceObjectList,
      cast('' as abap.char( 10 ) )                             as DeliveryDocument,
      cast('' as abap.numc( 6 ) )                              as DeliveryDocumentItem,
      cast( '' as abap.char( 10 ) )                            as SalesOrder,
      cast( '' as abap.numc( 6 ) )                             as SalesOrderItem,
      cast( '' as abap.char( 10 ) )                            as MaterialDocument,
      cast( '' as abap.numc( 4 ) )                             as MaterialDocumentItem,
      cast( '' as abap.numc( 4 ) )                             as MaterialDocumentYear,
      cast('' as abap.numc( 12 ) )                             as InspectionLot,
      cast( '' as abap.char( 12 ) )                            as LogisticsOrder,
      cast( '' as abap.numc( 4 ) )                             as OrderItem,
      HandlingUnitExternalID                                   as HandlingUnitExternalID,
      cast( '' as abap.char( 10 ) )                            as PhysicalInventoryDocument,
      cast( '' as abap.numc( 3 ) )                             as PhysicalInventoryDocumentItem,
      cast( '' as abap.numc( 4 ) )                             as FiscalYear,
      cast( '' as abap.char( 10 ) )                            as PurchaseOrder,
      cast( '' as abap.numc( 5 )  )                            as PurchaseOrderItem,
      cast( '' as abap.char( 10 ) )                            as PurchaseRequisition,
      cast( '' as abap.numc( 5 ) )                             as PurchaseRequisitionItem,
      cast( '' as abap.numc( 10 ) )                            as InternalJITCallNumber,
      cast( '' as abap.numc( 4 ) )                             as JITCallItemNumber,
      cast( '' as abap.char( 60 ) )                            as CompGrpNumber,

      SerialNumberAssignmentDate,
      SerialNumberAssignmentTime,
      cast( '' as abap.char( 10 ) )                            as Customer,
      cast( '' as abap.char( 80 ) )                            as CustomerName,
      cast( '' as abap.char( 10 ) )                            as Supplier,
      cast( '' as abap.char( 80 ) )                            as SupplierName,
      NumberOfSerialNumbers,
      cast('' as abap.char( 4 ) )                              as SDDocumentCategory,
      cast('' as abap.char( 3 ) )                              as GoodsMovementType,
      cast('' as abap.char( 20 ) )                             as MovementTypeDescription,
      cast('' as abap.char( 4 ) )                              as SalesOrderType,
      cast('' as abap.char( 20 ) )                             as SalesDocumentTypeName,
      cast('' as abap.char( 4 ) )                              as SalesOrderItemCategory,
      cast('' as abap.char( 2 ) )                              as AccountingDocumentType,
      cast('' as abap.char( 20 ) )                             as AccountingDocumentTypeName,
      cast('' as abap.char( 4 ) )                              as Plant,
      cast('' as abap.char( 30 ) )                             as PlantName,
      cast('' as abap.char( 4 ) )                              as StorageLocation,
      cast('' as abap.char( 16 ) )                             as StorageLocationName,
      cast('' as abap.char( 10) )                              as Batch,
      ''                                                       as DebitCreditCode,
      cast('' as abap.char( 60) )                              as DebitCreditCodeName,
      cast( '' as abap.numc( 2 ) )                             as OrderCategory,
      cast('' as abap.char( 4 ) )                              as OrderType,
      cast('' as abap.char( 40 ) )                             as OrderTypeName,
      cast('' as rsord preserving type )                       as OrderIsRefurbishmentOrder,
      ''                                                       as SerialNumberPhysicalInvtryType,
      ''                                                       as PhysicalInventoryStockType,
      cast('' as abap.char( 20 ) )                             as PhysicalInventoryStockTypeName,
      ''                                                       as PurchasingDocumentCategory,
      cast('' as abap.char( 4 ) )                              as PurchasingDocumentType,
      cast('' as abap.char( 20 ) )                             as PurchasingDocumentTypeName,
      ''                                                       as PurchasingDocumentItemCategory,
      cast('' as abap.char( 35 ) )                             as ExternalJITCallNumber,
      cast('' as abap.char( 10 ) )                             as ShipToParty,
      cast('' as abap.char( 81 ) )                             as BusinessPartnerName,
      cast( '' as abap.numc( 6 ) )                             as SubcontrgCompOfInbDelivItem,
      cast('HDUN' as srlnmbrbizdocobjecttype preserving type ) as SrlNmbrBizDocumentObjectType
}

union all select from I_MaintObjListPhysInventoryDoc
association [0..1] to I_PhysInvtryStockTypeText as _Text            on  $projection.PhysicalInventoryStockType = _Text.PhysicalInventoryStockType
                                                                    and _Text.Language                         = $session.system_language
association [1..1] to I_Plant                   as _Plant           on  $projection.Plant = _Plant.Plant
association [1..1] to I_StorageLocation         as _StorageLocation on  $projection.Plant           = _StorageLocation.Plant
                                                                    and $projection.StorageLocation = _StorageLocation.StorageLocation
{
  key MaintenanceObjectList,
      cast('' as abap.char( 10 ) )                             as DeliveryDocument,
      cast('' as abap.numc( 6 ) )                              as DeliveryDocumentItem,
      cast( '' as abap.char( 10 ) )                            as SalesOrder,
      cast( '' as abap.numc( 6 ) )                             as SalesOrderItem,
      cast( '' as abap.char( 10 ) )                            as MaterialDocument,
      cast( '' as abap.numc( 4 ) )                             as MaterialDocumentItem,
      cast( '' as abap.numc( 4 ) )                             as MaterialDocumentYear,
      cast('' as abap.numc( 12 ) )                             as InspectionLot,
      cast( '' as abap.char( 12 ) )                            as LogisticsOrder,
      cast( '' as abap.numc( 4 ) )                             as OrderItem,
      cast( '' as abap.char( 20 ) )                            as HandlingUnitExternalID,
      PhysicalInventoryDocument                                as PhysicalInventoryDocument,
      PhysicalInventoryDocumentItem                            as PhysicalInventoryDocumentItem,
      FiscalYear                                               as FiscalYear,
      cast( '' as abap.char( 10 ) )                            as PurchaseOrder,
      cast( '' as abap.numc( 5 )  )                            as PurchaseOrderItem,
      cast( '' as abap.char( 10 ) )                            as PurchaseRequisition,
      cast( '' as abap.numc( 5 ) )                             as PurchaseRequisitionItem,
      cast( '' as abap.numc( 10 ) )                            as InternalJITCallNumber,
      cast( '' as abap.numc( 4 ) )                             as JITCallItemNumber,
      cast( '' as abap.char( 60 ) )                            as CompGrpNumber,

      SerialNumberAssignmentDate,
      cast( '000000' as uzeit )                                as SerialNumberAssignmentTime,
      cast( '' as abap.char( 10 ) )                            as Customer,
      cast( '' as abap.char( 80 ) )                            as CustomerName,
      cast( '' as abap.char( 10 ) )                            as Supplier,
      cast( '' as abap.char( 80 ) )                            as SupplierName,
      NumberOfSerialNumbers,
      cast('' as abap.char( 4 ) )                              as SDDocumentCategory,
      cast('' as abap.char( 3 ) )                              as GoodsMovementType,
      cast('' as abap.char( 20 ) )                             as MovementTypeDescription,
      cast('' as abap.char( 4 ) )                              as SalesOrderType,
      cast('' as abap.char( 20 ) )                             as SalesDocumentTypeName,
      cast('' as abap.char( 4 ) )                              as SalesOrderItemCategory,
      cast('' as abap.char( 2 ) )                              as AccountingDocumentType,
      cast('' as abap.char( 20 ) )                             as AccountingDocumentTypeName,
      Plant,
      _Plant.PlantName,
      StorageLocation,
      _StorageLocation.StorageLocationName,
      Batch,
      ''                                                       as DebitCreditCode,
      cast('' as abap.char( 60) )                              as DebitCreditCodeName,
      cast( '' as abap.numc( 2 ) )                             as OrderCategory,
      cast('' as abap.char( 4 ) )                              as OrderType,
      cast('' as abap.char( 40 ) )                             as OrderTypeName,
      cast('' as rsord preserving type )                       as OrderIsRefurbishmentOrder,
      SerialNumberPhysicalInvtryType,
      PhysicalInventoryStockType,
      _Text.PhysicalInventoryStockTypeName,
      ''                                                       as PurchasingDocumentCategory,
      cast('' as abap.char( 4 ) )                              as PurchasingDocumentType,
      cast('' as abap.char( 20 ) )                             as PurchasingDocumentTypeName,
      ''                                                       as PurchasingDocumentItemCategory,
      cast('' as abap.char( 35 ) )                             as ExternalJITCallNumber,
      cast('' as abap.char( 10 ) )                             as ShipToParty,
      cast('' as abap.char( 81 ) )                             as BusinessPartnerName,
      cast( '' as abap.numc( 6 ) )                             as SubcontrgCompOfInbDelivItem,
      cast('PINV' as srlnmbrbizdocobjecttype preserving type ) as SrlNmbrBizDocumentObjectType
}

union all select from I_MaintObjListPurchaseOrder
association [1..1] to I_Plant                      as _Plant on  $projection.Plant = _Plant.Plant
association [0..1] to I_PurchasingDocumentTypeText as _Text  on  $projection.PurchasingDocumentType     = _Text.PurchasingDocumentType
                                                             and $projection.PurchasingDocumentCategory = _Text.PurchasingDocumentCategory
                                                             and _Text.Language                         = $session.system_language
{
  key MaintenanceObjectList,
      cast('' as abap.char( 10 ) )                             as DeliveryDocument,
      cast('' as abap.numc( 6 ) )                              as DeliveryDocumentItem,
      cast( '' as abap.char( 10 ) )                            as SalesOrder,
      cast( '' as abap.numc( 6 ) )                             as SalesOrderItem,
      cast( '' as abap.char( 10 ) )                            as MaterialDocument,
      cast( '' as abap.numc( 4 ) )                             as MaterialDocumentItem,
      cast( '' as abap.numc( 4 ) )                             as MaterialDocumentYear,
      cast('' as abap.numc( 12 ) )                             as InspectionLot,
      cast( '' as abap.char( 12 ) )                            as LogisticsOrder,
      cast( '' as abap.numc( 4 ) )                             as OrderItem,
      cast( '' as abap.char( 20 ) )                            as HandlingUnitExternalID,
      cast( '' as abap.char( 10 ) )                            as PhysicalInventoryDocument,
      cast( '' as abap.numc( 3 ) )                             as PhysicalInventoryDocumentItem,
      cast( '' as abap.numc( 4 ) )                             as FiscalYear,
      PurchaseOrder                                            as PurchaseOrder,
      PurchaseOrderItem                                        as PurchaseOrderItem,
      cast( '' as abap.char( 10 ) )                            as PurchaseRequisition,
      cast( '' as abap.numc( 5 ) )                             as PurchaseRequisitionItem,
      cast( '' as abap.numc( 10 ) )                            as InternalJITCallNumber,
      cast( '' as abap.numc( 4 ) )                             as JITCallItemNumber,
      cast( '' as abap.char( 60 ) )                            as CompGrpNumber,

      SerialNumberAssignmentDate,
      cast( '000000' as uzeit )                                as SerialNumberAssignmentTime,
      cast( '' as abap.char( 10 ) )                            as Customer,
      cast( '' as abap.char( 80 ) )                            as CustomerName,
      cast( '' as abap.char( 10 ) )                            as Supplier,
      cast( '' as abap.char( 80 ) )                            as SupplierName,
      NumberOfSerialNumbers,
      cast('' as abap.char( 4 ) )                              as SDDocumentCategory,
      cast('' as abap.char( 3 ) )                              as GoodsMovementType,
      cast('' as abap.char( 20 ) )                             as MovementTypeDescription,
      cast('' as abap.char( 4 ) )                              as SalesOrderType,
      cast('' as abap.char( 20 ) )                             as SalesDocumentTypeName,
      cast('' as abap.char( 4 ) )                              as SalesOrderItemCategory,
      cast('' as abap.char( 2 ) )                              as AccountingDocumentType,
      cast('' as abap.char( 20 ) )                             as AccountingDocumentTypeName,
      Plant,
      _Plant.PlantName,
      cast('' as abap.char( 4 ) )                              as StorageLocation,
      cast('' as abap.char( 16 ) )                             as StorageLocationName,
      cast('' as abap.char( 10) )                              as Batch,
      ''                                                       as DebitCreditCode,
      cast('' as abap.char( 60) )                              as DebitCreditCodeName,
      cast( '' as abap.numc( 2 ) )                             as OrderCategory,
      cast('' as abap.char( 4 ) )                              as OrderType,
      cast('' as abap.char( 40 ) )                             as OrderTypeName,
      cast('' as rsord preserving type )                       as OrderIsRefurbishmentOrder,
      ''                                                       as SerialNumberPhysicalInvtryType,
      ''                                                       as PhysicalInventoryStockType,
      cast('' as abap.char( 20 ) )                             as PhysicalInventoryStockTypeName,
      PurchasingDocumentCategory,
      PurchasingDocumentType,
      _Text.PurchasingDocumentTypeName,
      PurchasingDocumentItemCategory,
      cast('' as abap.char( 35 ) )                             as ExternalJITCallNumber,
      cast('' as abap.char( 10 ) )                             as ShipToParty,
      cast('' as abap.char( 81 ) )                             as BusinessPartnerName,
      cast( '' as abap.numc( 6 ) )                             as SubcontrgCompOfInbDelivItem,
      cast('PUOD' as srlnmbrbizdocobjecttype preserving type ) as SrlNmbrBizDocumentObjectType
}

union all select from I_MaintObjListPurchaseReqn
association [1..1] to I_Plant                      as _Plant on  $projection.Plant = _Plant.Plant
association [0..1] to I_PurchasingDocumentTypeText as _Text  on  $projection.PurchasingDocumentType     = _Text.PurchasingDocumentType
                                                             and $projection.PurchasingDocumentCategory = _Text.PurchasingDocumentCategory
                                                             and _Text.Language                         = $session.system_language
{
  key MaintenanceObjectList,
      cast('' as abap.char( 10 ) )                             as DeliveryDocument,
      cast('' as abap.numc( 6 ) )                              as DeliveryDocumentItem,
      cast( '' as abap.char( 10 ) )                            as SalesOrder,
      cast( '' as abap.numc( 6 ) )                             as SalesOrderItem,
      cast( '' as abap.char( 10 ) )                            as MaterialDocument,
      cast( '' as abap.numc( 4 ) )                             as MaterialDocumentItem,
      cast( '' as abap.numc( 4 ) )                             as MaterialDocumentYear,
      cast('' as abap.numc( 12 ) )                             as InspectionLot,
      cast( '' as abap.char( 12 ) )                            as LogisticsOrder,
      cast( '' as abap.numc( 4 ) )                             as OrderItem,
      cast( '' as abap.char( 20 ) )                            as HandlingUnitExternalID,
      cast( '' as abap.char( 10 ) )                            as PhysicalInventoryDocument,
      cast( '' as abap.numc( 3 ) )                             as PhysicalInventoryDocumentItem,
      cast( '' as abap.numc( 4 ) )                             as FiscalYear,
      cast( '' as abap.char( 10 ) )                            as PurchaseOrder,
      cast( '' as abap.numc( 5 )  )                            as PurchaseOrderItem,
      PurchaseRequisition                                      as PurchaseRequisition,
      PurchaseRequisitionItem                                  as PurchaseRequisitionItem,
      cast( '' as abap.numc( 10 ) )                            as InternalJITCallNumber,
      cast( '' as abap.numc( 4 ) )                             as JITCallItemNumber,
      cast( '' as abap.char( 60 ) )                            as CompGrpNumber,

      SerialNumberAssignmentDate,
      cast( '000000' as uzeit )                                as SerialNumberAssignmentTime,
      cast( '' as abap.char( 10 ) )                            as Customer,
      cast( '' as abap.char( 80 ) )                            as CustomerName,
      cast( '' as abap.char( 10 ) )                            as Supplier,
      cast( '' as abap.char( 80 ) )                            as SupplierName,
      NumberOfSerialNumbers,
      cast('' as abap.char( 4 ) )                              as SDDocumentCategory,
      cast('' as abap.char( 3 ) )                              as GoodsMovementType,
      cast('' as abap.char( 20 ) )                             as MovementTypeDescription,
      cast('' as abap.char( 4 ) )                              as SalesOrderType,
      cast('' as abap.char( 20 ) )                             as SalesDocumentTypeName,
      cast('' as abap.char( 4 ) )                              as SalesOrderItemCategory,
      cast('' as abap.char( 2 ) )                              as AccountingDocumentType,
      cast('' as abap.char( 20 ) )                             as AccountingDocumentTypeName,
      Plant,
      _Plant.PlantName,
      cast('' as abap.char( 4 ) )                              as StorageLocation,
      cast('' as abap.char( 16 ) )                             as StorageLocationName,
      cast('' as abap.char( 10) )                              as Batch,
      ''                                                       as DebitCreditCode,
      cast('' as abap.char( 60) )                              as DebitCreditCodeName,
      cast('' as abap.numc( 2 ) )                              as OrderCategory,
      cast('' as abap.char( 4 ) )                              as OrderType,
      cast('' as abap.char( 40 ) )                             as OrderTypeName,
      cast('' as rsord preserving type )                       as OrderIsRefurbishmentOrder,
      ''                                                       as SerialNumberPhysicalInvtryType,
      ''                                                       as PhysicalInventoryStockType,
      cast('' as abap.char( 20 ) )                             as PhysicalInventoryStockTypeName,
      PurchasingDocumentCategory,
      PurchasingDocumentType,
      _Text.PurchasingDocumentTypeName,
      PurchasingDocumentItemCategory,
      cast('' as abap.char( 35 ) )                             as ExternalJITCallNumber,
      cast('' as abap.char( 10 ) )                             as ShipToParty,
      cast('' as abap.char( 81 ) )                             as BusinessPartnerName,
      cast( '' as abap.numc( 6 ) )                             as SubcontrgCompOfInbDelivItem,
      cast('PRRQ' as srlnmbrbizdocobjecttype preserving type ) as SrlNmbrBizDocumentObjectType
}

union all select from I_MaintObjListJITCall
association [0..1] to I_BusinessPartner as _ShipToParty on $projection.ShipToParty = _ShipToParty.BusinessPartner
{
  key MaintenanceObjectList,
      cast('' as abap.char( 10 ) )                              as DeliveryDocument,
      cast('' as abap.numc( 6 ) )                               as DeliveryDocumentItem,
      cast( '' as abap.char( 10 ) )                             as SalesOrder,
      cast( '' as abap.numc( 6 ) )                              as SalesOrderItem,
      cast( '' as abap.char( 10 ) )                             as MaterialDocument,
      cast( '' as abap.numc( 4 ) )                              as MaterialDocumentItem,
      cast( '' as abap.numc( 4 ) )                              as MaterialDocumentYear,
      cast('' as abap.numc( 12 ) )                              as InspectionLot,
      cast( '' as abap.char( 12 ) )                             as LogisticsOrder,
      cast( '' as abap.numc( 4 ) )                              as OrderItem,
      cast( '' as abap.char( 20 ) )                             as HandlingUnitExternalID,
      cast( '' as abap.char( 10 ) )                             as PhysicalInventoryDocument,
      cast( '' as abap.numc( 3 ) )                              as PhysicalInventoryDocumentItem,
      cast( '' as abap.numc( 4 ) )                              as FiscalYear,
      cast( '' as abap.char( 10 ) )                             as PurchaseOrder,
      cast( '' as abap.numc( 5 )  )                             as PurchaseOrderItem,
      cast( '' as abap.char( 10 ) )                             as PurchaseRequisition,
      cast( '' as abap.numc( 5 ) )                              as PurchaseRequisitionItem,
      InternalJITCallNumber                                     as InternalJITCallNumber,
      JITCallItemNumber                                         as JITCallItemNumber,
      CompGrpNumber                                             as CompGrpNumber,

      SerialNumberAssignmentDate,
      SerialNumberAssignmentTime,
      cast( '' as abap.char( 10 ) )                             as Customer,
      cast( '' as abap.char( 80 ) )                             as CustomerName,
      cast( '' as abap.char( 10 ) )                             as Supplier,
      cast( '' as abap.char( 80 ) )                             as SupplierName,
      NumberOfSerialNumbers,
      cast('' as abap.char( 4 ) )                               as SDDocumentCategory,
      cast('' as abap.char( 3 ) )                               as GoodsMovementType,
      cast('' as abap.char( 20 ) )                              as MovementTypeDescription,
      cast('' as abap.char( 4 ) )                               as SalesOrderType,
      cast('' as abap.char( 20 ) )                              as SalesDocumentTypeName,
      cast('' as abap.char( 4 ) )                               as SalesOrderItemCategory,
      cast('' as abap.char( 2 ) )                               as AccountingDocumentType,
      cast('' as abap.char( 20 ) )                              as AccountingDocumentTypeName,
      cast('' as abap.char( 4 ) )                               as Plant,
      cast('' as abap.char( 30 ) )                              as PlantName,
      cast('' as abap.char( 4 ) )                               as StorageLocation,
      cast('' as abap.char( 16 ) )                              as StorageLocationName,
      cast('' as abap.char( 10) )                               as Batch,
      ''                                                        as DebitCreditCode,
      cast('' as abap.char( 60) )                               as DebitCreditCodeName,
      cast( '' as abap.numc( 2 ) )                              as OrderCategory,
      cast('' as abap.char( 4 ) )                               as OrderType,
      cast('' as abap.char( 40 ) )                              as OrderTypeName,
      cast('' as rsord preserving type )                        as OrderIsRefurbishmentOrder,
      ''                                                        as SerialNumberPhysicalInvtryType,
      ''                                                        as PhysicalInventoryStockType,
      cast('' as abap.char( 20 ) )                              as PhysicalInventoryStockTypeName,
      ''                                                        as PurchasingDocumentCategory,
      cast('' as abap.char( 4 ) )                               as PurchasingDocumentType,
      cast('' as abap.char( 20 ) )                              as PurchasingDocumentTypeName,
      ''                                                        as PurchasingDocumentItemCategory,
      ExternalJITCallNumber,
      ShipToParty,
      _ShipToParty.BusinessPartnerName,
      cast( '' as abap.numc( 6 ) )                              as SubcontrgCompOfInbDelivItem,
      cast('JITC' as srlnmbrbizdocobjecttype preserving type  ) as SrlNmbrBizDocumentObjectType
}

union all select from I_MaintObjListInbDelivItmComp
association [0..1] to I_Movement_TypeText as _MovementTypeText on  $projection.GoodsMovementType = _MovementTypeText.MovementType
                                                               and _MovementTypeText.Language    = $session.system_language
{
  key MaintenanceObjectList,
      DeliveryDocument                                         as DeliveryDocument,
      DeliveryDocumentItem                                     as DeliveryDocumentItem,
      cast( '' as abap.char( 10 ) )                            as SalesOrder,
      cast( '' as abap.numc( 6 ) )                             as SalesOrderItem,
      cast( '' as abap.char( 10 ) )                            as MaterialDocument,
      cast( '' as abap.numc( 4 ) )                             as MaterialDocumentItem,
      cast( '' as abap.numc( 4 ) )                             as MaterialDocumentYear,
      cast('' as abap.numc( 12 ) )                             as InspectionLot,
      cast( '' as abap.char( 12 ) )                            as LogisticsOrder,
      cast( '' as abap.numc( 4 ) )                             as OrderItem,
      cast( '' as abap.char( 20 ) )                            as HandlingUnitExternalID,
      cast( '' as abap.char( 10 ) )                            as PhysicalInventoryDocument,
      cast( '' as abap.numc( 3 ) )                             as PhysicalInventoryDocumentItem,
      cast( '' as abap.numc( 4 ) )                             as FiscalYear,
      cast( '' as abap.char( 10 ) )                            as PurchaseOrder,
      cast( '' as abap.numc( 5 )  )                            as PurchaseOrderItem,
      cast( '' as abap.char( 10 ) )                            as PurchaseRequisition,
      cast( '' as abap.numc( 5 ) )                             as PurchaseRequisitionItem,
      cast( '' as abap.numc( 10 ) )                            as InternalJITCallNumber,
      cast( '' as abap.numc( 4 ) )                             as JITCallItemNumber,
      cast( '' as abap.char( 60 ) )                            as CompGrpNumber,

      SerialNumberAssignmentDate,
      SerialNumberAssignmentTime,
      cast( '' as abap.char( 10 ) )                            as Customer,
      cast( '' as abap.char( 80 ) )                            as CustomerName,
      cast( '' as abap.char( 10 ) )                            as Supplier,
      cast( '' as abap.char( 80 ) )                            as SupplierName,
      NumberOfSerialNumbers,
      SDDocumentCategory,
      GoodsMovementType,
      _MovementTypeText.MovementTypeDescription,
      cast('' as abap.char( 4 ) )                              as SalesOrderType,
      cast('' as abap.char( 20 ) )                             as SalesDocumentTypeName,
      cast('' as abap.char( 4 ) )                              as SalesOrderItemCategory,
      cast('' as abap.char( 2 ) )                              as AccountingDocumentType,
      cast('' as abap.char( 20 ) )                             as AccountingDocumentTypeName,
      cast('' as abap.char( 4 ) )                              as Plant,
      cast('' as abap.char( 30 ) )                             as PlantName,
      cast('' as abap.char( 4 ) )                              as StorageLocation,
      cast('' as abap.char( 16 ) )                             as StorageLocationName,
      cast('' as abap.char( 10) )                              as Batch,
      ''                                                       as DebitCreditCode,
      cast('' as abap.char( 60) )                              as DebitCreditCodeName,
      cast( '' as abap.numc( 2 ) )                             as OrderCategory,
      cast('' as abap.char( 4 ) )                              as OrderType,
      cast('' as abap.char( 40 ) )                             as OrderTypeName,
      cast('' as rsord preserving type )                       as OrderIsRefurbishmentOrder,
      ''                                                       as SerialNumberPhysicalInvtryType,
      ''                                                       as PhysicalInventoryStockType,
      cast('' as abap.char( 20 ) )                             as PhysicalInventoryStockTypeName,
      ''                                                       as PurchasingDocumentCategory,
      cast('' as abap.char( 4 ) )                              as PurchasingDocumentType,
      cast('' as abap.char( 20 ) )                             as PurchasingDocumentTypeName,
      ''                                                       as PurchasingDocumentItemCategory,
      cast('' as abap.char( 35 ) )                             as ExternalJITCallNumber,
      cast('' as abap.char( 10 ) )                             as ShipToParty,
      cast('' as abap.char( 81 ) )                             as BusinessPartnerName,
      SubcontrgCompOfInbDelivItem,
      cast('IBSC' as srlnmbrbizdocobjecttype preserving type ) as SrlNmbrBizDocumentObjectType
}