C_JITDelivConfTP

DDL: C_JITDELIVCONFTP Type: view CONSUMPTION Package: NJIT_APP_MANAGE_DELIV_CONF
27 Fields 1 Data Sources 1 Associations

Delivery Confirmation

C_JITDelivConfTP is a Consumption CDS View that provides data about "Delivery Confirmation" in SAP S/4HANA. It reads from 1 data source (I_JITDelivConfTP) and exposes 27 fields with key field JITDeliveryConfirmationUUID. It has 1 association to related views. Part of development package NJIT_APP_MANAGE_DELIV_CONF.

Data Sources (1)

SourceAliasJoin Type
I_JITDelivConfTP I_JITDelivConfTP from

Associations (1)

CardinalityTargetAliasCondition
[0..*] C_JITDelivConfItemTP _JITDelivConfItemTP $projection.JITDeliveryConfirmationUUID = _JITDelivConfItemTP.JITDeliveryConfirmationUUID

Annotations (17)

NameValueLevelField
AbapCatalog.sqlViewName CJITDCNFHDRTP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Delivery Confirmation view
Metadata.allowExtensions true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.draftEnabled true view
ObjectModel.compositionRoot true view
ObjectModel.transactionalProcessingDelegated true view
ObjectModel.representativeKey JITDeliveryConfirmationUUID view
Search.searchable true view
VDM.viewType #CONSUMPTION view

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY JITDeliveryConfirmationUUID JITDeliveryConfirmationUUID NodeID
JITDeliveryConfirmationID JITDeliveryConfirmationID Deliv Conf ID
JITExternalDelivConfNmbr JITExternalDelivConfNmbr Deliv Conf Ext ID
JITDeliveryConfirmationDate JITDeliveryConfirmationDate Deliv Conf Date
JITDelivConfirmationIsReorder JITDelivConfirmationIsReorder Reorder
ShipToParty ShipToParty Ship-To Party (obsolete)
CustomerPartnerDescription CustomerPartnerDescription Partner desc.
JITReleaseStatus JITReleaseStatus Release Status
JITReleaseStatusTxt
JITDelivConfMatchingStatus JITDelivConfMatchingStatus Matching Status
JITDelivConfMatchingStatusTxt
BillingDocument BillingDocument SD Document
BillingDocumentDate BillingDocumentDate Billing Date
ActiveSupplier ActiveSupplier Vendor no.
Plant Plant Valuation Area
JITArchivingStatus JITArchivingStatus Archiving Stat.
SalesOrganization SalesOrganization Sales Organization
CreatedByUser CreatedByUser User Name
CreationDateTime CreationDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
LastChangeDateTime LastChangeDateTime Timestamp
JITLifeCycleStatusCriticality JITLifeCycleStatusCriticality
JITObjLifeCycStsCritlty JITObjLifeCycStsCritlty
JITMatchingStatusCriticality JITMatchingStatusCriticality
_CreatedByUser _CreatedByUser
_LastChangedByUser _LastChangedByUser
_JITDelivConfItemTP _JITDelivConfItemTP

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_JITDelivConfTP.
-- 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_JITDelivConfTP AS
SELECT
  JITDeliveryConfirmationUUID,
  JITDeliveryConfirmationID,
  JITExternalDelivConfNmbr,
  JITDeliveryConfirmationDate,
  JITDelivConfirmationIsReorder,
  ShipToParty,
  CustomerPartnerDescription,
  JITReleaseStatus,
  _JITReleaseStatus._Text[1:Language = $session.system_language].JITReleaseStatusTxt AS JITReleaseStatusTxt,
  JITDelivConfMatchingStatus,
  _JITDelivConfMatchingStatus._Text[1:Language = $session.system_language].JITDelivConfMatchingStatusTxt AS JITDelivConfMatchingStatusTxt,
  BillingDocument,
  BillingDocumentDate,
  ActiveSupplier,
  Plant,
  JITArchivingStatus,
  SalesOrganization,
  CreatedByUser,
  CreationDateTime,
  LastChangedByUser,
  LastChangeDateTime,
  JITLifeCycleStatusCriticality,
  JITObjLifeCycStsCritlty,
  JITMatchingStatusCriticality
FROM I_JITDelivConfTP
LEFT OUTER JOIN C_JITDelivConfItemTP AS _JITDelivConfItemTP ON JITDeliveryConfirmationUUID = _JITDelivConfItemTP.JITDeliveryConfirmationUUID  -- association [0..*]
;

Learn More