ESH_S_JITDCNF

DDL: ESH_S_JITDCNF SQL: ESH_U_JITDCNF Type: view Package: NJIT_GENERIC_APPS
26 Fields 1 Data Sources

Search view -JITDCNF

ESH_S_JITDCNF is a CDS View that provides data about "Search view -JITDCNF" in SAP S/4HANA. It reads from 1 data source (ESH_N_JITDCNF) and exposes 26 fields with key field JITDELIVERYCONFIRMATIONUUID. Part of development package NJIT_GENERIC_APPS.

Data Sources (1)

SourceAliasJoin Type
ESH_N_JITDCNF ESH_N_JITDCNF from

Parameters (1)

NameTypeDefault
P_Language abap.lang

Annotations (20)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
ClientHandling.type #INHERITED view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.modelingPattern #ENTERPRISE_SEARCH_PROVIDER view
Metadata.allowExtensions true view
Search.searchable true view
EnterpriseSearch.enabled true view
ObjectModel.sapObjectNodeType.name JustInTimeDeliveryConfirmation view
UI.headerInfo.typeName Just-In Time Delivery Confirmation view
UI.headerInfo.typeNamePlural Just-In Time Delivery Confirmations view
Consumption.semanticObject JITDeliveryConfirmation view
Metadata.ignorePropagatedAnnotations true view
UI.headerInfo.title.value JITEXTERNALDELIVCONFNMBR view
UI.headerInfo.description.value JITDELIVERYCONFIRMATIONID view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName ESH_U_JITDCNF view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY JITDELIVERYCONFIRMATIONUUID JITDELIVERYCONFIRMATIONUUID NodeID
ACTIVESUPPLIER ACTIVESUPPLIER Vendor no.
AUTHGRPCUSTOMER AUTHGRPCUSTOMER AuthorizGroup
AUTHGRPSUPPLIER AUTHGRPSUPPLIER AuthorizGroup
BILLINGDOCUMENT BILLINGDOCUMENT Customer Billing Document
BILLINGDOCUMENTDATE BILLINGDOCUMENTDATE Customer Billing Document Date
CREATIONDATETIME CREATIONDATETIME Created On
CUSTOMER CUSTOMER Sold-to Party
PURPOSECOMPLETEDCUSTOMER PURPOSECOMPLETEDCUSTOMER Purpose Completed
PURPOSECOMPLETEDSUPPLIER PURPOSECOMPLETEDSUPPLIER Purpose Completed
JITDELIVCONFMATCHINGSTATUS JITDELIVCONFMATCHINGSTATUS Matching Status
JITDELIVCONFMATCHINGSTATUSTXT JITDELIVCONFMATCHINGSTATUSTXT Matching Status
JITDELIVERYCONFIRMATIONDATE JITDELIVERYCONFIRMATIONDATE Confirmation Date
JITDELIVERYCONFIRMATIONID JITDELIVERYCONFIRMATIONID Deliv Conf ID
JITEXTERNALDELIVCONFNMBR JITEXTERNALDELIVCONFNMBR Deliv Conf Ext ID
JITRELEASESTATUS JITRELEASESTATUS Release Status
JITRELEASESTATUSTXT JITRELEASESTATUSTXT Release Status
LASTCHANGEDATETIME LASTCHANGEDATETIME Changed On
CUSTOMERNAME CUSTOMERNAME Name of Customer
SUPPLIERNAME SUPPLIERNAME Supplier Name
PLANT PLANT Valuation Area
PLANTNAME PLANTNAME Plant Name
SHIPTOPARTY SHIPTOPARTY Ship-To Party
SUPPLIER SUPPLIER Supplier
CREATEDBY CREATEDBY Created By
CHANGEDBY CHANGEDBY Changed By

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 ESH_S_JITDCNF.
-- 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.
-- SQL view name: ESH_U_JITDCNF
-- Parameters: P_Language : abap.lang

CREATE VIEW ESH_S_JITDCNF AS
SELECT
  JITDELIVERYCONFIRMATIONUUID,
  ACTIVESUPPLIER,
  AUTHGRPCUSTOMER,
  AUTHGRPSUPPLIER,
  BILLINGDOCUMENT,
  BILLINGDOCUMENTDATE,
  CREATIONDATETIME,
  CUSTOMER,
  PURPOSECOMPLETEDCUSTOMER,
  PURPOSECOMPLETEDSUPPLIER,
  JITDELIVCONFMATCHINGSTATUS,
  JITDELIVCONFMATCHINGSTATUSTXT,
  JITDELIVERYCONFIRMATIONDATE,
  JITDELIVERYCONFIRMATIONID,
  JITEXTERNALDELIVCONFNMBR,
  JITRELEASESTATUS,
  JITRELEASESTATUSTXT,
  LASTCHANGEDATETIME,
  CUSTOMERNAME,
  SUPPLIERNAME,
  PLANT,
  PLANTNAME,
  SHIPTOPARTY,
  SUPPLIER,
  CREATEDBY,
  CHANGEDBY
FROM ESH_N_JITDCNF
;

Learn More