C_RO_SAFTStockMovementLine

DDL: C_RO_SAFTSTOCKMOVEMENTLINE SQL: CROSAFTSTKMVTITM Type: view CONSUMPTION

RO SAFT Stock Movement Line

C_RO_SAFTStockMovementLine is a Consumption CDS View that provides data about "RO SAFT Stock Movement Line" in SAP S/4HANA. It reads from 1 data source (I_RO_SAFTStockMovementLine) and exposes 19 fields with key fields AccountingDocument, CompanyCode, FiscalYear, LedgerGLLineItem, MaterialDocumentLine. It has 1 association to related views.

1 data source(s) 19 fields

Data Sources (1)

SourceAliasJoin Type
I_RO_SAFTStockMovementLine I_RO_SAFTStockMovementLine from

Parameters (2)

NameTypeDefault
P_Ledger fagl_rldnr
P_AlternativeGLAccountIsUsed boolean

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_RO_SAFTAccountMapping _Accmap _Accmap.ChartOfAccounts = _StockMovementLine.ChartOfAccounts and _Accmap.GLAccount = _StockMovementLine.TargetGLAccount

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CROSAFTSTKMVTITM view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.personalData.blocking #NOT_REQUIRED view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label RO SAFT Stock Movement Line view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY AccountingDocument _StockMovementLine AccountingDocument
KEY CompanyCode _StockMovementLine CompanyCode
KEY FiscalYear _StockMovementLine FiscalYear
KEY LedgerGLLineItem _StockMovementLine LedgerGLLineItem
KEY MaterialDocumentLine _StockMovementLine MaterialDocumentLine
RO_SAFTStandardAccount _Accmap RO_SAFTStandardAccount
BusinessTransactionTypeName _StockMovementLine BusinessTransactionTypeName
CustomerVATRegistration _StockMovementLine CustomerVATRegistration
SupplierVATRegistration _StockMovementLine SupplierVATRegistration
Product _StockMovementLine Product
Batch _StockMovementLine Batch
Quantity _StockMovementLine Quantity
PostingDate _StockMovementLine PostingDate
SourceUnitOfMeasureFactor _StockMovementLine SourceUnitOfMeasureFactor
ConversionFactor _StockMovementLine ConversionFactor
CompanyCodeCurrency _StockMovementLine CompanyCodeCurrency
TransactionAmountInLocalCrcy _StockMovementLine TransactionAmountInLocalCrcy
MaterialDocumentItemText _StockMovementLine MaterialDocumentItemText
RO_SAFTMovementType _StockMovementLine RO_SAFTMovementType 
@AbapCatalog.sqlViewName: 'CROSAFTSTKMVTITM'
@AbapCatalog.compiler.compareFilter: true
//@AbapCatalog.preserveKey: true

@VDM.viewType: #CONSUMPTION
@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MIXED
@AccessControl.personalData.blocking: #NOT_REQUIRED
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'RO SAFT Stock Movement Line'
define view C_RO_SAFTStockMovementLine
  with parameters P_Ledger          : fagl_rldnr,
                  P_AlternativeGLAccountIsUsed : boolean
  as select from I_RO_SAFTStockMovementLine( P_Ledger : $parameters.P_Ledger,
                                             P_AlternativeGLAccountIsUsed : $parameters.P_AlternativeGLAccountIsUsed )
                                     as _StockMovementLine
  association [0..1] to I_RO_SAFTAccountMapping
                                     as _Accmap on  _Accmap.ChartOfAccounts = _StockMovementLine.ChartOfAccounts
                                                and _Accmap.GLAccount = _StockMovementLine.TargetGLAccount
{
  key _StockMovementLine.AccountingDocument,
  key _StockMovementLine.CompanyCode,
  key _StockMovementLine.FiscalYear,
  key _StockMovementLine.LedgerGLLineItem,
  key _StockMovementLine.MaterialDocumentLine,
      _Accmap.RO_SAFTStandardAccount,
      _StockMovementLine.BusinessTransactionTypeName,
      _StockMovementLine.CustomerVATRegistration,
      _StockMovementLine.SupplierVATRegistration,
      _StockMovementLine.Product,
      _StockMovementLine.Batch,
      _StockMovementLine.Quantity,
      _StockMovementLine.PostingDate,
      _StockMovementLine.SourceUnitOfMeasureFactor,
      _StockMovementLine.ConversionFactor,
      _StockMovementLine.CompanyCodeCurrency,
      _StockMovementLine.TransactionAmountInLocalCrcy,
      _StockMovementLine.MaterialDocumentItemText,
      _StockMovementLine.RO_SAFTMovementType
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_RO_SAFTACCOUNTMAPPING",
"I_RO_SAFTSTOCKMOVEMENTLINE"
],
"ASSOCIATED":
[
"I_RO_SAFTACCOUNTMAPPING"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More