How many fields does I_RO_SAFTStkMovementHeader have?

I_RO_SAFTStkMovementHeader has 9 fields. Key fields: AccountingDocument, CompanyCode, FiscalYear.

I_RO_SAFTStkMovementHeader

Q: Which tables does I_RO_SAFTStkMovementHeader use?

I_RO_SAFTStkMovementHeader reads from 3 data source(s): I_AccountingDocument, I_RO_SAFTStockHeaderLine, I_RO_SAFTStockMovementLine.

DDL: I_RO_SAFTSTKMOVEMENTHEADER SQL: IROSAFTSTKHDR Type: view COMPOSITE

Romania SAFT Stock Movement Header

I_RO_SAFTStkMovementHeader is a Composite CDS View (Dimension) that provides data about "Romania SAFT Stock Movement Header" in SAP S/4HANA. It reads from 3 data sources (I_AccountingDocument, I_RO_SAFTStockHeaderLine, I_RO_SAFTStockMovementLine) and exposes 9 fields with key fields AccountingDocument, CompanyCode, FiscalYear. It has 1 association to related views.

Data Sources (3)

Source	Alias	Join Type
I_AccountingDocument	_AccountingDocument	from
I_RO_SAFTStockHeaderLine	I_RO_SAFTStockHeaderLine	inner
I_RO_SAFTStockMovementLine	I_RO_SAFTStockMovementLine	inner

Parameters (2)

Name	Type	Default
P_Ledger	fagl_rldnr
P_AlternativeGLAccountIsUsed	boolean

Associations (1)

Cardinality	Target	Alias	Condition
[0..1]	I_AccountingDocumentTypeText	_AccountingDocumentText	`_AccountingDocumentText.AccountingDocumentType = _AccountingDocument.AccountingDocumentType and _AccountingDocumentText.Language = $session.system_language`

Annotations (12)

Name	Value	Level
AbapCatalog.sqlViewName	IROSAFTSTKHDR	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#MANDATORY	view
VDM.viewType	#COMPOSITE	view
ObjectModel.usageType.sizeCategory	#XXL	view
ObjectModel.usageType.dataClass	#MIXED	view
ObjectModel.usageType.serviceQuality	#D	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
Analytics.dataCategory	#DIMENSION	view
Analytics.internalName	#LOCAL	view
Metadata.allowExtensions	true	view
EndUserText.label	Romania SAFT Stock Movement Header	view

Fields (9)

Key	Field	Source Table	Source Field
KEY	AccountingDocument	I_AccountingDocument	AccountingDocument
KEY	CompanyCode	I_AccountingDocument	CompanyCode
KEY	FiscalYear	I_AccountingDocument	FiscalYear
	AccountingDocCreatedByUser	I_AccountingDocument	AccountingDocCreatedByUser
	RO_SAFTMovementType	_StockMovementHdr	RO_SAFTMovementType
	PostingDate	I_AccountingDocument	PostingDate
	DocumentDate	I_AccountingDocument	DocumentDate
	TaxReportingDate	I_AccountingDocument	TaxReportingDate
	AccountingDocumentCategory	I_AccountingDocument	AccountingDocumentCategory

@AbapCatalog.sqlViewName: 'IROSAFTSTKHDR'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #MANDATORY
@VDM.viewType: #COMPOSITE
@ObjectModel: {
                usageType: { sizeCategory: #XXL,
                             dataClass:  #MIXED,
                             serviceQuality: #D } }
@ClientHandling.algorithm: #SESSION_VARIABLE
@Analytics.dataCategory:#DIMENSION
@Analytics.internalName:#LOCAL
@Metadata.allowExtensions:true
@EndUserText.label: 'Romania SAFT Stock Movement Header'
define view I_RO_SAFTStkMovementHeader
  with parameters P_Ledger          : fagl_rldnr,
                  P_AlternativeGLAccountIsUsed : boolean
  as select from I_AccountingDocument as _AccountingDocument
  inner join I_RO_SAFTStockHeaderLine( P_Ledger : $parameters.P_Ledger ) 
                                as  _FirstLine
                                on  _AccountingDocument.AccountingDocument = _FirstLine.AccountingDocument
                                and _AccountingDocument.CompanyCode = _FirstLine.CompanyCode
                                and _AccountingDocument.FiscalYear = _FirstLine.FiscalYear
  inner join I_RO_SAFTStockMovementLine ( P_Ledger : $parameters.P_Ledger, 
                                    P_AlternativeGLAccountIsUsed : $parameters.P_AlternativeGLAccountIsUsed )
                                as  _StockMovementHdr   
                                on  _FirstLine.AccountingDocument = _StockMovementHdr.AccountingDocument
                                and _FirstLine.CompanyCode = _StockMovementHdr.CompanyCode
                                and _FirstLine.FiscalYear = _StockMovementHdr.FiscalYear
                                and _FirstLine.LedgerGLLineItem = _StockMovementHdr.LedgerGLLineItem
  association [0..1] to I_AccountingDocumentTypeText
                                     as  _AccountingDocumentText
                                     on  _AccountingDocumentText.AccountingDocumentType = _AccountingDocument.AccountingDocumentType
                                     and _AccountingDocumentText.Language = $session.system_language
{
  key _AccountingDocument.AccountingDocument,
  key _AccountingDocument.CompanyCode,
  key _AccountingDocument.FiscalYear,
      _AccountingDocument.AccountingDocCreatedByUser,
      _StockMovementHdr.RO_SAFTMovementType, 
      _AccountingDocument.PostingDate,
      _AccountingDocument.DocumentDate,
      _AccountingDocument.TaxReportingDate,
      _AccountingDocument.AccountingDocumentCategory,
      case
        when _AccountingDocumentText.AccountingDocumentTypeName <> ''
          then _AccountingDocumentText.AccountingDocumentTypeName
        else _AccountingDocument.AccountingDocumentHeaderText
      end as AccountingDocumentTypeName 
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ACCOUNTINGDOCUMENT",
"I_ACCOUNTINGDOCUMENTTYPETEXT",
"I_RO_SAFTSTOCKHEADERLINE",
"I_RO_SAFTSTOCKMOVEMENTLINE"
],
"ASSOCIATED":
[
"I_ACCOUNTINGDOCUMENTTYPETEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Depth:

I_RO_SAFTStkMovementHeader view