A_MaintOrderInspectionLot

DDL: A_MAINTORDERINSPECTIONLOT Type: view_entity CONSUMPTION Package: EAM_IDMS
61 Fields 1 Data Sources 1 Associations 1 OData Services

Checklist information of work order

A_MaintOrderInspectionLot is a Consumption CDS View that provides data about "Checklist information of work order" in SAP S/4HANA. It reads from 1 data source (I_MaintOrderInspectionLot) and exposes 61 fields with key fields MaintenanceOrder, InspectionLot. It has 1 association to related views. It is exposed through 1 OData service (API_MAINTORDERINSPECTIONLOT). Part of development package EAM_IDMS.

Data Sources (1)

SourceAliasJoin Type
I_MaintOrderInspectionLot _MaintOrderInspectionLot from

Associations (1)

CardinalityTargetAliasCondition
[0..1] A_InspLotUsageDecision _UsageDecision $projection.InspectionLot = _UsageDecision.InspectionLot

Annotations (10)

NameValueLevelField
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Checklist information of work order view
Feature SW:EAM_SFWS_CHECKLIST view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
OData.entityType.name MaintOrderInspectionLot_Type view

OData Services (1)

ServiceBindingVersionContractRelease
API_MAINTORDERINSPECTIONLOT API_MAINTORDERINSPLOT V2 C2 NOT_RELEASED

Fields (61)

KeyFieldSource TableSource FieldDescription
KEY MaintenanceOrder MaintenanceOrder Order
KEY InspectionLot I_MaintOrderInspectionLot InspectionLot Inspection Lot
MaintenanceOrderType MaintenanceOrderType Order Type
MaintenancePlanningPlant MaintenancePlanningPlant Planning Plant
MaintenancePlannerGroup MaintenancePlannerGroup Planner Group
MaintObjectLocAcctAssgmtNmbr MaintObjectLocAcctAssgmtNmbr Loc/AccAssmt
_LocationAccountAssignment _LocationAccountAssignment
Plant Plant Valuation Area
InspectionLotType InspectionLotType Inspection Type
InspectionLotOrigin InspectionLotOrigin
StatusObject StatusObject Status Object
StatusObjectCategory StatusObjectCategory
StatusProfile StatusProfile Status Profile
GoodsReceiptIsMovedToBlkdStock GoodsReceiptIsMovedToBlkdStock
InspectionLotIsSkipped InspectionLotIsSkipped
InspLotCreatedOnLocalDate InspLotCreatedOnLocalDate
InspLotCreatedOnLocalTime InspLotCreatedOnLocalTime
InspectionLotCreatedBy InspectionLotCreatedBy
InspectionLotCreatedOn InspectionLotCreatedOn
InspectionLotCreatedOnTime InspectionLotCreatedOnTime
InspectionLotChangedBy InspectionLotChangedBy
InspectionLotChangeDate InspectionLotChangeDate
InspectionLotChangeTime InspectionLotChangeTime
ChangedDateTime ChangedDateTime Time Stamp
InspectionLotStartDate InspectionLotStartDate
InspectionLotStartTime InspectionLotStartTime
InspectionLotEndDate InspectionLotEndDate
InspectionLotEndTime InspectionLotEndTime
BillOfOperationsType BillOfOperationsType Task List Type
BillOfOperationsGroup BillOfOperationsGroup Group
BillOfOperationsUsage BillOfOperationsUsage
BillOfOperationsVariant BillOfOperationsVariant Group Counter
BillOfOperationsChangeStateID BillOfOperationsChangeStateID
InspLotSelBillOfOperationsUsge InspLotSelBillOfOperationsUsge
InspLotSelectionValidFromDate InspLotSelectionValidFromDate
ManufacturingOrder ManufacturingOrder Order
OrderInternalBillOfOperations OrderInternalBillOfOperations Order Internal Bill of Operations
InspLotSelectionCustomer InspLotSelectionCustomer
Customer Customer Sold-to Party
InspLotSelectionSupplier InspLotSelectionSupplier
Supplier Supplier Supplier
Language Language Report Text Language
InspectionLotText InspectionLotText
InspectionLotObjectText InspectionLotObjectText
InspLotNmbrAddlRecordedCharc InspLotNmbrAddlRecordedCharc
InspLotNmbrOpenShortTermCharc InspLotNmbrOpenShortTermCharc
InspLotNmbrOpenLongTermCharc InspLotNmbrOpenLongTermCharc
InspLotUsageDecisionTool InspLotUsageDecisionTool
InspectionLotHasUsageDecision InspectionLotHasUsageDecision
MaintBusinessSubobjectType MaintBusinessSubobjectType
MaintenanceBusinessSubobject MaintenanceBusinessSubobject
MaintChecklistTemplateType MaintChecklistTemplateType
MaintenanceChecklistTemplate MaintenanceChecklistTemplate
Equipment Equipment Equipment check
FunctionalLocation Object ID
MaintChklstAddlInformationText MaintChklstAddlInformationText
MainChecklistIsDeactivated MainChecklistIsDeactivated
MaintenanceBusinessObjectType MaintenanceBusinessObjectType
MaintenanceChecklistType MaintenanceChecklistType
AuthorizationGroup AuthorizationGroup AuthorizGroup
_UsageDecision _UsageDecision

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view A_MaintOrderInspectionLot.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW A_MaintOrderInspectionLot AS
SELECT
  MaintenanceOrder,
  _MaintOrderInspectionLot.InspectionLot AS InspectionLot,
  MaintenanceOrderType,
  MaintenancePlanningPlant,
  MaintenancePlannerGroup,
  MaintObjectLocAcctAssgmtNmbr,
  Plant,
  InspectionLotType,
  InspectionLotOrigin,
  StatusObject,
  StatusObjectCategory,
  StatusProfile,
  GoodsReceiptIsMovedToBlkdStock,
  InspectionLotIsSkipped,
  InspLotCreatedOnLocalDate,
  InspLotCreatedOnLocalTime,
  InspectionLotCreatedBy,
  InspectionLotCreatedOn,
  InspectionLotCreatedOnTime,
  InspectionLotChangedBy,
  InspectionLotChangeDate,
  InspectionLotChangeTime,
  ChangedDateTime,
  InspectionLotStartDate,
  InspectionLotStartTime,
  InspectionLotEndDate,
  InspectionLotEndTime,
  BillOfOperationsType,
  BillOfOperationsGroup,
  BillOfOperationsUsage,
  BillOfOperationsVariant,
  BillOfOperationsChangeStateID,
  InspLotSelBillOfOperationsUsge,
  InspLotSelectionValidFromDate,
  ManufacturingOrder,
  OrderInternalBillOfOperations,
  InspLotSelectionCustomer,
  Customer,
  InspLotSelectionSupplier,
  Supplier,
  Language,
  InspectionLotText,
  InspectionLotObjectText,
  InspLotNmbrAddlRecordedCharc,
  InspLotNmbrOpenShortTermCharc,
  InspLotNmbrOpenLongTermCharc,
  InspLotUsageDecisionTool,
  InspectionLotHasUsageDecision,
  MaintBusinessSubobjectType,
  MaintenanceBusinessSubobject,
  MaintChecklistTemplateType,
  MaintenanceChecklistTemplate,
  Equipment,
  cast ( FunctionalLocation as vdm_eam_tplnr ) AS FunctionalLocation,
  MaintChklstAddlInformationText,
  MainChecklistIsDeactivated,
  MaintenanceBusinessObjectType,
  MaintenanceChecklistType,
  AuthorizationGroup
FROM I_MaintOrderInspectionLot AS _MaintOrderInspectionLot
LEFT OUTER JOIN A_InspLotUsageDecision AS _UsageDecision ON InspectionLot = _UsageDecision.InspectionLot  -- association [0..1]
;

Learn More