A_ReturnsInspectionItem_2

DDL: A_RETURNSINSPECTIONITEM_2 Type: view_entity CONSUMPTION
28 Fields 1 Data Sources 1 OData Services

Returns Inspection Item

A_ReturnsInspectionItem_2 is a Consumption CDS View that provides data about "Returns Inspection Item" in SAP S/4HANA. It reads from 1 data source (R_ReturnsInspectionItemTP_2) and exposes 28 fields with key fields ReturnsInspection, ReturnsInspectionItem. It is exposed through 1 OData service (API_RETURNSINSPECTION_2).

Data Sources (1)

SourceAliasJoin Type
R_ReturnsInspectionItemTP_2 R_ReturnsInspectionItemTP_2 projection

Annotations (10)

NameValueLevelField
EndUserText.label Returns Inspection Item view
AccessControl.authorizationCheck #CHECK view
OData.entityType.name ReturnsInspectionItem_Type view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.modelingPattern #TRANSACTIONAL_INTERFACE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view

OData Services (1)

ServiceBindingVersionContractRelease
API_RETURNSINSPECTION_2 API_RETURNSINSPECTION_2 V4 C2 C1

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY ReturnsInspection ReturnsInspection
KEY ReturnsInspectionItem ReturnsInspectionItem
ReturnsDelivery ReturnsDelivery
ReturnsDeliveryItem ReturnsDeliveryItem
ReturnsInspectionItemStatus ReturnsInspectionItemStatus
RetsInspItemStsTxt RetsInspItemStsTxt
RetsFllwUpActyItmSts RetsFllwUpActyItmSts
RetsFllwUpActyItmStsTxt RetsFllwUpActyItmStsTxt
Product Product Product Sold
InspectionCode InspectionCode
ReturnsInspectionComment ReturnsInspectionComment
InspectionDate InspectionDate
ProductInspectorName ProductInspectorName
InspectionLeadingUnitCode InspectionLeadingUnitCode
InspectedProductQtyInBaseUnit InspectedProductQtyInBaseUnit
BaseUnit BaseUnit Unit of Measure
ReturnsFollowUpActivity ReturnsFollowUpActivity
InspectedProductQtyInSalesUnit InspectedProductQtyInSalesUnit
SalesUnit SalesUnit Unit
InspectedProductQuantity InspectedProductQuantity
InspectedProductUnit InspectedProductUnit
TargetPlant TargetPlant
TargetStorageLocation TargetStorageLocation Location
TargetStockType TargetStockType
TgtProdForGdsMvtPostg TgtProdForGdsMvtPostg
Supplier Supplier Supplier
RetsFllwUpActyRespPersnName RetsFllwUpActyRespPersnName
RetsFllwUpActyReleasedDate RetsFllwUpActyReleasedDate

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_ReturnsInspectionItem_2.
-- 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_ReturnsInspectionItem_2 AS
SELECT
  ReturnsInspection,
  ReturnsInspectionItem,
  ReturnsDelivery,
  ReturnsDeliveryItem,
  ReturnsInspectionItemStatus,
  RetsInspItemStsTxt,
  RetsFllwUpActyItmSts,
  RetsFllwUpActyItmStsTxt,
  Product,
  InspectionCode,
  ReturnsInspectionComment,
  InspectionDate,
  ProductInspectorName,
  InspectionLeadingUnitCode,
  InspectedProductQtyInBaseUnit,
  BaseUnit,
  ReturnsFollowUpActivity,
  InspectedProductQtyInSalesUnit,
  SalesUnit,
  InspectedProductQuantity,
  InspectedProductUnit,
  TargetPlant,
  TargetStorageLocation,
  TargetStockType,
  TgtProdForGdsMvtPostg,
  Supplier,
  RetsFllwUpActyRespPersnName,
  RetsFllwUpActyReleasedDate
FROM R_ReturnsInspectionItemTP_2
;

Learn More