@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
}