A_EnvrmtWasteTranspDocPartTP

DDL: A_ENVRMTWASTETRANSPDOCPARTTP Type: view_entity CONSUMPTION
23 Fields 1 Data Sources

Partners

A_EnvrmtWasteTranspDocPartTP is a Consumption CDS View that provides data about "Partners" in SAP S/4HANA. It reads from 1 data source (R_EnvrmtWasteTranspDocPartTP) and exposes 23 fields with key field EnvWstTranspDocPartAssgdUUID.

Data Sources (1)

SourceAliasJoin Type
R_EnvrmtWasteTranspDocPartTP R_EnvrmtWasteTranspDocPartTP projection

Annotations (9)

NameValueLevelField
EndUserText.label Partners view
AccessControl.authorizationCheck #CHECK view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
OData.entityType.name TranspDocPart_Type view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
VDM.viewType #CONSUMPTION view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY EnvWstTranspDocPartAssgdUUID EnvWstTranspDocPartAssgdUUID Partner Assgned UUID
EnvrmtWasteTranspDocUUID EnvrmtWasteTranspDocUUID WTR UUID
EnvrmtWastePartnerUUID EnvrmtWastePartnerUUID Waste Partner UUID
EnvrmtWastePartnerType EnvrmtWastePartnerType Waste Partner Type
EnvrmtWastePartDsplFcltyUUID EnvrmtWastePartDsplFcltyUUID Waste Facility UUID
EnvWstTranspDocTakeAcceptDate EnvWstTranspDocTakeAcceptDate Take/Accept Date
EnvrmtWasteLicensePlateTxt EnvrmtWasteLicensePlateTxt License Plate
EnvrmtWasteTrailerPlateTxt EnvrmtWasteTrailerPlateTxt Trailer Plate
EnvWstTranspPrtnSequenceValue EnvWstTranspPrtnSequenceValue Transporter Seq
EnvrmtWastePartSgntrDate EnvrmtWastePartSgntrDate WastePrtn Sgntr Date
EnvrmtWastePartCntctPersnName EnvrmtWastePartCntctPersnName WastePrtn CntctPersn
BusinessPartner BusinessPartner Issuing Authority
AddressNumber AddressNumber Src Address No
virtualBPIdentificationNumberchar60
sstring260
EnvrmtWasteFcltyRegistrationID _DisposalFacility EnvrmtWasteFcltyRegistrationID Waste Rgstn No
EnvrmtWastePartnerName
EnvrmtWastePartFcltyName _DisposalFacility EnvrmtWastePartFcltyName Waste Facility Name
CreationDateTime CreationDateTime Timestamp
CreatedByUser CreatedByUser User Name
LastChangeDateTime LastChangeDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
_WastePartner _WastePartner

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_EnvrmtWasteTranspDocPartTP.
-- 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_EnvrmtWasteTranspDocPartTP AS
SELECT
  EnvWstTranspDocPartAssgdUUID,
  EnvrmtWasteTranspDocUUID,
  EnvrmtWastePartnerUUID,
  EnvrmtWastePartnerType,
  EnvrmtWastePartDsplFcltyUUID,
  EnvWstTranspDocTakeAcceptDate,
  EnvrmtWasteLicensePlateTxt,
  EnvrmtWasteTrailerPlateTxt,
  EnvWstTranspPrtnSequenceValue,
  EnvrmtWastePartSgntrDate,
  EnvrmtWastePartCntctPersnName,
  BusinessPartner,
  AddressNumber,
  virtual BPIdentificationNumber : char60 AS virtualBPIdentificationNumberchar60,
  virtual FormattedPostalAddressText : abap.sstring(260) AS sstring260,
  _DisposalFacility.EnvrmtWasteFcltyRegistrationID AS EnvrmtWasteFcltyRegistrationID,
  _WastePartner._BusinessPartner.EnvrmtWastePartnerName AS EnvrmtWastePartnerName,
  _DisposalFacility.EnvrmtWastePartFcltyName AS EnvrmtWastePartFcltyName,
  CreationDateTime,
  CreatedByUser,
  LastChangeDateTime,
  LastChangedByUser
FROM R_EnvrmtWasteTranspDocPartTP
;

Learn More