R_PurContrAccountTP
Purchase Contract Account
R_PurContrAccountTP is a Transactional CDS View that provides data about "Purchase Contract Account" in SAP S/4HANA. It reads from 1 data source (I_PurCtrAccount) and exposes 51 fields with key fields AccountAssignmentNumber, PurchaseContractItem, PurchaseContract. Part of development package RAP_MM_PUR_CONTRACT.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_PurCtrAccount | I_PurCtrAccount | from |
Annotations (10)
| Name | Value | Level | Field |
|---|---|---|---|
| AccessControl.authorizationCheck | #CHECK | view | |
| AccessControl.personalData.blocking | #REQUIRED | view | |
| EndUserText.label | Purchase Contract Account | view | |
| VDM.viewType | #TRANSACTIONAL | view | |
| VDM.lifecycle.contract.type | #SAP_INTERNAL_API | view | |
| ObjectModel.representativeKey | AccountAssignmentNumber | view | |
| ObjectModel.usageType.serviceQuality | #C | view | |
| ObjectModel.usageType.sizeCategory | #L | view | |
| ObjectModel.usageType.dataClass | #MIXED | view | |
| Metadata.ignorePropagatedAnnotations | true | view |
Fields (51)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | AccountAssignmentNumber | I_PurCtrAccount | AccountAssignment | |
| KEY | PurchaseContractItem | I_PurCtrAccount | PurchaseContractItem | |
| KEY | PurchaseContract | I_PurCtrAccount | PurchaseContract | |
| CostCenter | I_PurCtrAccount | CostCenter | ||
| MasterFixedAsset | I_PurCtrAccount | MasterFixedAsset | ||
| ProjectNetwork | I_PurCtrAccount | ProjectNetwork | ||
| Quantity | I_PurCtrAccount | Quantity | ||
| OrderQuantityUnit | I_PurCtrAccount | OrderQuantityUnit | ||
| MultipleAcctAssgmtDistrPercent | I_PurCtrAccount | MultipleAcctAssgmtDistrPercent | ||
| PurgDocNetAmount | I_PurCtrAccount | PurgDocNetAmount | ||
| DocumentCurrency | I_PurCtrAccount | DocumentCurrency | ||
| IsDeleted | I_PurCtrAccount | IsDeleted | ||
| GLAccount | I_PurCtrAccount | GLAccount | ||
| BusinessArea | I_PurCtrAccount | BusinessArea | ||
| SalesOrder | I_PurCtrAccount | SalesOrder | ||
| SalesOrderItem | I_PurCtrAccount | SalesOrderItem | ||
| SalesOrderScheduleLine | I_PurCtrAccount | SalesOrderScheduleLine | ||
| FixedAsset | I_PurCtrAccount | FixedAsset | ||
| OrderID | I_PurCtrAccount | OrderID | ||
| UnloadingPointName | I_PurCtrAccount | UnloadingPointName | ||
| ControllingArea | I_PurCtrAccount | ControllingArea | ||
| CostObject | I_PurCtrAccount | CostObject | ||
| ProfitCenter | I_PurCtrAccount | ProfitCenter | ||
| WBSElementInternalID | I_WBSElementBasicData | WBSElementInternalID | ||
| WBSDescription | I_WBSElementBasicData | WBSDescription | ||
| ProjectNetworkInternalID | I_PurCtrAccount | ProjectNetworkInternalID | ||
| CommitmentItemShortID | I_PurCtrAccount | CommitmentItemShortID | ||
| FundsCenter | I_PurCtrAccount | FundsCenter | ||
| Fund | I_PurCtrAccount | Fund | ||
| FunctionalArea | I_PurCtrAccount | FunctionalArea | ||
| LastChangedDate | I_PurCtrAccount | LastChangedDate | ||
| GoodsRecipientName | I_PurCtrAccount | GoodsRecipientName | ||
| IsFinallyInvoiced | I_PurCtrAccount | IsFinallyInvoiced | ||
| NetworkActivityInternalID | I_PurCtrAccount | NetworkActivityInternalID | ||
| PartnerAccountNumber | I_PurCtrAccount | PartnerAccountNumber | ||
| JointVentureRecoveryCode | I_PurCtrAccount | JointVentureRecoveryCode | ||
| SettlementReferenceDate | I_PurCtrAccount | SettlementReferenceDate | ||
| OrderInternalID | I_PurCtrAccount | OrderInternalID | ||
| OrderIntBillOfOperationsItem | I_PurCtrAccount | OrderIntBillOfOperationsItem | ||
| TaxCode | I_PurCtrAccount | TaxCode | ||
| TaxJurisdiction | I_PurCtrAccount | TaxJurisdiction | ||
| NonDeductibleInputTaxAmount | I_PurCtrAccount | NonDeductibleInputTaxAmount | ||
| CostCtrActivityType | I_PurCtrAccount | CostCtrActivityType | ||
| BusinessProcess | I_PurCtrAccount | BusinessProcess | ||
| GrantID | I_PurCtrAccount | GrantID | ||
| BudgetPeriod | I_PurCtrAccount | BudgetPeriod | ||
| EarmarkedFundsDocument | I_PurCtrAccount | EarmarkedFundsDocument | ||
| ValidityDate | I_PurCtrAccount | ValidityDate | ||
| LastChangeDateTime | _PurContract | LastChangeDateTime | ||
| _PurContract | _PurContract | |||
| _PurchaseContractItem | _PurchaseContractItem |
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@EndUserText.label: 'Purchase Contract Account'
@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@ObjectModel.semanticKey: [ 'AccountAssignmentNumber','PurchaseContractItem','PurchaseContract' ]
@ObjectModel.representativeKey: 'AccountAssignmentNumber'
@ObjectModel.usageType:{
serviceQuality: #C,
sizeCategory: #L,
dataClass: #MIXED
}
@Metadata.ignorePropagatedAnnotations: true
define view entity R_PurContrAccountTP
as select from I_PurCtrAccount
left outer to one join I_CommitmentItem on I_PurCtrAccount.CommitmentItem = I_CommitmentItem.CommitmentItem
left outer to one join I_WBSElementBasicData on I_PurCtrAccount.WBSElementInternalID = I_WBSElementBasicData.WBSElementInternalID
association to parent R_PurchaseContractItemTP as _PurchaseContractItem on _PurchaseContractItem.PurchaseContract = $projection.PurchaseContract
and _PurchaseContractItem.PurchaseContractItem = $projection.PurchaseContractItem
association to R_PurchaseContractTP as _PurContract on _PurContract.PurchaseContract = $projection.PurchaseContract
{
key I_PurCtrAccount.AccountAssignment as AccountAssignmentNumber,
@ObjectModel.foreignKey.association: '_PurchaseContractItem'
key I_PurCtrAccount.PurchaseContractItem,
@ObjectModel.foreignKey.association: '_PurContract'
key I_PurCtrAccount.PurchaseContract,
I_PurCtrAccount.CostCenter,
I_PurCtrAccount.MasterFixedAsset,
I_PurCtrAccount.ProjectNetwork,
@Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
I_PurCtrAccount.Quantity,
I_PurCtrAccount.OrderQuantityUnit,
I_PurCtrAccount.MultipleAcctAssgmtDistrPercent,
@Semantics.amount.currencyCode: 'DocumentCurrency'
I_PurCtrAccount.PurgDocNetAmount,
I_PurCtrAccount.DocumentCurrency,
I_PurCtrAccount.IsDeleted,
I_PurCtrAccount.GLAccount,
I_PurCtrAccount.BusinessArea,
I_PurCtrAccount.SalesOrder,
I_PurCtrAccount.SalesOrderItem,
I_PurCtrAccount.SalesOrderScheduleLine,
I_PurCtrAccount.FixedAsset,
I_PurCtrAccount.OrderID,
I_PurCtrAccount.UnloadingPointName,
I_PurCtrAccount.ControllingArea,
I_PurCtrAccount.CostObject,
// I_PurCtrAccount.ProfitabilitySegment,
I_PurCtrAccount.ProfitCenter,
I_WBSElementBasicData.WBSElementInternalID,
I_WBSElementBasicData.WBSDescription,
I_PurCtrAccount.ProjectNetworkInternalID,
I_PurCtrAccount.CommitmentItemShortID,
I_PurCtrAccount.FundsCenter,
I_PurCtrAccount.Fund,
I_PurCtrAccount.FunctionalArea,
I_PurCtrAccount.LastChangedDate,
I_PurCtrAccount.GoodsRecipientName,
I_PurCtrAccount.IsFinallyInvoiced,
// I_PurCtrAccount.RealEstateObject,
I_PurCtrAccount.NetworkActivityInternalID,
I_PurCtrAccount.PartnerAccountNumber,
I_PurCtrAccount.JointVentureRecoveryCode,
I_PurCtrAccount.SettlementReferenceDate,
I_PurCtrAccount.OrderInternalID,
I_PurCtrAccount.OrderIntBillOfOperationsItem,
I_PurCtrAccount.TaxCode,
I_PurCtrAccount.TaxJurisdiction,
@Semantics.amount.currencyCode: 'DocumentCurrency'
I_PurCtrAccount.NonDeductibleInputTaxAmount,
I_PurCtrAccount.CostCtrActivityType,
I_PurCtrAccount.BusinessProcess,
I_PurCtrAccount.GrantID,
I_PurCtrAccount.BudgetPeriod,
I_PurCtrAccount.EarmarkedFundsDocument,
I_PurCtrAccount.ValidityDate,
@Semantics.systemDateTime.lastChangedAt: true
_PurContract.LastChangeDateTime as LastChangeDateTime,
/* Associations */
_PurContract,
_PurchaseContractItem
}
where
_PurContract.PurchaseContract is not null
and _PurchaseContractItem.PurchaseContractItem is not null
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