SHSM_NJIT_CUSTOMER

DDL: SHSM_NJIT_CUSTOMER SQL: SHSMJITCUST Type: view
12 Fields 1 Data Sources

Search help view to fetch JIT customers

SHSM_NJIT_CUSTOMER is a CDS View that provides data about "Search help view to fetch JIT customers" in SAP S/4HANA. It reads from 1 data source (njit_d_cust_hdr) and exposes 12 fields with key field customeruuid.

Data Sources (1)

SourceAliasJoin Type
njit_d_cust_hdr njit_d_cust_hdr from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName SHSMJITCUST view
AbapCatalog.preserveKey true view
EndUserText.label Search help view to fetch JIT customers view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.dataCategory #VALUE_HELP view
Metadata.ignorePropagatedAnnotations true view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY customeruuid customeruuid NodeID
ShipToParty shiptoparty Ship-To Party (obsolete)
SalesOrganization
DistributionChannel
Division
JITCustomerStatus jitcustomerstatus Customer Status
IsJITRelevant isjitrelevant JIT-Relevant
DaysForIntJITNumberGeneration daysforintjitnumbergeneration Extl JIT Num. Usage
CustomerCreatedByUser createdbyuser User Name
JITCustomerCreationDateTime creationdatetime Timestamp
JITDataLastChgdByUser lastchangedbyuser User Name
JITCustDraftInfoLastChanged lastchangedatetime Timestamp

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 SHSM_NJIT_CUSTOMER.
-- 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: SHSMJITCUST

CREATE VIEW SHSM_NJIT_CUSTOMER AS
SELECT
  customeruuid,
  ShipToParty,
  cast(' ' as vkorg) AS SalesOrganization,
  cast(' ' as vtweg) AS DistributionChannel,
  cast(' ' as spart) AS Division,
  JITCustomerStatus,
  IsJITRelevant,
  DaysForIntJITNumberGeneration,
  createdbyuser AS CustomerCreatedByUser,
  creationdatetime AS JITCustomerCreationDateTime,
  lastchangedbyuser AS JITDataLastChgdByUser,
  lastchangedatetime AS JITCustDraftInfoLastChanged
FROM njit_d_cust_hdr
;

Learn More