I_PurReqnAcctAssgmt_Api01

DDL: I_PURREQNACCTASSGMT_API01 SQL: IPRACCASGMTAPI01 Type: view COMPOSITE

Account Assgmt in Purchase Requisition

I_PurReqnAcctAssgmt_Api01 is a Composite CDS View that provides data about "Account Assgmt in Purchase Requisition" in SAP S/4HANA. It reads from 1 data source (I_PurReqnAcctAssgmt) and exposes 57 fields with key fields PurchaseRequisition, PurchaseRequisitionItem, PurchaseReqnAcctAssgmtNumber. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_PurReqnAcctAssgmt I_PurReqnAcctAssgmt from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_PurchaseRequisition_Api01 _PurchaseRequisition_Api01 $projection.PurchaseRequisition = _PurchaseRequisition_Api01.PurchaseRequisition and $projection.PurchaseRequisitionItem = _PurchaseRequisition_Api01.PurchaseRequisitionItem

Annotations (13)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
AbapCatalog.sqlViewName IPRACCASGMTAPI01 view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Account Assgmt in Purchase Requisition view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
Metadata.ignorePropagatedAnnotations true view
VDM.lifecycle.status #DEPRECATED view
VDM.lifecycle.successor I_PurReqnAcctAssgmtAPI01 view

Fields (57)

KeyFieldSource TableSource FieldDescription
KEY PurchaseRequisition I_PurReqnAcctAssgmt PurchaseRequisition
KEY PurchaseRequisitionItem I_PurReqnAcctAssgmt PurchaseRequisitionItem
KEY PurchaseReqnAcctAssgmtNumber I_PurReqnAcctAssgmt PurchaseReqnAcctAssgmtNumber
CostCenter I_PurReqnAcctAssgmt CostCenter
MasterFixedAsset I_PurReqnAcctAssgmt MasterFixedAsset
ProjectNetwork I_PurReqnAcctAssgmt ProjectNetwork
Quantity I_PurReqnAcctAssgmt Quantity
BaseUnit _PurchaseRequisition_Api01 BaseUnit
MultipleAcctAssgmtDistrPercent I_PurReqnAcctAssgmt MultipleAcctAssgmtDistrPercent
PurReqnNetAmount I_PurReqnAcctAssgmt PurReqnNetAmount
PurReqnItemCurrency _PurchaseRequisition_Api01 PurReqnItemCurrency
IsDeleted I_PurReqnAcctAssgmt IsDeleted
CostElement I_PurReqnAcctAssgmt CostElement
GLAccount I_PurReqnAcctAssgmt GLAccount
BusinessArea I_PurReqnAcctAssgmt BusinessArea
SDDocument I_PurReqnAcctAssgmt SDDocument
SalesOrder I_PurReqnAcctAssgmt SalesOrder
SalesDocumentItem I_PurReqnAcctAssgmt SalesDocumentItem
SalesOrderItem I_PurReqnAcctAssgmt SalesOrderItem
ScheduleLine I_PurReqnAcctAssgmt ScheduleLine
SalesOrderScheduleLine I_PurReqnAcctAssgmt SalesOrderScheduleLine
FixedAsset I_PurReqnAcctAssgmt FixedAsset
ProcessOrder I_PurReqnAcctAssgmt ProcessOrder
OrderID I_PurReqnAcctAssgmt OrderID
UnloadingPointName I_PurReqnAcctAssgmt UnloadingPointName
ControllingArea I_PurReqnAcctAssgmt ControllingArea
CostObject I_PurReqnAcctAssgmt CostObject
ProfitabilitySegment
ProfitabilitySegment_2
ProfitCenter I_PurReqnAcctAssgmt ProfitCenter
WBSElementInternalID I_PurReqnAcctAssgmt WBSElementInternalID
ProjectNetworkInternalID I_PurReqnAcctAssgmt ProjectNetworkInternalID
CommitmentItem I_PurReqnAcctAssgmt CommitmentItem
FundsCenter I_PurReqnAcctAssgmt FundsCenter
Fund I_PurReqnAcctAssgmt Fund
FunctionalArea I_PurReqnAcctAssgmt FunctionalArea
CreationDate I_PurReqnAcctAssgmt CreationDate
GoodsRecipientName I_PurReqnAcctAssgmt GoodsRecipientName
RealEstateObject I_PurReqnAcctAssgmt RealEstateObject
NetworkActivityInternalID I_PurReqnAcctAssgmt NetworkActivityInternalID
PartnerAccountNumber I_PurReqnAcctAssgmt PartnerAccountNumber
JointVentureRecoveryCode I_PurReqnAcctAssgmt JointVentureRecoveryCode
SettlementReferenceDate I_PurReqnAcctAssgmt SettlementReferenceDate
OrderInternalID I_PurReqnAcctAssgmt OrderInternalID
OrderIntBillOfOperationsItem I_PurReqnAcctAssgmt OrderIntBillOfOperationsItem
EarmarkedFundsDocument I_PurReqnAcctAssgmt EarmarkedFundsDocument
CostCtrActivityType I_PurReqnAcctAssgmt CostCtrActivityType
BusinessProcess I_PurReqnAcctAssgmt BusinessProcess
GrantID I_PurReqnAcctAssgmt GrantID
ValidityDate I_PurReqnAcctAssgmt ValidityDate
ChartOfAccounts I_PurReqnAcctAssgmt ChartOfAccounts
WBSElement I_PurReqnAcctAssgmt WBSElement
PurchaseRequisitionType _PurchaseRequisition_Api01 PurchaseRequisitionType
Plant _PurchaseRequisition_Api01 Plant
PurchasingOrganization _PurchaseRequisition_Api01 PurchasingOrganization
PurchasingGroup _PurchaseRequisition_Api01 PurchasingGroup
_PurchaseRequisition_Api01 _PurchaseRequisition_Api01
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass:#TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory:#L //Inserted by VDM CDS Suite Plugin

@AbapCatalog.sqlViewName: 'IPRACCASGMTAPI01'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Account Assgmt in Purchase Requisition'
@VDM.viewType: #COMPOSITE
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
@Metadata.ignorePropagatedAnnotations: true
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: 'I_PurReqnAcctAssgmtAPI01'

define view I_PurReqnAcctAssgmt_Api01
  as select from I_PurReqnAcctAssgmt

  association [0..1] to I_PurchaseRequisition_Api01 as _PurchaseRequisition_Api01 on  $projection.PurchaseRequisition     = _PurchaseRequisition_Api01.PurchaseRequisition
                                                                                  and $projection.PurchaseRequisitionItem = _PurchaseRequisition_Api01.PurchaseRequisitionItem

{
  key I_PurReqnAcctAssgmt.PurchaseRequisition            as PurchaseRequisition,
  key I_PurReqnAcctAssgmt.PurchaseRequisitionItem        as PurchaseRequisitionItem,
  key I_PurReqnAcctAssgmt.PurchaseReqnAcctAssgmtNumber   as PurchaseReqnAcctAssgmtNumber,
      I_PurReqnAcctAssgmt.CostCenter,
      I_PurReqnAcctAssgmt.MasterFixedAsset,
      I_PurReqnAcctAssgmt.ProjectNetwork,
      @Semantics.quantity.unitOfMeasure: 'BaseUnit'
      I_PurReqnAcctAssgmt.Quantity,
      @Semantics.unitOfMeasure: true
      _PurchaseRequisition_Api01.BaseUnit,
      I_PurReqnAcctAssgmt.MultipleAcctAssgmtDistrPercent,
      @Semantics.amount.currencyCode: 'PurReqnItemCurrency'
      I_PurReqnAcctAssgmt.PurReqnNetAmount,
      @Semantics.currencyCode: true
      _PurchaseRequisition_Api01.PurReqnItemCurrency,
      I_PurReqnAcctAssgmt.IsDeleted,
      I_PurReqnAcctAssgmt.CostElement,
      I_PurReqnAcctAssgmt.GLAccount,
      I_PurReqnAcctAssgmt.BusinessArea,
      I_PurReqnAcctAssgmt.SDDocument,
      I_PurReqnAcctAssgmt.SalesOrder,
      I_PurReqnAcctAssgmt.SalesDocumentItem,
      I_PurReqnAcctAssgmt.SalesOrderItem,
      I_PurReqnAcctAssgmt.ScheduleLine,
      I_PurReqnAcctAssgmt.SalesOrderScheduleLine,
      I_PurReqnAcctAssgmt.FixedAsset,
      I_PurReqnAcctAssgmt.ProcessOrder,
      I_PurReqnAcctAssgmt.OrderID,
      I_PurReqnAcctAssgmt.UnloadingPointName,
      I_PurReqnAcctAssgmt.ControllingArea,
      I_PurReqnAcctAssgmt.CostObject,
      @API.element.releaseState: #DECOMMISSIONED
      @API.element.successor:'ProfitabilitySegment_2'
      cast(I_PurReqnAcctAssgmt.ProfitabilitySegment as rkeobjnr_numc ) as ProfitabilitySegment,
      cast(I_PurReqnAcctAssgmt.ProfitabilitySegment as rkeobjnr_char ) as ProfitabilitySegment_2,
      I_PurReqnAcctAssgmt.ProfitCenter,
      I_PurReqnAcctAssgmt.WBSElementInternalID,
      I_PurReqnAcctAssgmt.ProjectNetworkInternalID,
      I_PurReqnAcctAssgmt.CommitmentItem,
      I_PurReqnAcctAssgmt.FundsCenter,
      I_PurReqnAcctAssgmt.Fund,
      I_PurReqnAcctAssgmt.FunctionalArea,
      I_PurReqnAcctAssgmt.CreationDate,
      I_PurReqnAcctAssgmt.GoodsRecipientName,
      I_PurReqnAcctAssgmt.RealEstateObject,
      I_PurReqnAcctAssgmt.NetworkActivityInternalID,
      I_PurReqnAcctAssgmt.PartnerAccountNumber,
      I_PurReqnAcctAssgmt.JointVentureRecoveryCode,
      I_PurReqnAcctAssgmt.SettlementReferenceDate,
      I_PurReqnAcctAssgmt.OrderInternalID,
      I_PurReqnAcctAssgmt.OrderIntBillOfOperationsItem,
      I_PurReqnAcctAssgmt.EarmarkedFundsDocument,
      I_PurReqnAcctAssgmt.CostCtrActivityType,
      I_PurReqnAcctAssgmt.BusinessProcess,
      I_PurReqnAcctAssgmt.GrantID,
      I_PurReqnAcctAssgmt.ValidityDate,
      I_PurReqnAcctAssgmt.ChartOfAccounts,
      I_PurReqnAcctAssgmt.WBSElement,
      _PurchaseRequisition_Api01.PurchaseRequisitionType as PurchaseRequisitionType,
      _PurchaseRequisition_Api01.Plant                   as Plant,
      _PurchaseRequisition_Api01.PurchasingOrganization  as PurchasingOrganization,
      _PurchaseRequisition_Api01.PurchasingGroup         as PurchasingGroup,

      /*associations*/
      _PurchaseRequisition_Api01

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PURCHASEREQUISITION_API01",
"I_PURREQNACCTASSGMT"
],
"ASSOCIATED":
[
"I_PURCHASEREQUISITION_API01"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/