R_PurOrdAccountAssignmentTP

DDL: R_PURORDACCOUNTASSIGNMENTTP Type: view_entity TRANSACTIONAL Package: RAP_MM_PUR_PO

Purchase Order Accnt Assignment TP view

R_PurOrdAccountAssignmentTP is a Transactional CDS View that provides data about "Purchase Order Accnt Assignment TP view" in SAP S/4HANA. It reads from 1 data source (I_PurOrdAccountAssignment) and exposes 91 fields with key fields PurchaseOrder, PurchaseOrderItem, AccountAssignmentNumber. It has 1 association to related views. Part of development package RAP_MM_PUR_PO.

Data Sources (1)

SourceAliasJoin Type
I_PurOrdAccountAssignment I_PurOrdAccountAssignment from

Associations (1)

CardinalityTargetAliasCondition
[1..1] R_PurchaseOrderTP _PurchaseOrder $projection.PurchaseOrder = _PurchaseOrder.PurchaseOrder

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label Purchase Order Accnt Assignment TP view view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
Metadata.ignorePropagatedAnnotations true view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view

Fields (91)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder PurchaseOrder
KEY PurchaseOrderItem PurchaseOrderItem
KEY AccountAssignmentNumber AccountAssignmentNumber
PurchasingDocument PurchasingDocument
PurchasingDocumentItem PurchasingDocumentItem
CostCenter CostCenter
MasterFixedAsset MasterFixedAsset
ProjectNetwork ProjectNetwork
NetworkActivity
OrderQuantityUnit OrderQuantityUnit
Quantity Quantity
MultipleAcctAssgmtDistrPercent MultipleAcctAssgmtDistrPercent
DocumentCurrency DocumentCurrency
PurgDocNetAmount PurgDocNetAmount
IsDeleted IsDeleted
GLAccount GLAccount
BusinessArea BusinessArea
SalesOrder SalesOrder
SalesOrderItem SalesOrderItem
SalesOrderScheduleLine SalesOrderScheduleLine
FixedAsset FixedAsset
OrderID OrderID
UnloadingPointName UnloadingPointName
ControllingArea ControllingArea
CostObject CostObject
ProfitabilitySegment ProfitabilitySegment_2
ProfitCenter ProfitCenter
WBSElementInternalID
WBSElementExternalID WBSElementExternalID
ProjectNetworkInternalID ProjectNetworkInternalID
CommitmentItemShortID CommitmentItemShortID
FundsCenter FundsCenter
Fund Fund
FunctionalArea FunctionalArea
LastChangedDate LastChangedDate
GoodsRecipientName GoodsRecipientName
IsFinallyInvoiced IsFinallyInvoiced
NetworkActivityInternalID NetworkActivityInternalID
PartnerAccountNumber PartnerAccountNumber
JointVentureRecoveryCode JointVentureRecoveryCode
SettlementReferenceDate SettlementReferenceDate
OrderInternalID OrderInternalID
OrderIntBillOfOperationsItem OrderIntBillOfOperationsItem
TaxCode TaxCode
TaxJurisdiction TaxJurisdiction
NonDeductibleInputTaxAmount NonDeductibleInputTaxAmount
CostCtrActivityType CostCtrActivityType
BusinessProcess BusinessProcess
GrantID GrantID
BudgetPeriod BudgetPeriod
EarmarkedFundsDocument EarmarkedFundsDocument
EarmarkedFundsDocumentItem EarmarkedFundsDocumentItem
ValidityDate ValidityDate
ChartOfAccounts ChartOfAccounts
ServiceDocumentType ServiceDocumentType
ServiceDocument ServiceDocument
ServiceDocumentItem ServiceDocumentItem
CreationDate CreationDate
IsAcctLineFinal IsAcctLineFinal
AcctLineFinalReason AcctLineFinalReason
CompanyCode CompanyCode
_BusinessArea _BusinessArea
_BusinessAreaText _BusinessAreaText
_BusinessProcess _BusinessProcess
_BusinessProcessText _BusinessProcessText
_CommitmentItemShortID _CommitmentItemShortID
_ControllingArea _ControllingArea
_CostCenter _CostCenter
_CostCenterActivityType _CostCenterActivityType
_CostCenterActivityTypeText _CostCenterActivityTypeText
_CostCenterText _CostCenterText
_FixedAssetWorklist _FixedAssetWorklist
_FunctionalArea _FunctionalArea
_FunctionalAreaText _FunctionalAreaText
_GLAccount _GLAccount
_GLAccountText _GLAccountText
_ProfitCenter _ProfitCenter
_ProfitCenterText _ProfitCenterText
_PurchaseOrder _PurchaseOrder
_PurchaseOrderItem _PurchaseOrderItem
_SalesDocumentScheduleLine _SalesDocumentScheduleLine
_SalesOrder _SalesOrder
_SalesOrderItem _SalesOrderItem
_TaxCode _TaxCode
_TaxCodeText _TaxCodeText
_TaxJurisdiction _TaxJurisdiction
_TaxJurisdictionText _TaxJurisdictionText
_WBSElement _WBSElement
_WBSElementByInternalKey _WBSElementByInternalKey
_PurchaseOrderQuantityUnitText _PurchaseOrderQuantityUnitText
_DocumentCurrencyText _DocumentCurrencyText
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@EndUserText.label: 'Purchase Order Accnt Assignment TP view'
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #L, dataClass: #MASTER}
@Metadata.ignorePropagatedAnnotations: true
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@VDM.viewType: #TRANSACTIONAL

define view entity R_PurOrdAccountAssignmentTP
  as select from I_PurOrdAccountAssignment

  association [1..1] to R_PurchaseOrderTP            as _PurchaseOrder     on  $projection.PurchaseOrder = _PurchaseOrder.PurchaseOrder

  association        to parent R_PurchaseOrderItemTP as _PurchaseOrderItem on  $projection.PurchaseOrder     = _PurchaseOrderItem.PurchaseOrder
                                                                           and $projection.PurchaseOrderItem = _PurchaseOrderItem.PurchaseOrderItem
{
      // Keys

  key PurchaseOrder,
  key PurchaseOrderItem,
  key AccountAssignmentNumber,

      // Purchasing Document fields

      @Consumption.hidden: true
      PurchasingDocument,
      @Consumption.hidden: true
      PurchasingDocumentItem,

      CostCenter,
      MasterFixedAsset,
      ProjectNetwork,

      cast( NetworkActivity as ps_s4_vornr preserving type )       as NetworkActivity,

      @Consumption.hidden: true
      OrderQuantityUnit,

      @Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
      Quantity,
      MultipleAcctAssgmtDistrPercent,
      @Consumption.hidden: true
      DocumentCurrency,

      @Semantics.amount.currencyCode: 'DocumentCurrency'
      PurgDocNetAmount,
      IsDeleted,
      GLAccount,

      BusinessArea,
      SalesOrder,
      SalesOrderItem,
      SalesOrderScheduleLine,
      FixedAsset,
      OrderID,
      // cast( OrderOperation as vornr_auf preserving type ) as OrderOperation ,

      UnloadingPointName,
      ControllingArea,
      CostObject,
      ProfitabilitySegment_2                                       as ProfitabilitySegment,
      ProfitCenter,
      cast(  WBSElementInternalID as ps_s4_pspnr preserving type ) as WBSElementInternalID,
      WBSElementExternalID,
      ProjectNetworkInternalID,
      CommitmentItemShortID,
      FundsCenter,
      Fund,

      FunctionalArea,
      @Consumption.hidden: true
      LastChangedDate,
      GoodsRecipientName,
      IsFinallyInvoiced,
      //  cast( RealEstateObject as farp_imkey preserving type ) as RealEstateObject,

      NetworkActivityInternalID,
      PartnerAccountNumber,
      JointVentureRecoveryCode,
      SettlementReferenceDate,
      OrderInternalID,
      OrderIntBillOfOperationsItem,
      TaxCode,
      TaxJurisdiction,

      @Semantics.amount.currencyCode: 'DocumentCurrency'
      NonDeductibleInputTaxAmount,

      CostCtrActivityType,
      BusinessProcess,
      GrantID,

      BudgetPeriod,
      EarmarkedFundsDocument,
      // EarmarkedFundsItem,

      EarmarkedFundsDocumentItem,
      @Consumption.hidden: true
      ValidityDate,
      @Consumption.hidden: true
      ChartOfAccounts,

      //      @Consumption.valueHelp: '_AcctgServiceDocumentTypeVH'

      ServiceDocumentType,

      //      @Consumption.valueHelp: '_AcctgServiceDocumentVH'

      ServiceDocument,

      //      @Consumption.valueHelp: '_AcctgServiceDocumentItemVH'

      ServiceDocumentItem,

      CreationDate,
      IsAcctLineFinal,
      AcctLineFinalReason,
      @Consumption.hidden: true
      CompanyCode,

      /* Associations */
      //      _AcctgServiceDocumentItemVH,

      //      _AcctgServiceDocumentTypeVH,

      //      _AcctgServiceDocumentVH,

      _BusinessArea,
      _BusinessAreaText,
      _BusinessProcess,
      _BusinessProcessText,
      _CommitmentItemShortID,
      _ControllingArea,
      _CostCenter,
      _CostCenterActivityType,
      _CostCenterActivityTypeText,
      _CostCenterText,
      _FixedAssetWorklist,
      _FunctionalArea,
      _FunctionalAreaText,
      _GLAccount,
      _GLAccountText,
      _ProfitCenter,
      _ProfitCenterText,
      _PurchaseOrder,
      _PurchaseOrderItem,
      _SalesDocumentScheduleLine,
      _SalesOrder,
      _SalesOrderItem,
      _TaxCode,
      _TaxCodeText,
      _TaxJurisdiction,
      _TaxJurisdictionText,
      _WBSElement,
      _WBSElementByInternalKey,
      
      // Text associations for CustomUI

      _PurchaseOrderQuantityUnitText,
      _DocumentCurrencyText

}
where
  _PurchaseOrderItem.PurchasingDocumentDeletionCode = ''