I_Purctrpartners

DDL: I_PURCTRPARTNERS SQL: ICTRPRTNRS Type: view COMPOSITE

Interface view for partners

I_Purctrpartners is a Composite CDS View that provides data about "Interface view for partners" in SAP S/4HANA. It reads from 1 data source (I_PurgDocumentPartnerEnh) and exposes 29 fields with key fields PurchaseContract, PurchaseContractItem, PurchasingOrganization, SupplierSubrange, Plant. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_PurgDocumentPartnerEnh I_PurgDocumentPartnerEnh from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_PurchaseContract _PurchaseContract _PurchaseContract.PurchaseContract = $projection.PurchaseContract

Annotations (9)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
AbapCatalog.sqlViewName ICTRPRTNRS view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Interface view for partners view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #XL view

Fields (29)

KeyFieldSource TableSource FieldDescription
KEY PurchaseContract I_PurgDocumentPartnerEnh PurchasingDocument
KEY PurchaseContractItem I_PurgDocumentPartnerEnh PurchasingDocumentItem
KEY PurchasingOrganization I_PurgDocumentPartnerEnh PurchasingOrganization
KEY SupplierSubrange I_PurgDocumentPartnerEnh SupplierSubrange
KEY Plant I_PurgDocumentPartnerEnh Plant
KEY PartnerFunction I_PurgDocumentPartnerEnh PartnerFunction
KEY PartnerCounter I_PurgDocumentPartnerEnh PartnerCounter
PartnerFunctionLanguageDepdnt
PurchasingDocumentCategory I_PurgDocumentPartnerEnh PurchasingDocumentCategory
PurchaseContractType I_PurgDocumentPartnerEnh PurchasingDocumentType
PurchasingDocumentType I_PurgDocumentPartnerEnh PurchasingDocumentType
CreatedByUser I_PurgDocumentPartnerEnh CreatedByUser
CreationDate I_PurgDocumentPartnerEnh CreationDate
Supplier I_PurgDocumentPartnerEnh Supplier
SupplierContact I_PurgDocumentPartnerEnh SupplierContact
EmploymentInternalID I_PurgDocumentPartnerEnh PersonWorkAgreement
DefaultPartner I_PurgDocumentPartnerEnh DefaultPartner
PurchasingDocumentPartner I_PurgDocumentPartnerEnh PurchasingDocumentPartner
PurchasingDocumentPartnerName I_PurgDocumentPartnerEnh PurchasingDocumentPartnerName
_PersonWorkAgreement I_PurgDocumentPartnerEnh _PersonWorkAgreement
_PartnerFunction I_PurgDocumentPartnerEnh _PartnerFunction
_PartnerFunctionText I_PurgDocumentPartnerEnh _PartnerFunctionText
_Plant I_PurgDocumentPartnerEnh _Plant
_PurchasingDocument I_PurgDocumentPartnerEnh _PurchasingDocument
_PurchasingDocumentItem I_PurgDocumentPartnerEnh _PurchasingDocumentItem
_PurchasingOrganization I_PurgDocumentPartnerEnh _PurchasingOrganization
_Supplier I_PurgDocumentPartnerEnh _Supplier
_SupplierContact I_PurgDocumentPartnerEnh _SupplierContact
_PurchaseContract _PurchaseContract
@ClientHandling.algorithm: #SESSION_VARIABLE //Inserted by VDM CDS Suite Plugin

@ObjectModel.usageType.serviceQuality: #D
@AbapCatalog.sqlViewName: 'ICTRPRTNRS'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Interface view for partners'
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.sizeCategory: #XL

@AccessControl.personalData.blocking: #('TRANSACTIONAL_DATA')
//@VDM.lifecycle.contract.type: #SAP_INTERNAL_API


define view I_Purctrpartners
  as select from I_PurgDocumentPartnerEnh
  association [1..1] to I_PurchaseContract as _PurchaseContract on _PurchaseContract.PurchaseContract = $projection.PurchaseContract

  //  association [1..1] to I_PurchaseContractItem as _PurchaseContractItem on  _PurchaseContractItem.PurchaseContract     = $projection.PurchaseContract

  //                                                                        and _PurchaseContractItem.PurchaseContractItem = $projection.PurchaseContractItem

{
  key I_PurgDocumentPartnerEnh.PurchasingDocument     as PurchaseContract,
  key I_PurgDocumentPartnerEnh.PurchasingDocumentItem as PurchaseContractItem,
  key I_PurgDocumentPartnerEnh.PurchasingOrganization,
  key I_PurgDocumentPartnerEnh.SupplierSubrange,
  key I_PurgDocumentPartnerEnh.Plant,
  key I_PurgDocumentPartnerEnh.PartnerFunction,
  key I_PurgDocumentPartnerEnh.PartnerCounter,
  
      I_PurgDocumentPartnerEnh._PartnerFunction._PartnerFunctionLangDepdnt[Language = $session.system_language].PartnerFunctionLanguageDepdnt,
      I_PurgDocumentPartnerEnh.PurchasingDocumentCategory,

      //Removed PurchasingDocumentType and added _PurchaseContract.PurchaseContractType to have same DCL as headers for CDS hardening

      I_PurgDocumentPartnerEnh.PurchasingDocumentType as PurchaseContractType,
      // added to remove atc errors

      I_PurgDocumentPartnerEnh.PurchasingDocumentType,
      //      _PurchaseContract.PurchaseContractType,


      @Semantics.user.createdBy: true
      I_PurgDocumentPartnerEnh.CreatedByUser,

      @Semantics.businessDate.createdAt: true
      I_PurgDocumentPartnerEnh.CreationDate,
      //    I_PurgDocumentPartnerEnh.PurchasingDocumentPartnerType,

      I_PurgDocumentPartnerEnh.Supplier,
      I_PurgDocumentPartnerEnh.SupplierContact,
      I_PurgDocumentPartnerEnh.PersonWorkAgreement as EmploymentInternalID,
      //deprecated, replaced by PersonWorkAgreement

     //     I_PurgDocumentPartnerEnh.EmploymentInternalID,

      I_PurgDocumentPartnerEnh.DefaultPartner,
      I_PurgDocumentPartnerEnh.PurchasingDocumentPartner,
      I_PurgDocumentPartnerEnh.PurchasingDocumentPartnerName,
      I_PurgDocumentPartnerEnh._PersonWorkAgreement,
      I_PurgDocumentPartnerEnh._PartnerFunction,
      I_PurgDocumentPartnerEnh._PartnerFunctionText,
      //    I_PurgDocumentPartnerEnh._PartnerTypeText,

      I_PurgDocumentPartnerEnh._Plant,
      I_PurgDocumentPartnerEnh._PurchasingDocument,
      I_PurgDocumentPartnerEnh._PurchasingDocumentItem,
      I_PurgDocumentPartnerEnh._PurchasingOrganization,
      //    I_PurgDocumentPartnerEnh._PurgDocumentPartnerVH,   //has to be defined in C-view

      I_PurgDocumentPartnerEnh._Supplier,
      I_PurgDocumentPartnerEnh._SupplierContact,
      //    I_PurgDocumentPartnerEnh._PurContrPartnerFunctionVH,   //has to be defined in C-view

      //      _PurchaseContract.PurchasingGroup,    // added for CDS Hardening


      @ObjectModel.association.type:  [#TO_COMPOSITION_PARENT, #TO_COMPOSITION_ROOT]
      _PurchaseContract
      //      _PurchaseContractItem


}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PARTNERFUNCTION",
"I_PARTNERFUNCTIONLANGDEPDNT",
"I_PURGDOCUMENTPARTNERENH"
],
"ASSOCIATED":
[
"I_PARTNERFUNCTION",
"I_PARTNERFUNCTIONTEXT",
"I_PERSONWORKAGREEMENT_1",
"I_PLANT",
"I_PURCHASECONTRACT",
"I_PURCHASINGDOCUMENT",
"I_PURCHASINGDOCUMENTITEM",
"I_PURCHASINGORGANIZATION",
"I_SUPPLIER",
"I_SUPPLIERCONTACT"
],
"BASE":
[
"I_PURGDOCUMENTPARTNERENH"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/