C_StRpFxdAstAcquisitionFormQry

DDL: C_STRPFXDASTACQUISITIONFORMQRY SQL: CSRFAACQFORMQ Type: view CONSUMPTION Package: GLO_FIN_IS_AA_GEN
40 Fields 1 Data Sources

Fixed Asset Acquisition Form - Query

C_StRpFxdAstAcquisitionFormQry is a Consumption CDS View that provides data about "Fixed Asset Acquisition Form - Query" in SAP S/4HANA. It reads from 1 data source (C_StRpFxdAssetAcquisitionFormC) and exposes 40 fields. Part of development package GLO_FIN_IS_AA_GEN.

Data Sources (1)

SourceAliasJoin Type
C_StRpFxdAssetAcquisitionFormC C_StRpFxdAssetAcquisitionFormC from

Parameters (7)

NameTypeDefault
P_FromPostingDate fis_budat_from
P_ToPostingDate fis_budat_to
P_FiscalYear fis_gjahr
P_ToFiscalPeriod fis_period_to
P_AssetAccountingKeyFigureSet faa_key_figure_set
P_DateFieldPrintedOnForm fiaagen_frm_date_fld_prntd
P_NationalClsfctnSourceField fiaagen_natl_clfn_srce_fld

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CSRFAACQFORMQ view
VDM.viewType #CONSUMPTION view
Analytics.query true view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Fixed Asset Acquisition Form - Query view

Fields (40)

KeyFieldSource TableSource FieldDescription
nameI_AssetKeyFigureSet
MasterFixedAssetDescription _MasterFixedAsset MasterFixedAssetDescription
FixedAsset FixedAsset Sub-number
FixedAssetDescription FixedAssetDescription Description
Ledger Ledger Ledger
FixedAssetFormNumber FixedAssetFormNumber
PostingDate PostingDate Posting Date for GR
FormPrintDate FormPrintDate
AccountingDocument AccountingDocument Journal Entry
StatryRptRunID StatryRptRunID Report Run ID
AcquisitionValueAmtInCCCrcy AcquisitionValueAmtInCCCrcy
AssetClass AssetClass Asset Class
AssetClassDescription AssetClassDescription
Inventory Inventory Ci Inventory
DocumentDate DocumentDate Journal Entry Date
AssetValueDate AssetValueDate Reference date
AssetCapitalizationDate AssetCapitalizationDate Asset Capitalization
AssetAdditionalDescription AssetAdditionalDescription
NationalClassification NationalClassification
NationalClassificationDesc NationalClassificationDesc
AssetSerialNumber AssetSerialNumber
PersonnelNumber PersonnelNumber Personnel No.
DepreciationKey DepreciationKey
DepreciationKeyName
PlannedUsefulLifeInYears PlannedUsefulLifeInYears Planned Use Life Yr.
PlannedUsefulLifeInPeriods PlannedUsefulLifeInPeriods
Supplier Supplier Supplier
SupplierName _Supplier BPSupplierName Supplier Name
CompanyCodeCurrency CompanyCodeCurrency Local Currency
AssetPlant AssetPlant
AssetLocation AssetLocation Location
AssetCostCenter AssetCostCenter
AssetCostCenterName
DocumentReferenceID DocumentReferenceID Reference
CompanyCode CompanyCode Receiver Company Code
CompanyCodeName CompanyCodeName Company Name
AssetDepreciationArea AssetDepreciationArea Deprec. Area
StatryRptgEntity StatryRptgEntity Reporting Entity
StatryRptCategory StatryRptCategory Report ID
AccountingDocumentType AccountingDocumentType Journal Entry Type

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_StRpFxdAstAcquisitionFormQry.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: CSRFAACQFORMQ
-- Parameters: P_FromPostingDate : fis_budat_from, P_ToPostingDate : fis_budat_to, P_FiscalYear : fis_gjahr, P_ToFiscalPeriod : fis_period_to, P_AssetAccountingKeyFigureSet : faa_key_figure_set, P_DateFieldPrintedOnForm : fiaagen_frm_date_fld_prntd, P_NationalClsfctnSourceField : fiaagen_natl_clfn_srce_fld

CREATE VIEW C_StRpFxdAstAcquisitionFormQry AS
SELECT
  entity.name: 'I_AssetKeyFigureSet' AS nameI_AssetKeyFigureSet,
  _MasterFixedAsset.MasterFixedAssetDescription AS MasterFixedAssetDescription,
  FixedAsset,
  FixedAssetDescription,
  Ledger,
  FixedAssetFormNumber,
  PostingDate,
  FormPrintDate,
  AccountingDocument,
  StatryRptRunID,
  AcquisitionValueAmtInCCCrcy,
  AssetClass,
  AssetClassDescription,
  Inventory,
  DocumentDate,
  AssetValueDate,
  AssetCapitalizationDate,
  AssetAdditionalDescription,
  NationalClassification,
  NationalClassificationDesc,
  AssetSerialNumber,
  PersonnelNumber,
  DepreciationKey,
  _DepreciationKey._Text[1:Language = $session.system_language].DepreciationKeyName AS DepreciationKeyName,
  PlannedUsefulLifeInYears,
  PlannedUsefulLifeInPeriods,
  Supplier,
  _Supplier.BPSupplierName AS SupplierName,
  CompanyCodeCurrency,
  AssetPlant,
  AssetLocation,
  AssetCostCenter,
  _AssetCostCenter[1:ValidityStartDate <= :P_ToPostingDate and ValidityEndDate >= :P_ToPostingDate]._Text[1: Language = $session.system_language].CostCenterName AS AssetCostCenterName,
  DocumentReferenceID,
  CompanyCode,
  CompanyCodeName,
  AssetDepreciationArea,
  StatryRptgEntity,
  StatryRptCategory,
  AccountingDocumentType
FROM C_StRpFxdAssetAcquisitionFormC
;

Learn More