I_JITDelivConfTP

DDL: I_JITDELIVCONFTP Type: view TRANSACTIONAL
29 Fields 1 Data Sources 1 Associations

TP View for Delivery Confirmation Header

I_JITDelivConfTP is a Transactional CDS View that provides data about "TP View for Delivery Confirmation Header" in SAP S/4HANA. It reads from 1 data source (I_JITDelivConfBasic) and exposes 29 fields with key field JITDeliveryConfirmationUUID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_JITDelivConfBasic I_JITDelivConfBasic from

Associations (1)

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

Annotations (24)

NameValueLevelField
AbapCatalog.sqlViewName IJITDCNFHDRTP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ObjectModel.sapObjectNodeType.name JustInTimeDeliveryConfirmation view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label TP View for Delivery Confirmation Header view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ClientHandling.algorithm #SESSION_VARIABLE view
ClientHandling.type #INHERITED view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.modelCategory #BUSINESS_OBJECT view
ObjectModel.createEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.updateEnabled EXTERNAL_CALCULATION view
ObjectModel.draftEnabled true view
ObjectModel.compositionRoot true view
ObjectModel.transactionalProcessingEnabled true view
ObjectModel.writeDraftPersistence NJIT_DCNF_HDR_D view
ObjectModel.writeActivePersistence NJIT_D_DCNF_HDR view
ObjectModel.entityChangeStateId LastChangeDateTime view

Fields (29)

KeyFieldSource TableSource FieldDescription
KEY JITDeliveryConfirmationUUID JITDeliveryConfirmationUUID NodeID
JITDeliveryConfirmationID JITDeliveryConfirmationID Deliv Conf ID
JITExternalDelivConfNmbr JITExternalDelivConfNmbr Deliv Conf Ext ID
ShipToParty ShipToParty Ship-To Party (obsolete)
CustomerPartnerDescription CustomerPartnerDescription Partner desc.
ActiveSupplier ActiveSupplier Vendor no.
Plant Plant Valuation Area
BillingDocument BillingDocument SD Document
JITDelivConfirmationIsReorder JITDelivConfirmationIsReorder Reorder
JITArchivingStatus JITArchivingStatus Archiving Stat.
JITDeliveryConfirmationDate JITDeliveryConfirmationDate Deliv Conf Date
JITReleaseStatus JITReleaseStatus Release Status
JITDelivConfMatchingStatus JITDelivConfMatchingStatus Matching Status
BillingDocumentDate BillingDocumentDate Billing Date
SalesOrganization SalesOrganization Sales Organization
CreatedByUser CreatedByUser User Name
CreationDateTime CreationDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
LastChangeDateTime LastChangeDateTime Timestamp
JITObjLifeCycStsCritlty
_CreatedByUser _CreatedByUser
_LastChangedByUser _LastChangedByUser
_JITReleaseStatus _JITReleaseStatus
_JITDelivConfMatchingStatus _JITDelivConfMatchingStatus
_Plant _Plant
_Customer _Customer
_SalesOrganization _SalesOrganization
_JITArchivingStatus _JITArchivingStatus
_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 I_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 I_JITDelivConfTP AS
SELECT
  JITDeliveryConfirmationUUID,
  JITDeliveryConfirmationID,
  JITExternalDelivConfNmbr,
  ShipToParty,
  CustomerPartnerDescription,
  ActiveSupplier,
  Plant,
  BillingDocument,
  JITDelivConfirmationIsReorder,
  JITArchivingStatus,
  JITDeliveryConfirmationDate,
  JITReleaseStatus,
  JITDelivConfMatchingStatus,
  BillingDocumentDate,
  SalesOrganization,
  CreatedByUser,
  CreationDateTime,
  LastChangedByUser,
  LastChangeDateTime,
  cast (0 as abap.int1) AS JITObjLifeCycStsCritlty
FROM I_JITDelivConfBasic
LEFT OUTER JOIN I_JITDelivConfItemTP AS _JITDelivConfItemTP ON JITDeliveryConfirmationUUID = _JITDelivConfItemTP.JITDeliveryConfirmationUUID  -- association [0..*]
;

Learn More