I_PurctrpartnersWithDraft

DDL: I_PURCTRPARTNERSWITHDRAFT SQL: ICTRPRTNRSWD Type: view TRANSACTIONAL Package: APPL_MM_PUR_OA

Interface view for partners with Draft

I_PurctrpartnersWithDraft is a Transactional CDS View that provides data about "Interface view for partners with Draft" in SAP S/4HANA. It reads from 1 data source (I_Purctrpartners) and exposes 35 fields with key fields PurchaseContract, PurchaseContractItem, PurchasingOrganization, SupplierSubrange, Plant. It has 11 associations to related views. Part of development package APPL_MM_PUR_OA.

Data Sources (1)

SourceAliasJoin Type
I_Purctrpartners Document from

Associations (11)

CardinalityTargetAliasCondition
[0..1] I_PersonWorkAgreement_1 _Employment _Employment.PersonWorkAgreement = $projection.EmploymentInternalID
[0..1] I_PartnerFunction _PartnerFunction _PartnerFunction.PartnerFunction = $projection.PartnerFunction
[0..*] I_PartnerFunctionText _PartnerFunctionText _PartnerFunctionText.PartnerFunction = $projection.PartnerFunction
[0..*] I_PartnerTypeText _PartnerTypeText _PartnerTypeText.PurchasingDocumentPartnerType = $projection.PurchasingDocumentPartnerType
[0..1] I_Plant _Plant _Plant.Plant = $projection.PlantForEdit
[0..1] I_PurchasingDocument _PurchasingDocument _PurchasingDocument.PurchasingDocument = $projection.PurchaseContract
[0..1] I_PurchasingDocumentItem _PurchasingDocumentItem _PurchasingDocumentItem.PurchasingDocument = $projection.PurchaseContract and _PurchasingDocumentItem.PurchasingDocumentItem = $projection.PurchaseContractItem
[0..1] I_PurchasingOrganization _PurchasingOrganization _PurchasingOrganization.PurchasingOrganization = $projection.PurchasingOrganizationForEdit
[0..1] I_Supplier _Supplier _Supplier.Supplier = $projection.Supplier
[0..1] I_Suppliercontact _SupplierContact _SupplierContact.SupplierContact = $projection.SupplierContact
[1..1] I_PurchaseContractWD _PurchaseContractWD _PurchaseContractWD.PurchaseContract = $projection.PurchaseContract

Annotations (14)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.createEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.writeDraftPersistence PURCTR_HDR_PRT_D view
AbapCatalog.sqlViewName ICTRPRTNRSWD view
EndUserText.label Interface view for partners with Draft view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #TRANSACTIONAL view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.draftEnabled true view

Fields (35)

KeyFieldSource TableSource FieldDescription
KEY PurchaseContract I_Purctrpartners PurchaseContract
KEY PurchaseContractItem I_Purctrpartners PurchaseContractItem
KEY PurchasingOrganization I_Purctrpartners PurchasingOrganization
KEY SupplierSubrange I_Purctrpartners SupplierSubrange
KEY Plant I_Purctrpartners Plant
KEY PartnerFunction I_Purctrpartners PartnerFunction
KEY PartnerCounter I_Purctrpartners PartnerCounter
PurchasingOrganizationForEdit I_Purctrpartners PurchasingOrganization
SupplierSubrangeForEdit I_Purctrpartners SupplierSubrange
PlantForEdit I_Purctrpartners Plant
PartnerFunctionForEdit I_Purctrpartners PartnerFunctionLanguageDepdnt
PartnerCounterForEdit I_Purctrpartners PartnerCounter
PurchasingDocumentCategory I_Purctrpartners PurchasingDocumentCategory
PurchaseContractType I_Purctrpartners PurchaseContractType
PurchasingDocumentType I_Purctrpartners PurchasingDocumentType
CreatedByUser I_Purctrpartners CreatedByUser
CreationDate I_Purctrpartners CreationDate
PurchasingDocumentPartnerType _PartnerFunction SDDocumentPartnerType
Supplier I_Purctrpartners Supplier
SupplierContact I_Purctrpartners SupplierContact
EmploymentInternalID I_Purctrpartners EmploymentInternalID
DefaultPartner I_Purctrpartners DefaultPartner
PurchasingDocumentPartner I_Purctrpartners PurchasingDocumentPartner
PurchasingDocumentPartnerName I_Purctrpartners PurchasingDocumentPartnerName
_Employment _Employment
_PartnerFunction _PartnerFunction
_PartnerFunctionText _PartnerFunctionText
_PartnerTypeText _PartnerTypeText
_Plant _Plant
_PurchasingDocument _PurchasingDocument
_PurchasingDocumentItem _PurchasingDocumentItem
_PurchasingOrganization _PurchasingOrganization
_Supplier _Supplier
_SupplierContact _SupplierContact
_PurchaseContractWD _PurchaseContractWD
@ClientHandling.algorithm: #SESSION_VARIABLE //Inserted by VDM CDS Suite Plugin

@ObjectModel.createEnabled: true
@ObjectModel.deleteEnabled: true
@ObjectModel.updateEnabled: true
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.writeDraftPersistence: 'PURCTR_HDR_PRT_D' //Inserted by VDM CDS Suite Plugin

@AbapCatalog.sqlViewName: 'ICTRPRTNRSWD'
@EndUserText.label: 'Interface view for partners with Draft'
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.sizeCategory: #L
@VDM.viewType:#TRANSACTIONAL
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.semanticKey: ['PurchaseContract', 'PurchaseContractItem', 'PurchasingOrganization', 'SupplierSubrange', 'Plant', 'PartnerFunction', 'PartnerCounter']
@AccessControl.personalData.blocking: #REQUIRED
@ObjectModel.draftEnabled: true

define view I_PurctrpartnersWithDraft
  as select from I_Purctrpartners as Document
  association [0..1] to I_PersonWorkAgreement_1  as _Employment             on  _Employment.PersonWorkAgreement = $projection.EmploymentInternalID                                                                    
  association [0..1] to I_PartnerFunction        as _PartnerFunction        on  _PartnerFunction.PartnerFunction = $projection.PartnerFunction
  association [0..*] to I_PartnerFunctionText    as _PartnerFunctionText    on  _PartnerFunctionText.PartnerFunction = $projection.PartnerFunction
  association [0..*] to I_PartnerTypeText        as _PartnerTypeText        on  _PartnerTypeText.PurchasingDocumentPartnerType = $projection.PurchasingDocumentPartnerType
  association [0..1] to I_Plant                  as _Plant                  on  _Plant.Plant = $projection.PlantForEdit
  association [0..1] to I_PurchasingDocument     as _PurchasingDocument     on  _PurchasingDocument.PurchasingDocument = $projection.PurchaseContract
  association [0..1] to I_PurchasingDocumentItem as _PurchasingDocumentItem on  _PurchasingDocumentItem.PurchasingDocument     = $projection.PurchaseContract
                                                                            and _PurchasingDocumentItem.PurchasingDocumentItem = $projection.PurchaseContractItem
  association [0..1] to I_PurchasingOrganization as _PurchasingOrganization on  _PurchasingOrganization.PurchasingOrganization = $projection.PurchasingOrganizationForEdit

  association [0..1] to I_Supplier               as _Supplier               on  _Supplier.Supplier = $projection.Supplier

  association [0..1] to I_Suppliercontact        as _SupplierContact        on  _SupplierContact.SupplierContact = $projection.SupplierContact

  association [1..1] to I_PurchaseContractWD     as _PurchaseContractWD     on  _PurchaseContractWD.PurchaseContract = $projection.PurchaseContract
{

  key Document.PurchaseContract,

  key Document.PurchaseContractItem,

  key Document.PurchasingOrganization,

  key Document.SupplierSubrange,

  key Document.Plant,

  key Document.PartnerFunction,

  key Document.PartnerCounter,

//      Document.PurchaseContractItem            as PurchaseContractItemForEdit,

//

//      Document.PurchaseContract                as PurchaseContractForEdit,


      Document.PurchasingOrganization          as PurchasingOrganizationForEdit,

      Document.SupplierSubrange                as SupplierSubrangeForEdit,

      Document.Plant                           as PlantForEdit,
      

      Document.PartnerFunctionLanguageDepdnt   as PartnerFunctionForEdit,

      Document.PartnerCounter                  as PartnerCounterForEdit,

      Document.PurchasingDocumentCategory,

      //Removed both fields for CDS hardening because PurchaseContractType will now be taken from the i_purctrpartners

      //Document.PurchasingDocumentType,

      //_PurchaseContractWD.PurchaseContractType as PurchaseContractType,

      
      Document.PurchaseContractType as PurchaseContractType,
      // added to remove atc errors

      Document.PurchasingDocumentType,

      Document.CreatedByUser,

      Document.CreationDate,

      _PartnerFunction.SDDocumentPartnerType   as PurchasingDocumentPartnerType,

      Document.Supplier,

      Document.SupplierContact,

      Document.EmploymentInternalID,

      Document.DefaultPartner,

      Document.PurchasingDocumentPartner,

      Document.PurchasingDocumentPartnerName,
      
//      Document.PurchasingGroup,   // added for CDS Hardening



      _Employment,

      _PartnerFunction,

      _PartnerFunctionText,

      _PartnerTypeText,

      _Plant,

      _PurchasingDocument,

      _PurchasingDocumentItem,

      _PurchasingOrganization,

      _Supplier,

      _SupplierContact,


      @ObjectModel.association.type:  [#TO_COMPOSITION_PARENT, #TO_COMPOSITION_ROOT]
      _PurchaseContractWD
}