I_FldLogsShptCtnCertificate

DDL: I_FLDLOGSSHPTCTNCERTIFICATE Type: view_entity BASIC Package: FLOG_SHIPMENT
9 Fields 1 Data Sources 2 Associations

Shipment container certificate

I_FldLogsShptCtnCertificate is a Basic CDS View that provides data about "Shipment container certificate" in SAP S/4HANA. It reads from 1 data source (flog_ctn_cert) and exposes 9 fields with key fields FldLogsContainerUUID, FldLogsCertificateNumber. It has 2 associations to related views. Part of development package FLOG_SHIPMENT.

Data Sources (1)

SourceAliasJoin Type
flog_ctn_cert flog_ctn_cert from

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_FldLogsShptCtnCertTypeText _CertificateTypeText $projection.FldLogsCertificateType = _CertificateTypeText.FldLogsCertificateType
[0..1] E_FldLogsShptCtnCertificate _ShptCtnCertExtension $projection.FldLogsContainerUUID = _ShptCtnCertExtension.FldLogsContainerUUID and $projection.FldLogsCertificateNumber = _ShptCtnCertExtension.FldLogsCertificateNumber

Annotations (7)

NameValueLevelField
EndUserText.label Shipment container certificate view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
VDM.viewType #BASIC view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY FldLogsContainerUUID fldlogscontaineruuid Container UUID
KEY FldLogsCertificateNumber fldlogscertificatenumber Certificate No.
FldLogsCertificateType fldlogscertificatetype Certificate Type
FldLogsCertStartDate fldlogscertstartdate Start Date
FldLogsCertEndDate fldlogscertenddate End Date
FldLogsNextCertificateDate fldlogsnextcertificatedate Next Cert Dt.
FldLogsCtnCertificateStatus fldlogsctncertificatestatus Certificate Status
FldLogsCtnCertLoclLstChgDteTme fldlogsctncertlocllstchgdtetme Changed On
_CertificateTypeText _CertificateTypeText

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 I_FldLogsShptCtnCertificate.
-- 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 I_FldLogsShptCtnCertificate AS
SELECT
  FldLogsContainerUUID,
  FldLogsCertificateNumber,
  FldLogsCertificateType,
  FldLogsCertStartDate,
  FldLogsCertEndDate,
  FldLogsNextCertificateDate,
  FldLogsCtnCertificateStatus,
  FldLogsCtnCertLoclLstChgDteTme
FROM flog_ctn_cert
LEFT OUTER JOIN I_FldLogsShptCtnCertTypeText AS _CertificateTypeText ON FldLogsCertificateType = _CertificateTypeText.FldLogsCertificateType  -- association [0..*]
LEFT OUTER JOIN E_FldLogsShptCtnCertificate AS _ShptCtnCertExtension ON FldLogsContainerUUID = _ShptCtnCertExtension.FldLogsContainerUUID AND FldLogsCertificateNumber = _ShptCtnCertExtension.FldLogsCertificateNumber  -- association [0..1]
;

Learn More