Aps_Com_Cs_D2_Inbound_Tp

DDL: APS_COM_CS_D2_INBOUND_TP SQL: APS_COM_CS_I_T_2 Type: view Package: SR_APS_COM_CS

CS Draft 2.0 Inbound Transactional Processing

Aps_Com_Cs_D2_Inbound_Tp is a CDS View that provides data about "CS Draft 2.0 Inbound Transactional Processing" in SAP S/4HANA. It reads from 1 data source (Aps_Com_Cs_D2_Inbound) and exposes 15 fields with key field db_key. It has 1 association to related views. Part of development package SR_APS_COM_CS.

Data Sources (1)

SourceAliasJoin Type
Aps_Com_Cs_D2_Inbound Document from

Associations (1)

CardinalityTargetAliasCondition
[1..1] Aps_Com_Cs_D2_Root_Tp _Root _Root.db_key = $projection.parent_key

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName APS_COM_CS_I_T_2 view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label CS Draft 2.0 Inbound Transactional Processing view
Metadata.allowExtensions true view
ObjectModel.transactionalProcessingEnabled true view
ObjectModel.writeActivePersistence APS_CS_D_INBOUND view
ObjectModel.writeDraftPersistence APS_CS_D_IB_D2 view
ObjectModel.semanticKey CommSystInboundUserName view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled EXTERNAL_CALCULATION view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY db_key Aps_Com_Cs_D2_Inbound db_key UUID
parent_key Aps_Com_Cs_D2_Inbound parent_key UUID
CommSystInboundUserName Aps_Com_Cs_D2_Inbound CommSystInboundUserName
SystemAuthenticationMode Aps_Com_Cs_D2_Inbound SystemAuthenticationMode
CommSystInboundUserDesc Aps_Com_Cs_D2_Inbound CommSystInboundUserDesc
OAuth2GrantType Aps_Com_Cs_D2_Inbound OAuth2GrantType
OAuth2ClientId Aps_Com_Cs_D2_Inbound OAuth2ClientId
OAuth2RefreshAllowed Aps_Com_Cs_D2_Inbound OAuth2RefreshAllowed
OAuth2RefreshExpiry Aps_Com_Cs_D2_Inbound OAuth2RefreshExpiry
OAuth2RefreshExpiryUnit Aps_Com_Cs_D2_Inbound OAuth2RefreshExpiryUnit
CreationDateTime Aps_Com_Cs_D2_Inbound CreationDateTime Timestamp
CreatedByUser Aps_Com_Cs_D2_Inbound CreatedByUser User Name
LastChangeDateTime Aps_Com_Cs_D2_Inbound LastChangeDateTime Timestamp
LastChangedByUser Aps_Com_Cs_D2_Inbound LastChangedByUser User Name
_Root _Root

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 Aps_Com_Cs_D2_Inbound_Tp.
-- 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: APS_COM_CS_I_T_2

CREATE VIEW Aps_Com_Cs_D2_Inbound_Tp AS
SELECT
  Document.db_key AS db_key,
  Document.parent_key AS parent_key,
  Document.CommSystInboundUserName AS CommSystInboundUserName,
  Document.SystemAuthenticationMode AS SystemAuthenticationMode,
  Document.CommSystInboundUserDesc AS CommSystInboundUserDesc,
  Document.OAuth2GrantType AS OAuth2GrantType,
  Document.OAuth2ClientId AS OAuth2ClientId,
  Document.OAuth2RefreshAllowed AS OAuth2RefreshAllowed,
  Document.OAuth2RefreshExpiry AS OAuth2RefreshExpiry,
  Document.OAuth2RefreshExpiryUnit AS OAuth2RefreshExpiryUnit,
  Document.CreationDateTime AS CreationDateTime,
  Document.CreatedByUser AS CreatedByUser,
  Document.LastChangeDateTime AS LastChangeDateTime,
  Document.LastChangedByUser AS LastChangedByUser
FROM Aps_Com_Cs_D2_Inbound AS Document
LEFT OUTER JOIN Aps_Com_Cs_D2_Root_Tp AS _Root ON _Root.db_key = parent_key  -- association [1..1]
;