I_SrvcTransOneOrderField

DDL: I_SRVCTRANSONEORDERFIELD SQL: IONEORDMP Type: view BASIC Package: CRMS4_BTMF_ODATA
6 Fields 2 Data Sources

One order field mapping

I_SrvcTransOneOrderField is a Basic CDS View that provides data about "One order field mapping" in SAP S/4HANA. It reads from 2 data sources (crms4s_1o_api_mp, dd03nd) and exposes 6 fields with key fields BusSolutionQuotationProperty, SrvcTransacOneOrdDetnIdfr, CDSView. Part of development package CRMS4_BTMF_ODATA.

Data Sources (2)

SourceAliasJoin Type
crms4s_1o_api_mp mp from
dd03nd tf inner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IONEORDMP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label One order field mapping view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY BusSolutionQuotationProperty interface_field Interface Field Name
KEY SrvcTransacOneOrdDetnIdfr am SrvcTransacOneOrdDetnIdfr
KEY CDSView dd03nd strucobjn DD: Name of a structured object (e.g. entity, context)
SrvcTransactionOneOrderField oneord_fieldname Technical Field Name
SrvcTransOneOrderSubObj oneord_bt_subobj Object Name
SrvcTransacOneOrdDetermination am SrvcTransacOneOrdDetermination

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_SrvcTransOneOrderField.
-- 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: IONEORDMP

CREATE VIEW I_SrvcTransOneOrderField AS
SELECT
  interface_field AS BusSolutionQuotationProperty,
  am.SrvcTransacOneOrdDetnIdfr AS SrvcTransacOneOrdDetnIdfr,
  tf.strucobjn AS CDSView,
  oneord_fieldname AS SrvcTransactionOneOrderField,
  oneord_bt_subobj AS SrvcTransOneOrderSubObj,
  am.SrvcTransacOneOrdDetermination AS SrvcTransacOneOrdDetermination
FROM crms4s_1o_api_mp AS mp
INNER JOIN dd03nd AS tf ON /* join condition not captured in parsed metadata */
;

Learn More