I_SlsOrdWthoutChrgImprtHistItm

DDL: I_SLSORDWTHOUTCHRGIMPRTHISTITM Type: view_entity COMPOSITE
12 Fields 1 Data Sources 2 Associations

Sales Order Without Charge Import History Item Data

I_SlsOrdWthoutChrgImprtHistItm is a Composite CDS View that provides data about "Sales Order Without Charge Import History Item Data" in SAP S/4HANA. It reads from 1 data source (I_SalesDocImportHistoryItem) and exposes 12 fields with key fields SalesDocumentImportID, SalesDocumentTemporaryID. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_SalesDocImportHistoryItem _ImportHistItem from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_SlsOrdWthoutChrgImprtHistory _ImportHist _ImportHist.SalesDocumentImportID = $projection.SalesDocumentImportID
[1..1] I_SlsOrdWthoutChrgImport _SalesDocumentImport $projection.SalesOrderWithoutCharge = _SalesDocumentImport.SalesOrderWithoutCharge

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Sales Order Without Charge Import History Item Data view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY SalesDocumentImportID SalesDocumentImportID Import ID
KEY SalesDocumentTemporaryID Sales Order (Temporary ID)
SalesOrderWithoutCharge SD Document
ExternalDocumentID ExternalDocumentID Ext. Reference ID
ApplicationLogHandle ApplicationLogHandle Log Handle
SalesDocumentCreationStatus SalesDocumentCreationStatus Creation Status
SalesDocumentCreationDateTime Created On
SlsDocCrtnStatusCriticality
NumberOfSalesOrders
_ImportHist _ImportHist
_SalesDocumentImport _SalesDocumentImport
_CreationStatus _CreationStatus

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_SlsOrdWthoutChrgImprtHistItm.
-- 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_SlsOrdWthoutChrgImprtHistItm AS
SELECT
  SalesDocumentImportID,
  cast (SalesDocumentTemporaryID as slsso_foc_temporaryid) AS SalesDocumentTemporaryID,
  cast (SalesDocument as sales_order_without_charge) AS SalesOrderWithoutCharge,
  ExternalDocumentID,
  ApplicationLogHandle,
  SalesDocumentCreationStatus,
  cast( SalesDocumentCreationDateTime as slsord_creation_date_time preserving type ) AS SalesDocumentCreationDateTime,
  cast(SlsDocCrtnStatusCriticality as slsdoc_import_crtn_sts_critlty preserving type ) AS SlsDocCrtnStatusCriticality,
  cast( 1 as abap.int4 ) AS NumberOfSalesOrders
FROM I_SalesDocImportHistoryItem AS _ImportHistItem
LEFT OUTER JOIN I_SlsOrdWthoutChrgImprtHistory AS _ImportHist ON _ImportHist.SalesDocumentImportID = SalesDocumentImportID  -- association [1..1]
LEFT OUTER JOIN I_SlsOrdWthoutChrgImport AS _SalesDocumentImport ON SalesOrderWithoutCharge = _SalesDocumentImport.SalesOrderWithoutCharge  -- association [1..1]
;

Learn More