I_CFINAAPURCHASINGVALIDITEM
CFinAA Purchasing Valid Item
I_CFINAAPURCHASINGVALIDITEM is a CDS View in S/4HANA. CFinAA Purchasing Valid Item. It contains 15 fields. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_CFinAAPurchasingMessage | view_entity | inner | TRANSACTIONAL | CFinAA Purchasing Message |
| R_CFinAAPurchasingValidItemTP | view_entity | from | TRANSACTIONAL | CFinAA Purchasing Valid Item -TP |
Fields (15)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | CFinRpldPurchasingDocument | CFinRpldPurchasingDocument | 2 |
| KEY | CFinRpldPurchasingDocumentItem | CFinRpldPurchasingDocumentItem | 2 |
| KEY | SenderLogicalSystem | SenderLogicalSystem | 2 |
| AccountAssignmentCategory | AccountAssignmentCategory | 1 | |
| CFinAAAssetCompanyCode | CFinAAAssetCompanyCode | 1 | |
| CFinAAHasAssetCreationMessage | CFinAAHasAssetCreationMessage | 1 | |
| CFinAAHasAssetPostingMessage | CFinAAHasAssetPostingMessage | 1 | |
| CFinAAHasPurgItemUpdateMessage | CFinAAHasPurgItemUpdateMessage | 1 | |
| CFinAAManagedAssetUUID | CFinAAManagedAssetUUID | 1 | |
| CFinAAPurchasingItemStatus | CFinAAPurchasingItemStatus | 1 | |
| CFinAAPurchasingValidItemUUID | CFinAAPurchasingValidItemUUID | 1 | |
| CFinAAPurgConfignIsConsistent | CFinAAPurgConfignIsConsistent | 1 | |
| FixedAsset | FixedAsset | 1 | |
| MasterFixedAsset | MasterFixedAsset | 1 | |
| MaterialGroup | MaterialGroup | 1 |
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'CFinAA Purchasing Valid Item'
@Metadata.ignorePropagatedAnnotations: true
@VDM.viewType: #TRANSACTIONAL
@ObjectModel.usageType:{
serviceQuality: #C,
sizeCategory: #L,
dataClass: #TRANSACTIONAL
}
define view entity I_CFinAAPurchasingValidItem
as select distinct from I_CFinAAPurchasingItem
association [0..1] to I_CFinAAPurchasingManagedAsset as _Asset on $projection.CFinAAManagedAssetUUID = _Asset.CFinAAManagedAssetUUID
and $projection.CFinAAPurchasingValidItemUUID = _Asset.CFinAAPurchasingValidItemUUID
association [0..1] to I_CFinAAPurchasingActivation as _PurchasingActivation on $projection.CompanyCode = _PurchasingActivation.CompanyCode
and $projection.MaterialGroup = _PurchasingActivation.MaterialGroup
and $projection.AccountAssignmentCategory = _PurchasingActivation.AccountAssignmentCategory
association [0..1] to I_CFinAAPurgItemUpdateMessage as _PurItemUpdateMessage on $projection.SenderLogicalSystem = _PurItemUpdateMessage.SenderLogicalSystem
and $projection.CFinRpldPurchasingDocument = _PurItemUpdateMessage.CFinRpldPurchasingDocument
and $projection.CFinRpldPurchasingDocumentItem = _PurItemUpdateMessage.CFinRpldPurchasingDocumentItem
and (
_PurItemUpdateMessage.CFinAIFMessageProcessingStatus = 'I'
or _PurItemUpdateMessage.CFinAIFMessageProcessingStatus = 'E'
or _PurItemUpdateMessage.CFinAIFMessageProcessingStatus = 'A'
)
association [0..1] to I_CFinAAPurgMngdAstCrtnMessage as _AssetCreationMessage on $projection.CFinAAPurchasingValidItemUUID = _AssetCreationMessage.CFinAIFMessageScenarioUUID
and (
_AssetCreationMessage.CFinAIFMessageProcessingStatus = 'I'
or _AssetCreationMessage.CFinAIFMessageProcessingStatus = 'E'
or _AssetCreationMessage.CFinAIFMessageProcessingStatus = 'A'
)
association [0..1] to I_CFinAAMngdAstPostingMessage as _AssetPostingMessage on $projection.SenderLogicalSystem = _AssetPostingMessage.SenderLogicalSystem
and $projection.CFinRpldPurchasingDocument = _AssetPostingMessage.CFinRpldPurchasingDocument
and $projection.CFinRpldPurchasingDocumentItem = _AssetPostingMessage.CFinRpldPurchasingDocumentItem
and (
_AssetPostingMessage.CFinAIFMessageProcessingStatus = 'I'
or _AssetPostingMessage.CFinAIFMessageProcessingStatus = 'E'
or _AssetPostingMessage.CFinAIFMessageProcessingStatus = 'A'
)
{
key CFinAAPurchasingValidItemUUID,
CFinAAManagedAssetUUID,
CFinAAPurchasingItemStatus,
SenderLogicalSystem,
CFinRpldPurchasingDocument,
CFinRpldPurchasingDocumentItem,
CompanyCode,
MaterialGroup,
AccountAssignmentCategory,
_Asset.CFinAAAssetCompanyCode,
_Asset.MasterFixedAsset,
_Asset.FixedAsset,
cast( _Asset._FixedAsset.FixedAssetExternalID as fins_cfin_caa_asset_ext_id preserving type ) as FixedAssetExternalID,
_Asset._FixedAsset.AssetClass,
_Asset._FixedAsset.FixedAssetDescription,
_PurchasingActivation.CFinAAManagedAssetCreationType,
case when _PurchasingActivation.CompanyCode is null
then ' '
else cast( 'X' as fins_cfin_caa_pur_itm_constcy preserving type )
end as CFinAAPurgConfignIsConsistent,
case when _PurItemUpdateMessage.CFinAIFMessageUUID is null
then ' '
else cast( 'X' as boolean preserving type )
end as CFinAAHasPurgItemUpdateMessage,
case when _AssetCreationMessage.CFinAIFMessageUUID is null
then ' '
else cast( 'X' as boolean preserving type )
end as CFinAAHasAssetCreationMessage,
case when _AssetPostingMessage.CFinAIFMessageUUID is null
then ' '
else cast( 'X' as boolean preserving type )
end as CFinAAHasAssetPostingMessage,
LastChangedByUser,
LastChangedAtDateTime,
LocalLastChangedAtDateTime,
_Asset,
_PurchasingActivation,
_PurItemUpdateMessage,
_AssetCreationMessage,
_AssetPostingMessage
}