P_CollabnApplMngFrtOrderCharge

DDL: P_COLLABNAPPLMNGFRTORDERCHARGE SQL: PCOLLFRTORDCHRG Type: view CONSUMPTION
37 Fields 3 Data Sources 3 Associations

Private View for Freight Order Charges

P_CollabnApplMngFrtOrderCharge is a Consumption CDS View that provides data about "Private View for Freight Order Charges" in SAP S/4HANA. It reads from 3 data sources (P_CollabnFrtOrdChrgFilterFo, P_CollabnApplFrtOrdParty, P_CollabnApplCarrierUser) and exposes 37 fields with key field TransportationOrderUUID. It has 3 associations to related views.

Data Sources (3)

SourceAliasJoin Type
P_CollabnFrtOrdChrgFilterFo _CollabnFrtOrdChrgFilterFo1 left_outer
P_CollabnApplFrtOrdParty CollabnApplAddlAgrmtPty inner
P_CollabnApplCarrierUser CollabnApplCarrierUser inner

Associations (3)

CardinalityTargetAliasCondition
[0..1] P_CollabnFrtOrdChrgSfirItem _SuplrFrtInvcRequestItem $projection.TransportationOrderUUID = _SuplrFrtInvcRequestItem.TransportationOrderUUID
[1..1] I_CollabnApplFrtOrdDsputStatus _CollabnApplFrtOrdDsputStatus $projection.FreightOrderDisputeCaseStatus = _CollabnApplFrtOrdDsputStatus.FreightOrderDisputeCaseStatus
[0..1] I_TranspChargeObject _TranspChargeObject $projection.TransportationOrderUUID = _TranspChargeObject.TranspChargeHostDocumentUUID

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PCOLLFRTORDCHRG view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
VDM.private true view
EndUserText.label Private View for Freight Order Charges view

Fields (37)

KeyFieldSource TableSource FieldDescription
KEY TransportationOrderUUID TransportationOrder TransportationOrderUUID
FreightOrder TransportationOrder TransportationOrder
TransportationOrderCategory TransportationOrder TransportationOrderCategory
TransportationOrderType TransportationOrder TransportationOrderType
PurchasingOrgExternalID TransportationOrder PurchasingOrgExternalID
PurchasingOrganizationName
TransportationOrderStopUUID
SourceLocation
DestinationLocation
SourceLocationDescription
DestinationLocationDescription
SourceLocationAddressDesc
DestinationLocationAddressDesc
Carrier TransportationOrder Carrier Service Agent
BusinessPartnerCompany P_CollabnApplFrtOrdParty Coll_Carrier
BusinessPartnerUUID P_CollabnApplFrtOrdParty BusinessPartnerUUID UUID
TranspOrdResponsiblePerson TransportationOrder TranspOrdResponsiblePerson
MeansOfTransport TransportationOrder MeansOfTransport
MeansOfTransportDesc
TranspOrdShippingType TransportationOrder TranspOrdShippingType
TranspOrdDistance TransportationOrder TranspOrdDistance
TranspOrdDistanceUnit TransportationOrder TranspOrdDistanceUnit
TranspOrdDepartureDateTime
TranspOrdArrivalDateTime
TranspOrdGrossWeightUnit TransportationOrder TranspOrdGrossWeightUnit
TranspOrdGrossWeight TransportationOrder TranspOrdGrossWeight
TranspOrdGrossVolumeUnit TransportationOrder TranspOrdGrossVolumeUnit
TranspOrdGrossVolume TransportationOrder TranspOrdGrossVolume
TranspOrdQuantityUnit TransportationOrder TranspOrdQuantityUnit
TranspOrdQuantity TransportationOrder TranspOrdQuantity
SuplrFrtInvcReqUUID _SuplrFrtInvcRequestItem SuplrFrtInvcReqUUID
TransportationOrderTypeDesc
TranspChargeDocumentCurrency _TranspChargeObject TranspChargeDocumentCurrency
TranspChrgPrpsdNetAmtInDocCrcy _SuplrFrtInvcRequestItem TranspChrgPrpsdNetAmtInDocCrcy
_CollabnApplFrtOrdDsputStatus _CollabnApplFrtOrdDsputStatus
_SuplrFrtInvcRequestItem _SuplrFrtInvcRequestItem
_TranspChargeObject _TranspChargeObject

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 P_CollabnApplMngFrtOrderCharge.
-- 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.
-- SQL view name: PCOLLFRTORDCHRG

CREATE VIEW P_CollabnApplMngFrtOrderCharge AS
SELECT
  TransportationOrder.TransportationOrderUUID AS TransportationOrderUUID,
  TransportationOrder.TransportationOrder AS FreightOrder,
  TransportationOrder.TransportationOrderCategory AS TransportationOrderCategory,
  TransportationOrder.TransportationOrderType AS TransportationOrderType,
  TransportationOrder.PurchasingOrgExternalID AS PurchasingOrgExternalID,
  TransportationOrder._PurchasingOrganization._OrganizationalUnitText[1:Language = $session.system_language].OrganizationalUnitName AS PurchasingOrganizationName,
  TransportationOrder._SourceStop.TransportationOrderStopUUID AS TransportationOrderStopUUID,
  TransportationOrder._SourceStop.LocationId AS SourceLocation,
  TransportationOrder._DestinationStop.LocationId AS DestinationLocation,
  TransportationOrder._SourceStop._Locationdescr.LocationDescription AS SourceLocationDescription,
  TransportationOrder._DestinationStop._Locationdescr.LocationDescription AS DestinationLocationDescription,
  TransportationOrder._SourceStop._Locationdescr.AddressObjectDescription AS SourceLocationAddressDesc,
  TransportationOrder._DestinationStop._Locationdescr.AddressObjectDescription AS DestinationLocationAddressDesc,
  TransportationOrder.Carrier AS Carrier,
  CollabnApplAddlAgrmtPty.Coll_Carrier AS BusinessPartnerCompany,
  CollabnApplAddlAgrmtPty.BusinessPartnerUUID AS BusinessPartnerUUID,
  TransportationOrder.TranspOrdResponsiblePerson AS TranspOrdResponsiblePerson,
  TransportationOrder.MeansOfTransport AS MeansOfTransport,
  TransportationOrder._MeansOfTransport._Text[1: Language = $session.system_language].MeansOfTransportDesc AS MeansOfTransportDesc,
  TransportationOrder.TranspOrdShippingType AS TranspOrdShippingType,
  TransportationOrder.TranspOrdDistance AS TranspOrdDistance,
  TransportationOrder.TranspOrdDistanceUnit AS TranspOrdDistanceUnit,
  TransportationOrder._SourceStop.TranspOrdStopPlanTranspDteTme AS TranspOrdDepartureDateTime,
  TransportationOrder._DestinationStop.TranspOrdStopPlanTranspDteTme AS TranspOrdArrivalDateTime,
  TransportationOrder.TranspOrdGrossWeightUnit AS TranspOrdGrossWeightUnit,
  TransportationOrder.TranspOrdGrossWeight AS TranspOrdGrossWeight,
  TransportationOrder.TranspOrdGrossVolumeUnit AS TranspOrdGrossVolumeUnit,
  TransportationOrder.TranspOrdGrossVolume AS TranspOrdGrossVolume,
  TransportationOrder.TranspOrdQuantityUnit AS TranspOrdQuantityUnit,
  TransportationOrder.TranspOrdQuantity AS TranspOrdQuantity,
  _SuplrFrtInvcRequestItem.SuplrFrtInvcReqUUID AS SuplrFrtInvcReqUUID,
  TransportationOrder._TransportationOrderType._Text[1: Language = $session.system_language].TransportationOrderTypeDesc AS TransportationOrderTypeDesc,
  _TranspChargeObject.TranspChargeDocumentCurrency AS TranspChargeDocumentCurrency,
  _SuplrFrtInvcRequestItem.TranspChrgPrpsdNetAmtInDocCrcy AS TranspChrgPrpsdNetAmtInDocCrcy
LEFT OUTER JOIN P_CollabnFrtOrdChrgFilterFo AS _CollabnFrtOrdChrgFilterFo1 ON /* join condition not captured in parsed metadata */
INNER JOIN P_CollabnApplCarrierUser AS CollabnApplCarrierUser ON /* join condition not captured in parsed metadata */
INNER JOIN P_CollabnApplFrtOrdParty AS CollabnApplAddlAgrmtPty ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_CollabnFrtOrdChrgSfirItem AS _SuplrFrtInvcRequestItem ON TransportationOrderUUID = _SuplrFrtInvcRequestItem.TransportationOrderUUID  -- association [0..1]
LEFT OUTER JOIN I_CollabnApplFrtOrdDsputStatus AS _CollabnApplFrtOrdDsputStatus ON FreightOrderDisputeCaseStatus = _CollabnApplFrtOrdDsputStatus.FreightOrderDisputeCaseStatus  -- association [1..1]
LEFT OUTER JOIN I_TranspChargeObject AS _TranspChargeObject ON TransportationOrderUUID = _TranspChargeObject.TranspChargeHostDocumentUUID  -- association [0..1]
;

Learn More