C_SrcgProjLglTransactionFacet

DDL: C_SRCGPROJLGLTRANSACTIONFACET Type: view_entity CONSUMPTION Package: ODATA_MM_PUR_SRCGPROJ_MAINTAIN
28 Fields 1 Data Sources 2 Associations 2 OData Services

Legal Transaction in Sourcing Project

C_SrcgProjLglTransactionFacet is a Consumption CDS View that provides data about "Legal Transaction in Sourcing Project" in SAP S/4HANA. It reads from 1 data source (C_LegalTransactionIntegFacet) and exposes 28 fields with key fields LegalTransactionUUID, LegalTransactionLinkdObjUUID. It has 2 associations to related views. It is exposed through 2 OData services (UI_SOURCINGPROJECT_MANAGE, UI_SRCGPROJ_CONTRIBUTE). Part of development package ODATA_MM_PUR_SRCGPROJ_MAINTAIN.

Data Sources (1)

SourceAliasJoin Type
C_LegalTransactionIntegFacet C_LegalTransactionIntegFacet from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_LegalTransaction _LegalTransaction $projection.LegalTransactionUUID = _LegalTransaction.LegalTransactionUUID
[0..*] C_LegalDocumentIntegFacet _LegalDocumentIntegFacet $projection.LegalTransactionUUID = _LegalDocumentIntegFacet.LegalTransactionUUID and $projection.LglCntntMIntegrationLink = _LegalDocumentIntegFacet.LglCntntMIntegrationLink and $projection.LglCntntMLinkdObj = _LegalDocumentIntegFacet.LglCntntMLinkdObj

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
Metadata.allowExtensions true view
EndUserText.label Legal Transaction in Sourcing Project view
VDM.viewType #CONSUMPTION view
ObjectModel.representativeKey LegalTransactionLinkdObjUUID view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view

OData Services (2)

ServiceBindingVersionContractRelease
UI_SOURCINGPROJECT_MANAGE UI_SOURCINGPROJECT_MANAGE V2 C1 NOT_RELEASED
UI_SRCGPROJ_CONTRIBUTE UI_SRCGPROJ_CONTRIBUTE V2 C1 NOT_RELEASED

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY LegalTransactionUUID LegalTransactionUUID Universal Unique ID
KEY LegalTransactionLinkdObjUUID LegalTransactionLinkdObjUUID Universal Unique ID
LglCntntMLinkdObj LglCntntMLinkdObj Unique ID
LglCntntMIntegrationLink LglCntntMIntegrationLink Integration Link
LegalTransaction LegalTransaction Legal Transaction ID
LegalTransactionTitle LegalTransactionTitle Title
LegalTransactionHealth LegalTransactionHealth LT Status
LglTransHealthCriticality LglTransHealthCriticality
LegalTransactionHealthName
LglCntntMLanguage LglCntntMLanguage Language
LanguageName
LglCntntMMainOrgType LglCntntMMainOrgType Main Organisation Ty
LglCntntMMainOrg LglCntntMMainOrg
LegalTransactionIsTriggerObj LegalTransactionIsTriggerObj Trigger Object
LglCntntMLglTransUpdtIsRqd LglCntntMLglTransUpdtIsRqd
LegalDocument
NumberOfDocuments
DocumentDescription
LglTransAccessLvl LglTransAccessLvl Acs. Level
LglCntntMProfile LglCntntMProfile Profile
LglCntntMMainOrgSalesOrg LglCntntMMainOrgSalesOrg Entity ID
LglCntntMMainOrgPurOrg LglCntntMMainOrgPurOrg Entity ID
LglCntntMMainOrgCoCode LglCntntMMainOrgCoCode Entity ID
IsEndOfPurposeBlocked IsEndOfPurposeBlocked Busin. Purp. Cmpltd.
_LegalTransactionHealthText _LegalTransactionHealthText
_Language _Language
_LglCntntMMainOrgTypeText _LglCntntMMainOrgTypeText
_LegalDocumentIntegFacet _LegalDocumentIntegFacet

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 C_SrcgProjLglTransactionFacet.
-- 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 C_SrcgProjLglTransactionFacet AS
SELECT
  LegalTransactionUUID,
  LegalTransactionLinkdObjUUID,
  LglCntntMLinkdObj,
  LglCntntMIntegrationLink,
  LegalTransaction,
  LegalTransactionTitle,
  LegalTransactionHealth,
  LglTransHealthCriticality,
  _LegalTransactionHealthText[1:Language = $session.system_language ].LegalTransactionHealthName AS LegalTransactionHealthName,
  LglCntntMLanguage,
  _Language._Text[1:Language = $session.system_language ].LanguageName AS LanguageName,
  LglCntntMMainOrgType,
  LglCntntMMainOrg,
  LegalTransactionIsTriggerObj,
  LglCntntMLglTransUpdtIsRqd,
  cast( '' as lcm_document_id ) AS LegalDocument,
  cast( 0 as abap.int1 ) AS NumberOfDocuments,
  cast( '' as lcm_description ) AS DocumentDescription,
  LglTransAccessLvl,
  LglCntntMProfile,
  LglCntntMMainOrgSalesOrg,
  LglCntntMMainOrgPurOrg,
  LglCntntMMainOrgCoCode,
  IsEndOfPurposeBlocked
FROM C_LegalTransactionIntegFacet
LEFT OUTER JOIN I_LegalTransaction AS _LegalTransaction ON LegalTransactionUUID = _LegalTransaction.LegalTransactionUUID  -- association [1..1]
LEFT OUTER JOIN C_LegalDocumentIntegFacet AS _LegalDocumentIntegFacet ON LegalTransactionUUID = _LegalDocumentIntegFacet.LegalTransactionUUID AND LglCntntMIntegrationLink = _LegalDocumentIntegFacet.LglCntntMIntegrationLink AND LglCntntMLinkdObj = _LegalDocumentIntegFacet.LglCntntMLinkdObj  -- association [0..*]
;

Learn More