C_EnvrmtWasteTranspDocPartTP

DDL: C_ENVRMTWASTETRANSPDOCPARTTP Type: view_entity CONSUMPTION
27 Fields 1 Data Sources 1 OData Services

WasteTranspDocTransportPartnerProjection

C_EnvrmtWasteTranspDocPartTP is a Consumption CDS View that provides data about "WasteTranspDocTransportPartnerProjection" in SAP S/4HANA. It reads from 1 data source (R_EnvrmtWasteTranspDocPartTP) and exposes 27 fields with key field EnvWstTranspDocPartAssgdUUID. It is exposed through 1 OData service (UI_TRANSP_DOC).

Data Sources (1)

SourceAliasJoin Type
R_EnvrmtWasteTranspDocPartTP R_EnvrmtWasteTranspDocPartTP projection

Annotations (7)

NameValueLevelField
EndUserText.label WasteTranspDocTransportPartnerProjection view
AccessControl.authorizationCheck #CHECK view
Metadata.allowExtensions true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view

OData Services (1)

ServiceBindingVersionContractRelease
UI_TRANSP_DOC UI_TRANSP_DOC V4 C1 NOT_RELEASED

Fields (27)

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
EnvWstTranspDocTransporterDate 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
sstring260
EnvrmtWastePartFcltyName _DisposalFacility EnvrmtWastePartFcltyName Waste Facility Name
EnvrmtWastePartnerTypeName _TypeText EnvrmtWastePartnerTypeName
EnvrmtWastePartnerName
EnvrmtWasteFcltyRegistrationID _DisposalFacility EnvrmtWasteFcltyRegistrationID Waste Rgstn No
EnvrmtWasteGnrtrUUID _TranspDoc EnvrmtWasteGnrtrUUID Waste Generator UUID
CreationDateTime CreationDateTime Timestamp
CreatedByUser CreatedByUser User Name
LastChangeDateTime LastChangeDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
_TypeText _TypeText
_WastePartner _WastePartner
_DisposalFacility _DisposalFacility
_BPCurrentDefaultAddress _BPCurrentDefaultAddress

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_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 C_EnvrmtWasteTranspDocPartTP AS
SELECT
  EnvWstTranspDocPartAssgdUUID,
  EnvrmtWasteTranspDocUUID,
  EnvrmtWastePartnerUUID,
  EnvrmtWastePartnerType,
  EnvrmtWastePartDsplFcltyUUID,
  EnvWstTranspDocTakeAcceptDate AS EnvWstTranspDocTransporterDate,
  EnvrmtWasteLicensePlateTxt,
  EnvrmtWasteTrailerPlateTxt,
  EnvWstTranspPrtnSequenceValue,
  EnvrmtWastePartSgntrDate,
  EnvrmtWastePartCntctPersnName,
  BusinessPartner,
  AddressNumber,
  virtualElement: true virtual FormattedPostalAddressText : abap.sstring(260) AS sstring260,
  _DisposalFacility.EnvrmtWastePartFcltyName AS EnvrmtWastePartFcltyName,
  _TypeText.EnvrmtWastePartnerTypeName AS EnvrmtWastePartnerTypeName,
  _WastePartner._BusinessPartner.EnvrmtWastePartnerName AS EnvrmtWastePartnerName,
  _DisposalFacility.EnvrmtWasteFcltyRegistrationID AS EnvrmtWasteFcltyRegistrationID,
  _TranspDoc.EnvrmtWasteGnrtrUUID AS EnvrmtWasteGnrtrUUID,
  CreationDateTime,
  CreatedByUser,
  LastChangeDateTime,
  LastChangedByUser
FROM R_EnvrmtWasteTranspDocPartTP
;

Learn More