I_RevSupProtChkReq

DDL: I_REVSUPPROTCHKREQ Type: view_entity BASIC Package: ATP_SUP_RACR
10 Fields 1 Data Sources 1 Associations

Review Supply Protection Check Request

I_RevSupProtChkReq is a Basic CDS View that provides data about "Review Supply Protection Check Request" in SAP S/4HANA. It reads from 1 data source (sup_chk_req) and exposes 10 fields with key field SupProtReviewRequestUUID. It has 1 association to related views. Part of development package ATP_SUP_RACR.

Data Sources (1)

SourceAliasJoin Type
sup_chk_req sup_chk_req from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_ATPCheck _ATPCheck $projection.ATPCheckUUID = _ATPCheck.ATPCheckUUID

Annotations (8)

NameValueLevelField
EndUserText.label Review Supply Protection Check Request view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Metadata.ignorePropagatedAnnotations true view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY SupProtReviewRequestUUID uuid Waste Partner UUID
ATPCheckUUID atpcheckuuid Check ID
ATPProcdRqmtBasicMethodReqUUID atpprocdrqmtbasicmethodrequuid Basic Method Request
SupProtAssignedDocumentItem documentitemid DocumentItem ID
SupplyProtectionDocumentType documenttype Order Type
SupProtAssignedDocument documentid Routing slip doc. ID
SupProtRestrictedQuantity restrictedquantity Restricted Quantity
UnitOfMeasure unitofmeasure Unit Protected Qty
_ATPCheck _ATPCheck
_ATPProcdRqmtBasicMethRequest _ATPProcdRqmtBasicMethRequest

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 I_RevSupProtChkReq.
-- 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 I_RevSupProtChkReq AS
SELECT
  uuid AS SupProtReviewRequestUUID,
  ATPCheckUUID,
  ATPProcdRqmtBasicMethodReqUUID,
  documentitemid AS SupProtAssignedDocumentItem,
  documenttype AS SupplyProtectionDocumentType,
  documentid AS SupProtAssignedDocument,
  restrictedquantity AS SupProtRestrictedQuantity,
  UnitOfMeasure
FROM sup_chk_req
LEFT OUTER JOIN I_ATPCheck AS _ATPCheck ON ATPCheckUUID = _ATPCheck.ATPCheckUUID  -- association [1..1]
;

Learn More