FAC_AUDIT_Z3_PURCHASEORDERITEM
Purchase Order Item
FAC_AUDIT_Z3_PURCHASEORDERITEM is a CDS View that provides data about "Purchase Order Item" in SAP S/4HANA. It reads from 2 data sources (I_LedgerCompanyCodeCrcyRoles, I_PurchaseOrderItem) and exposes 20 fields with key fields PurchaseOrder, PurchaseOrderItem. It has 2 associations to related views.
Data Sources (2)
| Source | Alias | Join Type |
|---|---|---|
| I_LedgerCompanyCodeCrcyRoles | I_LedgerCompanyCodeCrcyRoles | inner |
| I_PurchaseOrderItem | I_PurchaseOrderItem | from |
Parameters (4)
| Name | Type | Default |
|---|---|---|
| P_Ledger | fins_ledger | |
| P_FiscalYear | fins_gjahr | |
| P_FromFiscalPeriod | fins_fagl_fiscper_from | |
| P_ToFiscalPeriod | fins_fagl_fiscper_to |
Associations (2)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..1] | I_FiscalPeriodForVariant | _ToFiscalPeriodForVariant | _ToFiscalPeriodForVariant.FiscalYearVariant = $projection.FiscalYearVariant and _ToFiscalPeriodForVariant.FiscalYear = $parameters.P_FiscalYear and _ToFiscalPeriodForVariant.FiscalPeriod = $parameters.P_ToFiscalPeriod |
| [0..1] | I_FiscalPeriodForVariant | _FromFiscalPeriodForVariant | _FromFiscalPeriodForVariant.FiscalYearVariant = $projection.FiscalYearVariant and _FromFiscalPeriodForVariant.FiscalYear = $parameters.P_FiscalYear and _FromFiscalPeriodForVariant.FiscalPeriod = $parameters.P_FromFiscalPeriod |
Annotations (11)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | FAC_PURORDITEM | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AbapCatalog.preserveKey | true | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| EndUserText.label | Purchase Order Item | view | |
| ObjectModel.usageType.sizeCategory | #L | view | |
| ObjectModel.usageType.dataClass | #MASTER | view | |
| ObjectModel.usageType.serviceQuality | #C | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| AbapCatalog.buffering.status | #NOT_ALLOWED | view | |
| AccessControl.personalData.blocking | #BLOCKED_DATA_EXCLUDED | view |
Fields (20)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | PurchaseOrder | PurchaseOrder | ||
| KEY | PurchaseOrderItem | PurchaseOrderItem | ||
| SystemClient | System Client | |||
| CompanyCode | I_PurchaseOrderItem | CompanyCode | ||
| IncotermsClassification | IncotermsClassification | |||
| IncotermsTransferLocation | IncotermsTransferLocation | |||
| AccountAssignmentCategory | AccountAssignmentCategory | |||
| MaterialGroup | MaterialGroup | |||
| Material | Material | |||
| MaterialType | MaterialType | |||
| ValuationType | ValuationType | |||
| ValuationCategory | ValuationCategory | |||
| PurchaseOrderQuantityUnit | PurchaseOrderQuantityUnit | |||
| OrderQuantity | OrderQuantity | |||
| EffectiveAmount | EffectiveAmount | |||
| TaxCode | TaxCode | |||
| NonDeductibleInputTaxAmount | NonDeductibleInputTaxAmount | |||
| NetAmount | NetAmount | |||
| DocumentCurrency | DocumentCurrency | |||
| FiscalYearVariant | I_LedgerCompanyCodeCrcyRoles | FiscalYearVariant |
@AbapCatalog.sqlViewName: 'FAC_PURORDITEM'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Purchase Order Item'
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #C
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.buffering.status: #NOT_ALLOWED
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
define view FAC_AUDIT_Z3_PURCHASEORDERITEM
with parameters
P_Ledger : fins_ledger,
P_FiscalYear : fins_gjahr,
@EndUserText.label: 'From Fiscal Period'
P_FromFiscalPeriod : fins_fagl_fiscper_from,
@EndUserText.label: 'To Fiscal Period'
P_ToFiscalPeriod : fins_fagl_fiscper_to
as select from I_PurchaseOrderItem
inner join I_LedgerCompanyCodeCrcyRoles on I_PurchaseOrderItem.CompanyCode = I_LedgerCompanyCodeCrcyRoles.CompanyCode
and I_LedgerCompanyCodeCrcyRoles.Ledger = $parameters.P_Ledger
association [0..1] to I_FiscalPeriodForVariant as _ToFiscalPeriodForVariant on _ToFiscalPeriodForVariant.FiscalYearVariant = $projection.FiscalYearVariant
and _ToFiscalPeriodForVariant.FiscalYear = $parameters.P_FiscalYear
and _ToFiscalPeriodForVariant.FiscalPeriod = $parameters.P_ToFiscalPeriod
association [0..1] to I_FiscalPeriodForVariant as _FromFiscalPeriodForVariant on _FromFiscalPeriodForVariant.FiscalYearVariant = $projection.FiscalYearVariant
and _FromFiscalPeriodForVariant.FiscalYear = $parameters.P_FiscalYear
and _FromFiscalPeriodForVariant.FiscalPeriod = $parameters.P_FromFiscalPeriod
{
//@ObjectModel.foreignKey.association: '_PurchaseOrder'
key PurchaseOrder,
key PurchaseOrderItem,
@EndUserText.label: 'System Client'
$session.client as SystemClient,
//@ObjectModel.foreignKey.association: '_CompanyCode'
I_PurchaseOrderItem.CompanyCode,
//@ObjectModel.foreignKey.association: '_IncotermsClassification'
IncotermsClassification,
IncotermsTransferLocation,
AccountAssignmentCategory,
//@ObjectModel.foreignKey.association: '_MaterialGroup'
MaterialGroup,
//@ObjectModel.foreignKey.association: '_Material'
Material,
MaterialType,
ValuationType,
ValuationCategory,
PurchaseOrderQuantityUnit,
@Semantics.quantity.unitOfMeasure: 'PurchaseOrderQuantityUnit'
OrderQuantity,
@Semantics.amount.currencyCode: 'DocumentCurrency'
EffectiveAmount,
TaxCode,
@Semantics.amount.currencyCode: 'DocumentCurrency'
NonDeductibleInputTaxAmount,
@Semantics.amount.currencyCode: 'DocumentCurrency'
NetAmount,
@Semantics.currencyCode: true
DocumentCurrency,
//END OF FIELDS SHOWN IN REPORT
I_LedgerCompanyCodeCrcyRoles.FiscalYearVariant as FiscalYearVariant
//_PurchaseOrder.CreationDate
}
where
_PurchaseOrder.CreationDate <= _ToFiscalPeriodForVariant.FiscalPeriodEndDate
and _PurchaseOrder.CreationDate >= _FromFiscalPeriodForVariant.FiscalPeriodStartDate
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_FISCALPERIODFORVARIANT",
"I_LEDGERCOMPANYCODECRCYROLES",
"I_PURCHASEORDER",
"I_PURCHASEORDERITEM"
],
"ASSOCIATED":
[
"I_FISCALPERIODFORVARIANT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/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