C_SftyDataShtOutpReqFDP_2

DDL: C_SFTYDATASHTOUTPREQFDP_2 Type: view CONSUMPTION
17 Fields 1 Data Sources 1 Associations

Safety Data Sheet Shipment Request

C_SftyDataShtOutpReqFDP_2 (Consumption)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Cross Applications

C_SftyDataShtOutpReqFDP_2 is a Consumption CDS View that provides data about "Safety Data Sheet Shipment Request" in SAP S/4HANA. It reads from 1 data source (I_SftyDataShtOutpReq) and exposes 17 fields with key field SftyDataShtOutpReqUUID. It has 1 association to related views.

SAP Help Documentation

CategoryCDS Views for Safety Data Sheet Management
StatusReleased
Purpose
This CDS view represents a form data provider for Output Management. The CDS view provides data that can be used on a coversheet form for safety data sheets. This CDS view provides the prerequisites for answering the following business questions:

Prerequisites
You have authorizations to display safety data sheet shipment requests for the authorization object EHSDS_OR.

Structure
Object types This view is built on the following object type: Safety data sheet shipment request Main CDS parameters and filters This view has no input parameters. Measures and attributes Some important measures and attributes are: Safety data sheet recipient (business partner) Safety data sheet shipment origin Shipment items: Product Language Generation date of safety data sheet Version number of safety data sheet

SAP Business Warehouse (SAP BW) Extraction
Note The corresponding DataSource (Extractor) and this CDS view may have different functionalities. In case you are interested in the details of the DataSource, see the related documentation on the SAP Help Portal at https://help.sap.com/viewer/p/BI_CONTENT_757 under Application Help SAP Library BI Content . For more information on extraction, see Extracting Data Through CDS Views to SAP BW/4HANA . not applicable

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessCross Applications
Application ComponentEHS-SUS-SDS
CapabilitiesOutput: Form Data Provider
PackageCross Applications for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
I_SftyDataShtOutpReq I_SftyDataShtOutpReq from

Associations (1)

CardinalityTargetAliasCondition
[1..*] I_SftyDataShtOutpReqItemEnhcd _OutputItem $projection.SftyDataShtOutpReqUUID = _OutputItem.SftyDataShtOutpReqUUID

Annotations (15)

NameValueLevelField
EndUserText.label Safety Data Sheet Shipment Request view
AbapCatalog.sqlViewName CSDSORFDP2 view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.representativeKey SftyDataShtOutpReqUUID view
ObjectModel.modelingPattern #OUTPUT_FORM_DATA_PROVIDER view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY SftyDataShtOutpReqUUID SftyDataShtOutpReqUUID SDS Output Request UUID
Customer Customer Ship-To Party Customer
SftyDataShtRcpntPty SftyDataShtRcpntPty SDS Recipient (obsolete)
SftyDataShtRcpntAddrID SftyDataShtRcpntAddrID SDS Recipient Address
ShipToPartyAddressID ShipToPartyAddressID Ship-to Party Address
ShipToPartyCountry ShipToPartyCountry Safety Data Sheet Ship-to Country/Region ID
ShipToPartyRegion ShipToPartyRegion Safety Data Sheet Ship-to Region ID
SftyDataShtShipmentDateTime SftyDataShtShipmentDateTime Shipment Date and Time for Safety Data Sheet
SftyDataShtOutpDateTime SftyDataShtOutpDateTime Output Date and Time of Safety Data Sheet
SftyDataShtOutpReqStatus SftyDataShtOutpReqStatus Status of Safety Data Sheet Output Request
SalesOrganization SalesOrganization Sales Organization
SftyDataShtOutpReqNoteText SftyDataShtOutpReqNoteText Safety Data Sheet Manual Shipment Notes
associations_OutputItem
_SalesOrg _SalesOrg
_RecipientParty _RecipientParty
_BusinessPartner _BusinessPartner
_BusinessPartnerCustomer _BusinessPartnerCustomer

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_SftyDataShtOutpReqFDP_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 C_SftyDataShtOutpReqFDP_2 AS
SELECT
  SftyDataShtOutpReqUUID,
  Customer,
  SftyDataShtRcpntPty,
  SftyDataShtRcpntAddrID,
  ShipToPartyAddressID,
  ShipToPartyCountry,
  ShipToPartyRegion,
  SftyDataShtShipmentDateTime,
  SftyDataShtOutpDateTime,
  SftyDataShtOutpReqStatus,
  SalesOrganization,
  SftyDataShtOutpReqNoteText
FROM I_SftyDataShtOutpReq
LEFT OUTER JOIN I_SftyDataShtOutpReqItemEnhcd AS _OutputItem ON SftyDataShtOutpReqUUID = _OutputItem.SftyDataShtOutpReqUUID  -- association [1..*]
;

Learn More