C_FldLogsShptCtnCertificateTP

DDL: C_FLDLOGSSHPTCTNCERTIFICATETP Type: view_entity CONSUMPTION
12 Fields 1 Data Sources 1 Associations 1 OData Services 1 Fiori Apps

Shipment container certificate TP

C_FldLogsShptCtnCertificateTP is a Consumption CDS View that provides data about "Shipment container certificate TP" in SAP S/4HANA. It reads from 1 data source (R_FldLogsShptCtnCertificateTP) and exposes 12 fields with key fields FldLogsContainerUUID, FldLogsCertificateNumber. It has 1 association to related views. It is exposed through 1 OData service (UI_SHIPMENTCONTAINER). It is used in 1 Fiori application: Manage Container Master Data.

Data Sources (1)

SourceAliasJoin Type
R_FldLogsShptCtnCertificateTP R_FldLogsShptCtnCertificateTP projection

Associations (1)

CardinalityTargetAliasCondition
[0..1] E_FldLogsShptCtnCertificate _ShptCtnCertExtension $projection.FldLogsContainerUUID = _ShptCtnCertExtension.FldLogsContainerUUID and $projection.FldLogsCertificateNumber = _ShptCtnCertExtension.FldLogsCertificateNumber

Annotations (12)

NameValueLevelField
EndUserText.label Shipment container certificate TP view
AccessControl.authorizationCheck #MANDATORY view
Metadata.allowExtensions true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #M view
AbapCatalog.extensibility.extensible true view
AbapCatalog.extensibility.allowNewCompositions true view
AbapCatalog.extensibility.quota.maximumFields 608 view
AbapCatalog.extensibility.quota.maximumBytes 28160 view
AbapCatalog.extensibility.elementSuffix CER view

OData Services (1)

ServiceBindingVersionContractRelease
UI_SHIPMENTCONTAINER UI_SHIPMENTCONTAINER V2 C1 NOT_TO_BE_RELEASED_STABLE

Fiori Apps (1)

App IDApp NameTypeDescription
F5785 Manage Container Master Data Transactional An application to manage Container Master Data in Field Logistics

Manage Container Master Data

Business Role: Others

With this app, you can create, display the container / FL package master data, maintain certification and rental details for a container, and modify the container / FL package master data.

Key Features: Using the Create container feature, you can add the following: Container header information: Container ID, Container description, plant, container category, container type and statusNote The physical property of the container is updated if the selected container type has values maintained in the SSCUI.If the container ID field is blank a container ID is generated by the internal number range that is maintained in the Container Number Range SSCUI. General information: Equipment number, external ID, container material, container supplier and container owner details Physical properties, capacity, temperature, and certificate information. Note If equipment number field is blank when creating a container and the create equipment checkbox is checked in the Container Category SSCUI, then the equipment master is created automatically with the equipment type mentioned in the SSCUI. However, you can also map the field to a different equipment number if it is not mapped to another container.

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY FldLogsContainerUUID FldLogsContainerUUID Container UUID
KEY FldLogsCertificateNumber FldLogsCertificateNumber Certificate No.
FldLogsCertNumberForEdit FldLogsCertNumberForEdit Certificate No.
FldLogsCertificateType FldLogsCertificateType Certificate Type
FldLogsCertStartDate FldLogsCertStartDate Start Date
FldLogsCertEndDate FldLogsCertEndDate End Date
FldLogsNextCertificateDate FldLogsNextCertificateDate Next Cert Dt.
FldLogsCtnCertStsCriticality FldLogsCtnCertStsCriticality
FldLogsCtnCertificateStatus FldLogsCtnCertificateStatus Certificate Status
FldLogsCtnCertLoclLstChgDteTme FldLogsCtnCertLoclLstChgDteTme Changed On
FldLogsCtnCertificateTypeTextlocalized
FldLogsCtnCertStatusTextlocalized

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_FldLogsShptCtnCertificateTP.
-- 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_FldLogsShptCtnCertificateTP AS
SELECT
  FldLogsContainerUUID,
  FldLogsCertificateNumber,
  FldLogsCertNumberForEdit,
  FldLogsCertificateType,
  FldLogsCertStartDate,
  FldLogsCertEndDate,
  FldLogsNextCertificateDate,
  FldLogsCtnCertStsCriticality,
  FldLogsCtnCertificateStatus,
  FldLogsCtnCertLoclLstChgDteTme,
  _CertificateTypeText.FldLogsCtnCertificateTypeText : localized AS FldLogsCtnCertificateTypeTextlocalized,
  _CertText.FldLogsCtnCertStatusText : localized AS FldLogsCtnCertStatusTextlocalized
FROM R_FldLogsShptCtnCertificateTP
LEFT OUTER JOIN E_FldLogsShptCtnCertificate AS _ShptCtnCertExtension ON FldLogsContainerUUID = _ShptCtnCertExtension.FldLogsContainerUUID AND FldLogsCertificateNumber = _ShptCtnCertExtension.FldLogsCertificateNumber  -- association [0..1]
;

Learn More