P_ACDOCAMEXTRACT

DDL: P_ACDOCAMEXTRACT Type: view_entity BASIC Package: FINS_ML_VDM
27 Fields 1 Data Sources

Selection of ACDOCA_M_EXTRACT

P_ACDOCAMEXTRACT is a Basic CDS View that provides data about "Selection of ACDOCA_M_EXTRACT" in SAP S/4HANA. It reads from 1 data source (acdoca_m_extract) and exposes 27 fields with key fields AccountingDocument, GLAccountLineItem, FiscalYearPeriod, Ledger, CompanyCode. Part of development package FINS_ML_VDM.

Data Sources (1)

SourceAliasJoin Type
acdoca_m_extract acdoca_m_extract from

Annotations (3)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #BASIC view

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY AccountingDocument belnr SD Document
KEY GLAccountLineItem docln Matching Document Line Item
KEY FiscalYearPeriod Period/Year
KEY Ledger rldnr Ledger (Compat.)
KEY CompanyCode rbukrs Company Code
KEY CostEstimate kalnr ProdCostEst.No.
Material matnr Vehicle Model
InventoryValuationType bwtar Valuation Type
ValuationArea bwkey Valuation Area
InvtryValnSpecialStockType ml_sobkz Special Stock
SalesOrder ml_kdauf SD Doc of Inv.
SalesOrderItem ml_kdpos SD Item of Inv.
Supplier ml_lifnr Vendor of Inv.
WBSElementInternalID WBSElem of Inv.
UnitOfMeasure
ValuationQuantity Val. quantity
Currency
AmountInCompanyCodeCurrency Local Crcy Amt
AmountInGlobalCurrency GrpCurr
AmountInFreeDefinedCurrency1 Other Crcy Amnt
AmountInFreeDefinedCurrency2 Amount in Currency 2
AmountInFreeDefinedCurrency3 Exchange Key
AmountInFreeDefinedCurrency4 Amount in Currency 4
AmountInFreeDefinedCurrency5 Amount in Currency 5
AmountInFreeDefinedCurrency6 Amount in Currency 6
AmountInFreeDefinedCurrency7 Amount in Currency 7
AmountInFreeDefinedCurrency8 Amount in Currency 8

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 P_ACDOCAMEXTRACT.
-- 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.

CREATE VIEW P_ACDOCAMEXTRACT AS
SELECT
  belnr AS AccountingDocument,
  docln AS GLAccountLineItem,
  cast(fiscyearper as fis_jahrper_conv preserving type ) AS FiscalYearPeriod,
  rldnr AS Ledger,
  rbukrs AS CompanyCode,
  kalnr AS CostEstimate,
  matnr AS Material,
  bwtar AS InventoryValuationType,
  bwkey AS ValuationArea,
  ml_sobkz AS InvtryValnSpecialStockType,
  ml_kdauf AS SalesOrder,
  ml_kdpos AS SalesOrderItem,
  ml_lifnr AS Supplier,
  cast( ml_pspnr as fis_wbsint_no_conv preserving type ) AS WBSElementInternalID,
  cast( 'KG' as meins ) AS UnitOfMeasure,
  cast( vmsl as fis_vquan1_12 preserving type ) AS ValuationQuantity,
  cast( 'EUR' as waers ) AS Currency,
  cast( hsl as fis_hsl preserving type ) AS AmountInCompanyCodeCurrency,
  cast( ksl as fis_ksl preserving type ) AS AmountInGlobalCurrency,
  cast( osl as fis_osl preserving type ) AS AmountInFreeDefinedCurrency1,
  cast( vsl as fis_vsl preserving type ) AS AmountInFreeDefinedCurrency2,
  cast( bsl as fis_bsl preserving type ) AS AmountInFreeDefinedCurrency3,
  cast( csl as fis_csl preserving type ) AS AmountInFreeDefinedCurrency4,
  cast( dsl as fis_dsl preserving type ) AS AmountInFreeDefinedCurrency5,
  cast( esl as fis_esl preserving type ) AS AmountInFreeDefinedCurrency6,
  cast( fsl as fis_fsl preserving type ) AS AmountInFreeDefinedCurrency7,
  cast( gsl as fis_gsl preserving type ) AS AmountInFreeDefinedCurrency8
FROM acdoca_m_extract
;

Learn More