R_PPS_PurReqItemDelivAddressD

DDL: R_PPS_PURREQITEMDELIVADDRESSD Type: view_entity BASIC
21 Fields 1 Data Sources

Purchase Request item Del Addr - Draft

R_PPS_PurReqItemDelivAddressD is a Basic CDS View that provides data about "Purchase Request item Del Addr - Draft" in SAP S/4HANA. It reads from 1 data source (pps_pritm_dlad_d) and exposes 21 fields with key field PPSPurchaseRequestItemUUID.

Data Sources (1)

SourceAliasJoin Type
pps_pritm_dlad_d pps_pritm_dlad_d from

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Purchase Request item Del Addr - Draft view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
Metadata.ignorePropagatedAnnotations true view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
Feature SW:PPS_NG_MVP2025 view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY PPSPurchaseRequestItemUUID ppspurchaserequestitemuuid
PPSPurchaseRequestUUID ppspurchaserequestuuid
PPSPurchaseRequest ppspurchaserequest Purch.Reqn.
PPSPurchaseRequestItem ppspurchaserequestitem Requisn. item
PurchasingDeliveryAddressType purchasingdeliveryaddresstype Delivery Addr Type
Plant plant Valuation Area
StorageLocation storagelocation StorageLocation
FullName fullname Name
BusinessPartnerName2 businesspartnername2 Name 2
StreetName streetname Text
CityName cityname Name
Region region Venue Region
PostalCode postalcode Postal Code
DeliveryAddressID deliveryaddressid Address
Country country Venue: Ctry/Reg
DraftEntityCreationDateTime draftentitycreationdatetime Draft Created On
DraftEntityLastChangeDateTime draftentitylastchangedatetime Draft Last Changed On
DraftAdministrativeDataUUID draftadministrativedatauuid UUID
DraftEntityOperationCode draftentityoperationcode Draft - Operation Code
HasActiveEntity hasactiveentity TRUE
DraftFieldChanges draftfieldchanges Field Changes

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 R_PPS_PurReqItemDelivAddressD.
-- 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 R_PPS_PurReqItemDelivAddressD AS
SELECT
  PPSPurchaseRequestItemUUID,
  PPSPurchaseRequestUUID,
  PPSPurchaseRequest,
  PPSPurchaseRequestItem,
  PurchasingDeliveryAddressType,
  Plant,
  StorageLocation,
  FullName,
  BusinessPartnerName2,
  StreetName,
  CityName,
  Region,
  PostalCode,
  DeliveryAddressID,
  Country,
  DraftEntityCreationDateTime,
  DraftEntityLastChangeDateTime,
  DraftAdministrativeDataUUID,
  DraftEntityOperationCode,
  HasActiveEntity,
  DraftFieldChanges
FROM pps_pritm_dlad_d
;

Learn More