I_PurReqnAcctAssgmtAPI01

DDL: I_PURREQNACCTASSGMTAPI01 SQL: IPRACCASMTAPI01 Type: view COMPOSITE

Account Assgmt in Purchase Requisition

I_PurReqnAcctAssgmtAPI01 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 68 fields with key fields PurchaseRequisition, PurchaseRequisitionItem, PurchaseReqnAcctAssgmtNumber. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_PurReqnAcctAssgmt I_PurReqnAcctAssgmt from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_PurchaseRequisitionItemAPI01 _PurchaseRequisition_Api01 $projection.PurchaseRequisition = _PurchaseRequisition_Api01.PurchaseRequisition and $projection.PurchaseRequisitionItem = _PurchaseRequisition_Api01.PurchaseRequisitionItem
[0..1] I_CommitmentItemShortID _CommitmentItemShortID $projection.CommitmentItemShortID = _CommitmentItemShortID.CommitmentItemShortID

Annotations (12)

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

Fields (68)

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
WBSElementInternalID_2 I_PurReqnAcctAssgmt WBSElementInternalID_2
ProjectNetworkInternalID I_PurReqnAcctAssgmt ProjectNetworkInternalID
CommitmentItem
CommitmentItemShortID I_PurReqnAcctAssgmt CommitmentItemShortID
FundsCenter I_PurReqnAcctAssgmt FundsCenter
Fund I_PurReqnAcctAssgmt Fund
FunctionalArea I_PurReqnAcctAssgmt FunctionalArea
CreationDate I_PurReqnAcctAssgmt CreationDate
GoodsRecipientName I_PurReqnAcctAssgmt GoodsRecipientName
RealEstateObject RealEstateObject
REInternalFinNumber REInternalFinNumber
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
ServiceDocID I_PurReqnAcctAssgmt ServiceDocID
ServiceDocItemID I_PurReqnAcctAssgmt ServiceDocItemID
ServiceDocumentType I_PurReqnAcctAssgmt ServiceDocumentType
CostCtrActivityType I_PurReqnAcctAssgmt CostCtrActivityType
BusinessProcess I_PurReqnAcctAssgmt BusinessProcess
GrantID I_PurReqnAcctAssgmt GrantID
ValidityDate I_PurReqnAcctAssgmt ValidityDate
ChartOfAccounts I_PurReqnAcctAssgmt ChartOfAccounts
WBSElement I_PurReqnAcctAssgmt WBSElement
WBSElementExternalID_2 I_PurReqnAcctAssgmt WBSElementExternalID_2
ProcmtHubWBSElementExternalID I_PurReqnAcctAssgmt ProcmtHubWBSElementExternalID
PurchaseRequisitionType _PurchaseRequisition_Api01 PurchaseRequisitionType
Plant _PurchaseRequisition_Api01 Plant
PurchasingOrganization _PurchaseRequisition_Api01 PurchasingOrganization
PurchasingGroup _PurchaseRequisition_Api01 PurchasingGroup
_REObjectByIntFinNumber _REObjectByIntFinNumber
_PurchaseRequisitionItem _PurchaseRequisition_Api01
_PurchaseRequisition_Api01 _PurchaseRequisition_Api01
_CommitmentItemShortID _CommitmentItemShortID
@AbapCatalog.sqlViewName: 'IPRACCASMTAPI01'
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass:#TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory:#L //Inserted by VDM CDS Suite Plugin

//@ObjectModel.representativeKey: 'PurchaseReqnAcctAssgmtNumber'

@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #COMPOSITE
@ObjectModel.supportedCapabilities: [#SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET]
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
@Metadata.ignorePropagatedAnnotations: true
@AbapCatalog.preserveKey: true
@EndUserText.label: 'Account Assgmt in Purchase Requisition'

define view I_PurReqnAcctAssgmtAPI01
  as select from I_PurReqnAcctAssgmt

  /* association [0..1] to I_PurchaseRequisitionItemAPI01 as _PurchaseRequisitionItem on  $projection.PurchaseRequisition     = _PurchaseRequisitionItem.PurchaseRequisition
                                                                                    and $projection.PurchaseRequisitionItem = _PurchaseRequisitionItem.PurchaseRequisitionItem*/
  association [0..1] to I_PurchaseRequisitionItemAPI01 as _PurchaseRequisition_Api01 on  $projection.PurchaseRequisition     = _PurchaseRequisition_Api01.PurchaseRequisition
                                                                                     and $projection.PurchaseRequisitionItem = _PurchaseRequisition_Api01.PurchaseRequisitionItem
  association [0..1] to I_CommitmentItemShortID        as _CommitmentItemShortID     on  $projection.CommitmentItemShortID   = _CommitmentItemShortID.CommitmentItemShortID
                                                                                     

{
  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,
      
      @API.element.releaseState:#DEPRECATED
      @API.element.successor:'WBSElementInternalID_2'
      cast( I_PurReqnAcctAssgmt.WBSElementInternalID_2 as ps_psp_pnr ) as WBSElementInternalID,
      I_PurReqnAcctAssgmt.WBSElementInternalID_2,
      
      I_PurReqnAcctAssgmt.ProjectNetworkInternalID,

      @API.element.releaseState:#DEPRECATED
      @API.element.successor:'CommitmentItemShortID'
      cast(I_PurReqnAcctAssgmt.CommitmentItemShortID as fipos)                                 as CommitmentItem,
      I_PurReqnAcctAssgmt.CommitmentItemShortID,
      I_PurReqnAcctAssgmt.FundsCenter,
      I_PurReqnAcctAssgmt.Fund,
      I_PurReqnAcctAssgmt.FunctionalArea,
      I_PurReqnAcctAssgmt.CreationDate,
      I_PurReqnAcctAssgmt.GoodsRecipientName,
      
      @API.element.releaseState:#DEPRECATED
      @API.element.successor:'REInternalFinNumber'
      RealEstateObject,
      
      REInternalFinNumber,
      
      I_PurReqnAcctAssgmt.NetworkActivityInternalID,
      I_PurReqnAcctAssgmt.PartnerAccountNumber,
      I_PurReqnAcctAssgmt.JointVentureRecoveryCode,
      I_PurReqnAcctAssgmt.SettlementReferenceDate,
      I_PurReqnAcctAssgmt.OrderInternalID,
      I_PurReqnAcctAssgmt.OrderIntBillOfOperationsItem,
      I_PurReqnAcctAssgmt.EarmarkedFundsDocument,
      
      I_PurReqnAcctAssgmt.ServiceDocID,
      I_PurReqnAcctAssgmt.ServiceDocItemID,
      I_PurReqnAcctAssgmt.ServiceDocumentType,
      
      I_PurReqnAcctAssgmt.CostCtrActivityType,
      I_PurReqnAcctAssgmt.BusinessProcess,
      I_PurReqnAcctAssgmt.GrantID,
      I_PurReqnAcctAssgmt.ValidityDate,
      I_PurReqnAcctAssgmt.ChartOfAccounts,
      
      @API.element.releaseState:#DEPRECATED
      @API.element.successor:'WBSElementExternalID_2'
      I_PurReqnAcctAssgmt.WBSElement,
      I_PurReqnAcctAssgmt.WBSElementExternalID_2,
      
      I_PurReqnAcctAssgmt.ProcmtHubWBSElementExternalID,
      _PurchaseRequisition_Api01.PurchaseRequisitionType as PurchaseRequisitionType,
      _PurchaseRequisition_Api01.Plant                   as Plant,
      _PurchaseRequisition_Api01.PurchasingOrganization  as PurchasingOrganization,
      _PurchaseRequisition_Api01.PurchasingGroup         as PurchasingGroup,

      /*associations*/
      _REObjectByIntFinNumber,
      @API.element.releaseState:#DEPRECATED
      @API.element.successor:'_PurchaseRequisition_Api01'
     _PurchaseRequisition_Api01 as _PurchaseRequisitionItem,
     _PurchaseRequisition_Api01,
     _CommitmentItemShortID
     

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