C_CollabnApplFrtQuotationNote

DDL: C_COLLABNAPPLFRTQUOTATIONNOTE Type: view_entity CONSUMPTION
15 Fields 1 Data Sources 2 Associations 1 OData Services 1 Fiori Apps

Freight Quotation Notes

C_CollabnApplFrtQuotationNote is a Consumption CDS View that provides data about "Freight Quotation Notes" in SAP S/4HANA. It reads from 1 data source (I_TextCollection) and exposes 15 fields with key field TextCollectionContentUUID. It has 2 associations to related views. It is exposed through 1 OData service (UI_COLLABNAPPLFRTQUOTATION). It is used in 1 Fiori application: Display Freight Quotations.

Data Sources (1)

SourceAliasJoin Type
I_TextCollection TextCollectionRoot from

Associations (2)

CardinalityTargetAliasCondition
[0..*] C_CollabnApplFreightQuotation _CollabnApplFreightQuotation $projection.TransportationOrderUUID = _CollabnApplFreightQuotation.TransportationOrderUUID
[0..1] I_User _TextCollectionTextCrtedByUser $projection.TextCollectionTextCrtedByUser = _TextCollectionTextCrtedByUser.UserID

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
VDM.viewType #CONSUMPTION view
ObjectModel.representativeKey TextCollectionContentUUID view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Freight Quotation Notes view

OData Services (1)

ServiceBindingVersionContractRelease
UI_COLLABNAPPLFRTQUOTATION UI_COLLABNAPPLFRTQUOTATION V2 C1 NOT_RELEASED

Fiori Apps (1)

App IDApp NameTypeDescription
F5553 Display Freight Quotations Transactional Display freight quotations is a collaboration application in which service provider representative of carrier organization monitors quotations.

Display Freight Quotations

Business Role: Logistics Service Provider Representative

With this feature, you as a shipper can enable your carriers to use the new Display Freight Quotations app to view all the freight quotations they have submitted.

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY TextCollectionContentUUID TextCollectionContent TextCollectionContentUUID
TextCollectionTypeUUID TextCollectionType TextCollectionTypeUUID
TextCollectionUUID I_TextCollection TextCollectionUUID UUID
TextCollectionSchema I_TextCollection TextCollectionSchema Text Schema
TextCollectionType TextCollectionType TextCollectionType
TransportationOrderUUID I_TextCollection HostDocumentUUID UUID
HostDocumentBusinessObjectUUID I_TextCollection HostDocumentBusinessObjectUUID Business Object
HostDocumentBusObjNodeUUID I_TextCollection HostDocumentBusObjNodeUUID Node
TextCollectionTextCrtedByUser TextCollectionType TextCollectionTextCrtedByUser
UserDescription _TextCollectionTextCrtedByUser UserDescription Full Name
TextCollectionTextCrtedDteTime TextCollectionType TextCollectionTextCrtedDteTime
TextCollectionTextChgdDateTime TextCollectionType TextCollectionTextChgdDateTime
Language TextCollectionType Language Report Text Language
TextCollectionContentText TextCollectionContent TextCollectionContentText
_CollabnApplFreightQuotation _CollabnApplFreightQuotation

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_CollabnApplFrtQuotationNote.
-- 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_CollabnApplFrtQuotationNote AS
SELECT
  TextCollectionContent.TextCollectionContentUUID AS TextCollectionContentUUID,
  TextCollectionType.TextCollectionTypeUUID AS TextCollectionTypeUUID,
  TextCollectionRoot.TextCollectionUUID AS TextCollectionUUID,
  TextCollectionRoot.TextCollectionSchema AS TextCollectionSchema,
  TextCollectionType.TextCollectionType AS TextCollectionType,
  TextCollectionRoot.HostDocumentUUID AS TransportationOrderUUID,
  TextCollectionRoot.HostDocumentBusinessObjectUUID AS HostDocumentBusinessObjectUUID,
  TextCollectionRoot.HostDocumentBusObjNodeUUID AS HostDocumentBusObjNodeUUID,
  TextCollectionType.TextCollectionTextCrtedByUser AS TextCollectionTextCrtedByUser,
  _TextCollectionTextCrtedByUser.UserDescription AS UserDescription,
  TextCollectionType.TextCollectionTextCrtedDteTime AS TextCollectionTextCrtedDteTime,
  TextCollectionType.TextCollectionTextChgdDateTime AS TextCollectionTextChgdDateTime,
  TextCollectionType.Language AS Language,
  TextCollectionContent.TextCollectionContentText AS TextCollectionContentText
FROM I_TextCollection AS TextCollectionRoot
LEFT OUTER JOIN C_CollabnApplFreightQuotation AS _CollabnApplFreightQuotation ON TransportationOrderUUID = _CollabnApplFreightQuotation.TransportationOrderUUID  -- association [0..*]
LEFT OUTER JOIN I_User AS _TextCollectionTextCrtedByUser ON TextCollectionTextCrtedByUser = _TextCollectionTextCrtedByUser.UserID  -- association [0..1]
;

Learn More