I_PurchaseOrderPartnerTP

DDL: I_PURCHASEORDERPARTNERTP SQL: IPURORDPTNR Type: view TRANSACTIONAL

Purchase Order Partner - TP

I_PurchaseOrderPartnerTP is a Transactional CDS View that provides data about "Purchase Order Partner - TP" in SAP S/4HANA. It reads from 1 data source (R_PurchaseOrderPartner) and exposes 25 fields with key fields PurchaseOrder, PartnerFunction, PurchasingOrganization, SupplierSubrange, Plant. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
R_PurchaseOrderPartner PurchaseOrderPartner from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_PurchaseOrderTP _PurchaseOrder _PurchaseOrder.PurchaseOrder = $projection.PurchaseOrder

Annotations (16)

NameValueLevelField
VDM.viewType #TRANSACTIONAL view
AbapCatalog.sqlViewName IPURORDPTNR view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Purchase Order Partner - TP view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.createEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.writeDraftPersistence PURORDPTNR_D view
AbapCatalog.preserveKey true view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder R_PurchaseOrderPartner PurchaseOrder
KEY PartnerFunction R_PurchaseOrderPartner PartnerFunction
KEY PurchasingOrganization R_PurchaseOrderPartner PurchasingOrganization
KEY SupplierSubrange R_PurchaseOrderPartner SupplierSubrange
KEY Plant R_PurchaseOrderPartner Plant
KEY PartnerCounter R_PurchaseOrderPartner PartnerCounter
CreatedByUser R_PurchaseOrderPartner CreatedByUser
CreationDate R_PurchaseOrderPartner CreationDate
PurchasingDocumentPartnerType R_PurchaseOrderPartner PurchasingDocumentPartnerType
Supplier R_PurchaseOrderPartner Supplier
SupplierHierarchyCategory R_PurchaseOrderPartner SupplierHierarchyCategory
SupplierContact R_PurchaseOrderPartner SupplierContact
PersonWorkAgreement R_PurchaseOrderPartner PersonWorkAgreement
EmploymentInternalID R_PurchaseOrderPartner EmploymentInternalID
DefaultPartner R_PurchaseOrderPartner DefaultPartner
PartnerFunctionForEdit R_PurchaseOrderPartner PartnerFunction
PartnerFunctionName
_PartnerFunction R_PurchaseOrderPartner _PartnerFunction
_PersonWorkAgreement R_PurchaseOrderPartner _PersonWorkAgreement
_Plant R_PurchaseOrderPartner _Plant
_PurchasingOrganization R_PurchaseOrderPartner _PurchasingOrganization
_Supplier R_PurchaseOrderPartner _Supplier
_SupplierContact R_PurchaseOrderPartner _SupplierContact
_PartnerFunctionText R_PurchaseOrderPartner _PartnerFunctionText
_PurchaseOrder _PurchaseOrder
@VDM.viewType: #TRANSACTIONAL
@AbapCatalog.sqlViewName: 'IPURORDPTNR'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Purchase Order Partner - TP'
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@AccessControl.personalData.blocking: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel: {
    createEnabled : true,
    deleteEnabled : true,
    updateEnabled : true
}
@ObjectModel.semanticKey: ['PurchaseOrder']
@ObjectModel.writeDraftPersistence: 'PURORDPTNR_D'
@AbapCatalog.preserveKey:true



define view I_PurchaseOrderPartnerTP
  as select from R_PurchaseOrderPartner as PurchaseOrderPartner
  association [1..1] to I_PurchaseOrderTP as _PurchaseOrder on _PurchaseOrder.PurchaseOrder = $projection.PurchaseOrder
{

  key PurchaseOrderPartner.PurchaseOrder,
      @ObjectModel.readOnly: true
  key PurchaseOrderPartner.PartnerFunction,
  key PurchaseOrderPartner.PurchasingOrganization,
  key PurchaseOrderPartner.SupplierSubrange,
  key PurchaseOrderPartner.Plant,
  key PurchaseOrderPartner.PartnerCounter,
      PurchaseOrderPartner.CreatedByUser,
      PurchaseOrderPartner.CreationDate,
      PurchaseOrderPartner.PurchasingDocumentPartnerType,
      PurchaseOrderPartner.Supplier,
      PurchaseOrderPartner.SupplierHierarchyCategory,
      PurchaseOrderPartner.SupplierContact,
      PurchaseOrderPartner.PersonWorkAgreement,
      PurchaseOrderPartner.EmploymentInternalID,
      PurchaseOrderPartner.DefaultPartner,
      @ObjectModel.editableFieldFor: 'PartnerFunction'
      PurchaseOrderPartner.PartnerFunction                                                               as PartnerFunctionForEdit,
      @ObjectModel.text.association: '_PartnerFunctionText'
      PurchaseOrderPartner._PartnerFunctionText[Language = $session.system_language].PartnerFunctionName as PartnerFunctionName,
      @ObjectModel.text.element:  [ 'PurchasingDocumentPartnerName' ]
      cast( case PurchasingDocumentPartnerType
        when 'LI' then PurchaseOrderPartner.Supplier
        when 'AP' then PurchaseOrderPartner.SupplierContact
        when 'PE' then PurchaseOrderPartner.PersonWorkAgreement
      end as mm_pur_partner )                                                                            as PurchasingDocumentPartner,

      cast( case PurchasingDocumentPartnerType
        when 'LI' then PurchaseOrderPartner._Supplier.SupplierFullName
        when 'AP' then PurchaseOrderPartner._SupplierContact.BusinessPartnerName
        when 'PE' then PurchaseOrderPartner._PersonWorkAgreement.PersonFullName
      end as mm_pur_partnername )                                                                        as PurchasingDocumentPartnerName,
      /* Associations */
      PurchaseOrderPartner._PartnerFunction,
      PurchaseOrderPartner._PersonWorkAgreement,
      PurchaseOrderPartner._Plant,
      PurchaseOrderPartner._PurchasingOrganization,
      PurchaseOrderPartner._Supplier,
      PurchaseOrderPartner._SupplierContact,
      PurchaseOrderPartner._PartnerFunctionText,
      @ObjectModel.association.type: [ #TO_COMPOSITION_PARENT, #TO_COMPOSITION_ROOT ]
      _PurchaseOrder

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PARTNERFUNCTIONTEXT",
"I_PERSONWORKAGREEMENT_1",
"I_SUPPLIER",
"I_SUPPLIERCONTACT",
"R_PURCHASEORDERPARTNER"
],
"ASSOCIATED":
[
"I_PARTNERFUNCTION",
"I_PARTNERFUNCTIONTEXT",
"I_PERSONWORKAGREEMENT_1",
"I_PLANT",
"I_PURCHASEORDERTP",
"I_PURCHASINGORGANIZATION",
"I_SUPPLIER",
"I_SUPPLIERCONTACT"
],
"BASE":
[
"R_PURCHASEORDERPARTNER"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/