R_PurOrdAccountAssignmentTP
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 89 fields with key fields PurchaseOrder, PurchaseOrderItem, AccountAssignmentNumber. It has 1 association to related views.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_PurOrdAccountAssignment | I_PurOrdAccountAssignment | from |
Associations (1)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [1..1] | R_PurchaseOrderTP | _PurchaseOrder | $projection.PurchaseOrder = _PurchaseOrder.PurchaseOrder |
Annotations (8)
| Name | Value | Level | Field |
|---|---|---|---|
| AccessControl.authorizationCheck | #CHECK | 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 (89)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| 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 |
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #CHECK
@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
}
where
_PurchaseOrderItem.PurchasingDocumentDeletionCode = ''
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA