I_PurchaseOrderPartnerTP
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)
| Source | Alias | Join Type |
|---|---|---|
| R_PurchaseOrderPartner | PurchaseOrderPartner | from |
Associations (1)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [1..1] | I_PurchaseOrderTP | _PurchaseOrder | _PurchaseOrder.PurchaseOrder = $projection.PurchaseOrder |
Annotations (16)
| Name | Value | Level | Field |
|---|---|---|---|
| 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)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| 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":""
}
}*/
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA