R_PurContrAccountTP

DDL: R_PURCONTRACCOUNTTP Type: view_entity TRANSACTIONAL

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.

Data Sources (1)

SourceAliasJoin Type
I_PurCtrAccount I_PurCtrAccount from

Annotations (10)

NameValueLevelField
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)

KeyFieldSource TableSource FieldDescription
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
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_COMMITMENTITEM",
"I_PURCTRACCOUNT",
"I_WBSELEMENTBASICDATA",
"R_PURCHASECONTRACTITEMTP",
"R_PURCHASECONTRACTTP"
],
"ASSOCIATED":
[
"R_PURCHASECONTRACTITEMTP",
"R_PURCHASECONTRACTTP"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/