Aps_Com_Cs_D2_Outbound_Tp

DDL: APS_COM_CS_D2_OUTBOUND_TP SQL: APS_COM_CS_O_T_2 Type: view Package: SR_APS_COM_CS

CS Draft 2.0 Outbound Transaction Proc.

Aps_Com_Cs_D2_Outbound_Tp is a CDS View that provides data about "CS Draft 2.0 Outbound Transaction Proc." in SAP S/4HANA. It reads from 1 data source (Aps_Com_Cs_D2_Outbound) and exposes 14 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_Outbound 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_O_T_2 view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label CS Draft 2.0 Outbound Transaction Proc. view
Metadata.allowExtensions true view
ObjectModel.transactionalProcessingEnabled true view
ObjectModel.writeActivePersistence APS_CS_D_OUTBND view
ObjectModel.writeDraftPersistence APS_CS_D_OB_D2 view
ObjectModel.semanticKey CommSystOutboundUserName view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled EXTERNAL_CALCULATION view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY db_key Aps_Com_Cs_D2_Outbound db_key UUID
parent_key Aps_Com_Cs_D2_Outbound parent_key UUID
CommSystOutboundUserName Aps_Com_Cs_D2_Outbound CommSystOutboundUserName
SystemAuthenticationMode Aps_Com_Cs_D2_Outbound SystemAuthenticationMode
CommSystOutboundUserDesc Aps_Com_Cs_D2_Outbound CommSystOutboundUserDesc
OutboundPasswordReference Aps_Com_Cs_D2_Outbound OutboundPasswordReference
CertificateUUID Aps_Com_Cs_D2_Outbound CertificateUUID
CertificateText Aps_Com_Cs_D2_Outbound CertificateText
OAuth2ClientAuthMethod Aps_Com_Cs_D2_Outbound OAuth2ClientAuthMethod
CreationDateTime Aps_Com_Cs_D2_Outbound CreationDateTime Timestamp
CreatedByUser Aps_Com_Cs_D2_Outbound CreatedByUser User Name
LastChangeDateTime Aps_Com_Cs_D2_Outbound LastChangeDateTime Timestamp
LastChangedByUser Aps_Com_Cs_D2_Outbound 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_Outbound_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_O_T_2

CREATE VIEW Aps_Com_Cs_D2_Outbound_Tp AS
SELECT
  Document.db_key AS db_key,
  Document.parent_key AS parent_key,
  Document.CommSystOutboundUserName AS CommSystOutboundUserName,
  Document.SystemAuthenticationMode AS SystemAuthenticationMode,
  Document.CommSystOutboundUserDesc AS CommSystOutboundUserDesc,
  Document.OutboundPasswordReference AS OutboundPasswordReference,
  Document.CertificateUUID AS CertificateUUID,
  Document.CertificateText AS CertificateText,
  Document.OAuth2ClientAuthMethod AS OAuth2ClientAuthMethod,
  Document.CreationDateTime AS CreationDateTime,
  Document.CreatedByUser AS CreatedByUser,
  Document.LastChangeDateTime AS LastChangeDateTime,
  Document.LastChangedByUser AS LastChangedByUser
FROM Aps_Com_Cs_D2_Outbound AS Document
LEFT OUTER JOIN Aps_Com_Cs_D2_Root_Tp AS _Root ON _Root.db_key = parent_key  -- association [1..1]
;