I_MaintObjectListCollection
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)
| Source | Alias | Join 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)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [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)
| Name | Value | Level | Field |
|---|---|---|---|
| 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)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| 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
}
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA