C_RevSupProtChkReqTP

DDL: C_REVSUPPROTCHKREQTP Type: view_entity CONSUMPTION
20 Fields 1 Data Sources

Review Supply Protection Check Request

C_RevSupProtChkReqTP is a Consumption CDS View that provides data about "Review Supply Protection Check Request" in SAP S/4HANA. It reads from 1 data source (R_RevSupProtChkReqTP) and exposes 20 fields with key field SupProtReviewRequestUUID.

Data Sources (1)

SourceAliasJoin Type
R_RevSupProtChkReqTP R_RevSupProtChkReqTP projection

Annotations (7)

NameValueLevelField
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.allowExtensions true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
EndUserText.label Review Supply Protection Check Request view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY SupProtReviewRequestUUID SupProtReviewRequestUUID
ATPCheckUUID ATPCheckUUID Check ID
ATPProcdRqmtBasicMethodReqUUID ATPProcdRqmtBasicMethodReqUUID Basic Method Request
SupplyProtectionDocumentType SupplyProtectionDocumentType
SupProtAssignedDocumentItem SupProtAssignedDocumentItem
SupProtAssignedDocument SupProtAssignedDocument
SupProtRestrictedQuantity SupProtRestrictedQuantity Restricted Quantity
RequestedQuantityInBaseUnit _ATPProcdRqmtBasicMethReqTP RequestedQuantityInBaseUnit Requested Qty
UnitOfMeasure UnitOfMeasure Unit Protected Qty
RequestedDeliveryUTCDateTime
RequestedDeliveryTimeZone
ReqdProdAvailabilityUTCDateTme
ReqdProdAvailabilityTimeZone _ATPProcdRqmtBasicMethReqTP ReqdProdAvailabilityTimeZone Time Zone
Material _ATPProcdRqmtBasicMethReqTP Product Product Sold
ProductNameasMaterialNamelocalized
Plant _ATPProcdRqmtBasicMethReqTP SupplyingPlant Supplying Plant
PlantName
StorageLocation _ATPProcdRqmtBasicMethReqTP SupplyingStorageLocation Location
StorageLocationName
_ATPCheckTPredirectedtoC_RACRCheckTP

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 C_RevSupProtChkReqTP.
-- 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 C_RevSupProtChkReqTP AS
SELECT
  SupProtReviewRequestUUID,
  ATPCheckUUID,
  ATPProcdRqmtBasicMethodReqUUID,
  SupplyProtectionDocumentType,
  SupProtAssignedDocumentItem,
  SupProtAssignedDocument,
  SupProtRestrictedQuantity,
  _ATPProcdRqmtBasicMethReqTP.RequestedQuantityInBaseUnit AS RequestedQuantityInBaseUnit,
  UnitOfMeasure,
  cast(_ATPProcdRqmtBasicMethReqTP._ProcessedRequirement._SelectedRequirement.RequestedDeliveryUTCDateTime as BT_RequestedDeliveryUTCDateTme preserving type) AS RequestedDeliveryUTCDateTime,
  _ATPProcdRqmtBasicMethReqTP._ProcessedRequirement._SelectedRequirement.RequestedDeliveryTimeZone AS RequestedDeliveryTimeZone,
  cast(_ATPProcdRqmtBasicMethReqTP.ReqdProdAvailabilityUTCDateTme as BT_ReqdProdAvailyUTCDateTime preserving type) AS ReqdProdAvailabilityUTCDateTme,
  _ATPProcdRqmtBasicMethReqTP.ReqdProdAvailabilityTimeZone AS ReqdProdAvailabilityTimeZone,
  _ATPProcdRqmtBasicMethReqTP.Product AS Material,
  _ATPProcdRqmtBasicMethReqTP._Product._Text.ProductName as MaterialName : localized AS ProductNameasMaterialNamelocalized,
  _ATPProcdRqmtBasicMethReqTP.SupplyingPlant AS Plant,
  _ATPProcdRqmtBasicMethReqTP._SupplyingPlant.PlantName AS PlantName,
  _ATPProcdRqmtBasicMethReqTP.SupplyingStorageLocation AS StorageLocation,
  _ATPProcdRqmtBasicMethReqTP._SupplyingStorageLocation.StorageLocationName AS StorageLocationName
FROM R_RevSupProtChkReqTP
;

Learn More