I_PurContrAccountAssgmt

DDL: I_PURCONTRACCOUNTASSGMT SQL: IPCACCTASSGMT Type: view COMPOSITE

Purchase Contract Account Assignment

I_PurContrAccountAssgmt is a Composite CDS View that provides data about "Purchase Contract Account Assignment" in SAP S/4HANA. It reads from 1 data source (I_PurgDocAccountAssignment) and exposes 45 fields with key fields PurchaseContract, PurchaseContractItem, AccountAssignmentNumber. It has 2 associations to related views.

1 data source(s) 45 fields

Data Sources (1)

SourceAliasJoin Type
I_PurgDocAccountAssignment I_PurgDocAccountAssignment from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_PurchaseContract _PurchaseContract _PurchaseContract.PurchaseContract = $projection.PurchaseContract
[1..1] I_PurchaseContractItem _PurchaseContractItem _PurchaseContractItem.PurchaseContract = $projection.PurchaseContract and _PurchaseContractItem.PurchaseContractItem = $projection.PurchaseContractItem

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IPCACCTASSGMT view
VDM.viewType #COMPOSITE view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
EndUserText.label Purchase Contract Account Assignment view

Fields (45)

KeyFieldSource TableSource FieldDescription
KEY PurchaseContract PurchasingDocument
KEY PurchaseContractItem PurchasingDocumentItem
KEY AccountAssignmentNumber AccountAssignmentNumber
CostCenter CostCenter
MasterFixedAsset MasterFixedAsset
ProjectNetwork ProjectNetwork
Quantity Quantity
OrderQuantityUnit _PurchaseContractItem OrderQuantityUnit
MultipleAcctAssgmtDistrPercent MultipleAcctAssgmtDistrPercent
PurgDocNetAmount PurgDocNetAmount
DocumentCurrency _PurchaseContract DocumentCurrency
IsDeleted IsDeleted
GLAccount GLAccount
BusinessArea BusinessArea
SalesOrder SalesOrder
SalesOrderItem SalesOrderItem
SalesOrderScheduleLine SalesOrderScheduleLine
FixedAsset FixedAsset
OrderID OrderID
UnloadingPointName UnloadingPointName
ControllingArea ControllingArea
CostObject CostObject
ProfitCenter ProfitCenter
WBSElementInternalID WBSElementInternalID
WBSElementInternalID_2
CommitmentItem CommitmentItem
CommitmentItemShortID CommitmentItemShortID
FunctionalArea FunctionalArea
GoodsRecipientName GoodsRecipientName
RealEstateObject
PartnerAccountNumber PartnerAccountNumber
JointVentureRecoveryCode JointVentureRecoveryCode
SettlementReferenceDate SettlementReferenceDate
TaxCode TaxCode
TaxJurisdiction TaxJurisdiction
NonDeductibleInputTaxAmount NonDeductibleInputTaxAmount
CostCtrActivityType CostCtrActivityType
GrantID GrantID
BudgetPeriod BudgetPeriod
EarmarkedFundsDocument EarmarkedFundsDocument
FundsCenter FundsCenter
BusinessProcess BusinessProcess
_PurchaseContract _PurchaseContract
_PurchaseContractItem _PurchaseContractItem
_CommitmentItemShortID _CommitmentItemShortID 
@AbapCatalog.sqlViewName: 'IPCACCTASSGMT'
@VDM.viewType : #COMPOSITE
@Metadata.ignorePropagatedAnnotations: true
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #MIXED
@AccessControl.personalData.blocking: #('TRANSACTIONAL_DATA')
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@EndUserText.label: 'Purchase Contract Account Assignment'
define view I_PurContrAccountAssgmt
  as select from I_PurgDocAccountAssignment
  association [1..1] to I_PurchaseContract     as _PurchaseContract     on  _PurchaseContract.PurchaseContract = $projection.PurchaseContract

  association [1..1] to I_PurchaseContractItem as _PurchaseContractItem on  _PurchaseContractItem.PurchaseContract     = $projection.PurchaseContract
                                                                        and _PurchaseContractItem.PurchaseContractItem = $projection.PurchaseContractItem
{
  key PurchasingDocument     as PurchaseContract,
  key PurchasingDocumentItem as PurchaseContractItem,
  key AccountAssignmentNumber,
      CostCenter,
      MasterFixedAsset,
      ProjectNetwork,

      @Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
      Quantity,
      _PurchaseContractItem.OrderQuantityUnit,
      MultipleAcctAssgmtDistrPercent,

      @Semantics.amount.currencyCode: 'DocumentCurrency'
      PurgDocNetAmount,
      _PurchaseContract.DocumentCurrency,
      IsDeleted,
      GLAccount,
      BusinessArea,
      SalesOrder,
      SalesOrderItem,
      SalesOrderScheduleLine,
      FixedAsset,
      OrderID,
      UnloadingPointName,
      ControllingArea,
      CostObject,
      ProfitCenter,
      @VDM.lifecycle.status: #DEPRECATED
      @VDM.lifecycle.successor: 'WBSElementInternalID_2'
      WBSElementInternalID,
      
      cast( WBSElementInternalID as ps_s4_pspnr ) as WBSElementInternalID_2,
      @API.element.releaseState: #DEPRECATED
      @API.element.successor: 'CommitmentItemShortID'      
      CommitmentItem,
      CommitmentItemShortID,
      FunctionalArea,
      GoodsRecipientName,
      cast( REInternalFinNumber as imkey ) as RealEstateObject,
      PartnerAccountNumber,
      JointVentureRecoveryCode,
      SettlementReferenceDate,
      TaxCode,
      TaxJurisdiction,

      @Semantics.amount.currencyCode: 'DocumentCurrency'
      NonDeductibleInputTaxAmount,
      CostCtrActivityType,
      GrantID,
      BudgetPeriod,
      EarmarkedFundsDocument,
      FundsCenter,
      BusinessProcess,

      _PurchaseContract,
      _PurchaseContractItem,
      _CommitmentItemShortID
}
where
  _PurchaseContract.PurchasingDocumentCategory = 'K'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PURCHASECONTRACT",
"I_PURCHASECONTRACTITEM",
"I_PURGDOCACCOUNTASSIGNMENT"
],
"ASSOCIATED":
[
"I_COMMITMENTITEMSHORTID",
"I_PURCHASECONTRACT",
"I_PURCHASECONTRACTITEM"
],
"BASE":
[
"I_PURGDOCACCOUNTASSIGNMENT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More