I_CePuCoDistributedContrTP

DDL: I_CEPUCODISTRIBUTEDCONTRTP SQL: ICEPUCODISTROA Type: view TRANSACTIONAL
22 Fields 1 Data Sources 6 Associations

Distributed OA for Cntrl Pur Contr - TP

I_CePuCoDistributedContrTP is a Transactional CDS View that provides data about "Distributed OA for Cntrl Pur Contr - TP" in SAP S/4HANA. It reads from 1 data source (I_CntrlPurContrDistribution) and exposes 22 fields with key fields CentralPurchaseContract, ExtContractForPurg, ProcurementHubSourceSystem, CompanyCode, PurchasingOrganization. It has 6 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_CntrlPurContrDistribution I_CntrlPurContrDistribution from

Associations (6)

CardinalityTargetAliasCondition
[1..1] I_CentralPurchaseContractTP _CentralPurchaseContractTP _CentralPurchaseContractTP.CentralPurchaseContract = $projection.CentralPurchaseContract
[0..1] I_PurgDocumentCategoryText _Text $projection.PurchasingDocumentCategory = _Text.PurchasingDocumentCategory and _Text.Language = $session.system_language
[0..1] I_CompanyCode _CompanyCode _CompanyCode.CompanyCode = $projection.CompanyCode
[0..1] I_PurchasingOrganization _PurchasingOrganization _PurchasingOrganization.PurchasingOrganization = $projection.PurchasingOrganization
[0..1] I_PurchasingGroup _PurchasingGroup _PurchasingGroup.PurchasingGroup = $projection.PurchasingGroup
[1..1] I_CePuCoDistrdContrPaytTrmsTP _CCTRDistributedContrPayTerms _CCTRDistributedContrPayTerms.CentralPurchaseContract = $projection.CentralPurchaseContract and _CCTRDistributedContrPayTerms.ExtContractForPurg = $projection.ExtContractForPurg and _CCTRDistributedContrPayTerms.ProcurementHubSourceSystem = $projection.ProcurementHubSourceSystem and _CCTRDistributedContrPayTerms.CompanyCode = $projection.CompanyCode and _CCTRDistributedContrPayTerms.PurchasingOrganization = $projection.PurchasingOrganization and _CCTRDistributedContrPayTerms.PurchasingGroup = $projection.PurchasingGroup and _CCTRDistributedContrPayTerms.DistrResponseMessageUUID = $projection.DistrResponseMessageUUID and _CCTRDistributedContrPayTerms.PurchasingDocumentCategory = $projection.PurchasingDocumentCategory and _CCTRDistributedContrPayTerms.DistributionKey = $projection.DistributionKey and _CCTRDistributedContrPayTerms.CentralPurchaseContractItem = $projection.CentralPurchaseContractItem

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName ICEPUCODISTROA view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AbapCatalog.preserveKey true view
EndUserText.label Distributed OA for Cntrl Pur Contr - TP view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.createEnabled false view
ObjectModel.updateEnabled false view
ObjectModel.deleteEnabled false view
VDM.viewType #TRANSACTIONAL view
ObjectModel.writeDraftPersistence CNTRLPCDISTROA_D view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.personalData.blocking #REQUIRED view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY CentralPurchaseContract CentralPurchaseContract Purchasing Doc.
KEY ExtContractForPurg ExtContractForPurg Contract
KEY ProcurementHubSourceSystem ProcurementHubSourceSystem Connected System ID
KEY CompanyCode CompanyCode Receiver Company Code
KEY PurchasingOrganization PurchasingOrganization Purchasing Organization
KEY PurchasingGroup PurchasingGroup Purchasing Group
KEY DistrResponseMessageUUID DistrResponseMessageUUID GUID
KEY PurchasingDocumentCategory PurchasingDocumentCategory Doc. Category
KEY DistributionKey DistributionKey Distr. Number
KEY CentralPurchaseContractItem CentralPurchaseContractItem Item in Central Purchase Contract
CntrlPurContrDistrTrggrDteTime CntrlPurContrDistrTrggrDteTime Distr Trggr Time
PurchasingDocumentCategoryName _Text PurchasingDocumentCategoryName Short Description
PurgDocItemDistributionStatus PurgDocItemDistributionStatus
SourceListIsUpdated SourceListIsUpdated Sourcelist Updated
SrceListResponseMsgUUID SrceListResponseMsgUUID GUID
SourceListChangeConfStatus SourceListChangeConfStatus Src. Lst Change Sta.
LogicalSystem LogicalSystem Logical System
CompanyCodeName _CompanyCode CompanyCodeName Company Name
PurchasingOrganizationName _PurchasingOrganization PurchasingOrganizationName Purch. Org. Name
PurchasingGroupName _PurchasingGroup PurchasingGroupName Purchasing Grp. Name
_CentralPurchaseContractTP _CentralPurchaseContractTP
_CCTRDistributedContrPayTerms _CCTRDistributedContrPayTerms

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_CePuCoDistributedContrTP.
-- 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: ICEPUCODISTROA

CREATE VIEW I_CePuCoDistributedContrTP AS
SELECT
  CentralPurchaseContract,
  ExtContractForPurg,
  ProcurementHubSourceSystem,
  CompanyCode,
  PurchasingOrganization,
  PurchasingGroup,
  DistrResponseMessageUUID,
  PurchasingDocumentCategory,
  DistributionKey,
  CentralPurchaseContractItem,
  CntrlPurContrDistrTrggrDteTime,
  _Text.PurchasingDocumentCategoryName AS PurchasingDocumentCategoryName,
  PurgDocItemDistributionStatus,
  SourceListIsUpdated,
  SrceListResponseMsgUUID,
  SourceListChangeConfStatus,
  LogicalSystem,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  _PurchasingOrganization.PurchasingOrganizationName AS PurchasingOrganizationName,
  _PurchasingGroup.PurchasingGroupName AS PurchasingGroupName
FROM I_CntrlPurContrDistribution
LEFT OUTER JOIN I_CentralPurchaseContractTP AS _CentralPurchaseContractTP ON _CentralPurchaseContractTP.CentralPurchaseContract = CentralPurchaseContract  -- association [1..1]
LEFT OUTER JOIN I_PurgDocumentCategoryText AS _Text ON PurchasingDocumentCategory = _Text.PurchasingDocumentCategory AND _Text.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON _CompanyCode.CompanyCode = CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_PurchasingOrganization AS _PurchasingOrganization ON _PurchasingOrganization.PurchasingOrganization = PurchasingOrganization  -- association [0..1]
LEFT OUTER JOIN I_PurchasingGroup AS _PurchasingGroup ON _PurchasingGroup.PurchasingGroup = PurchasingGroup  -- association [0..1]
LEFT OUTER JOIN I_CePuCoDistrdContrPaytTrmsTP AS _CCTRDistributedContrPayTerms ON _CCTRDistributedContrPayTerms.CentralPurchaseContract = CentralPurchaseContract AND _CCTRDistributedContrPayTerms.ExtContractForPurg = ExtContractForPurg AND _CCTRDistributedContrPayTerms.ProcurementHubSourceSystem = ProcurementHubSourceSystem AND _CCTRDistributedContrPayTerms.CompanyCode = CompanyCode AND _CCTRDistributedContrPayTerms.PurchasingOrganization = PurchasingOrganization AND _CCTRDistributedContrPayTerms.PurchasingGroup = PurchasingGroup AND _CCTRDistributedContrPayTerms.DistrResponseMessageUUID = DistrResponseMessageUUID AND _CCTRDistributedContrPayTerms.PurchasingDocumentCategory = PurchasingDocumentCategory AND _CCTRDistributedContrPayTerms.DistributionKey = DistributionKey AND _CCTRDistributedContrPayTerms.CentralPurchaseContractItem = CentralPurchaseContractItem  -- association [1..1]
;

Learn More