I_RO_SAFTStockMovementLine

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 I_RO_SAFTStockMovementLine.
-- 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: IROSAFTSTKMVTITM
-- Parameters: P_Ledger : fagl_rldnr, P_AlternativeGLAccountIsUsed : boolean

CREATE VIEW I_RO_SAFTStockMovementLine AS
SELECT
  _Acdoca.AccountingDocument AS AccountingDocument,
  _Acdoca.CompanyCode AS CompanyCode,
  _Acdoca.FiscalYear AS FiscalYear,
  _Acdoca.LedgerGLLineItem AS LedgerGLLineItem,
  _Matdoc.MaterialDocumentLine AS MaterialDocumentLine,
  _Acdoca.Product AS Product,
  _Acdoca.Plant AS Plant,
  _Acdoca.DebitCreditCode AS DebitCreditCode,
  _Acdoca.AccountingDocumentType AS AccountingDocumentType,
  _Acdoca.Quantity AS Quantity,
  _Acdoca.PostingDate AS PostingDate,
  _Acdoca.DocumentDate AS DocumentDate,
  _Acdoca.CompanyCodeCurrency AS CompanyCodeCurrency,
  _Acdoca.AmountInCompanyCodeCurrency AS TransactionAmountInLocalCrcy,
  _Acdoca.AccountingDocCreatedByUser AS AccountingDocCreatedByUser,
  _Matdoc.GoodsMovementType AS GoodsMovementType,
  _Matdoc.Batch AS Batch,
  _Matdoc.MaterialDocumentItemText AS MaterialDocumentItemText,
  _Uom.SourceUnitOfMeasureFactor AS SourceUnitOfMeasureFactor,
  case $parameters.P_AlternativeGLAccountIsUsed when 'X' then _Acdoca.CountryChartOfAccounts else _Acdoca.ChartOfAccounts end as ChartOfAccounts AS ChartOfAccountsendasChartOfAccounts,
  cast( case $parameters.P_AlternativeGLAccountIsUsed when 'X' then _GLAccount.AlternativeGLAccount else _Acdoca.GLAccount end as saknr ) as TargetGLAccount AS GLAccountendassaknrasTargetGLAccount
FROM I_GLAccountLineItemRawData AS _Acdoca
INNER JOIN I_RO_SAFTMaterialDocumentItem AS _Matdoc ON /* join condition not captured in parsed metadata */
INNER JOIN I_CompanyCode AS _CompanyCode ON /* join condition not captured in parsed metadata */
INNER JOIN I_RO_SAFTDocumentTypeMap AS _DocumentMap ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ProductUnitsOfMeasure AS _ProductUom ON _Matdoc.Product = _ProductUom.Product AND _Matdoc.AlternativeUnit = _ProductUom.AlternativeUnit  -- association [0..1]
LEFT OUTER JOIN I_RO_SAFTUnitOfMeasureMap AS _Uom ON _Matdoc.AlternativeUnit = _Uom.SourceUnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_RO_BusinessPartnerTaxType AS _DCustomer ON _DCustomer.BusinessPartner = _Acdoca.Customer AND _DCustomer.BusinessPartnerIsSAFTRelevant = 'X' AND _DCustomer.TaxType = '6' AND _DCustomer.FinancialAccountType = 'D' AND _DCustomer.ValidFrom <= $session.system_date AND _DCustomer.ValidTo >= $session.system_date AND _DCustomer.VATRegistration is not initial  -- association [0..*]
LEFT OUTER JOIN I_RO_BusinessPartnerTaxType AS _KSupplier ON _KSupplier.BusinessPartner = _Acdoca.Supplier AND _KSupplier.BusinessPartnerIsSAFTRelevant = 'X' AND _KSupplier.TaxType = '6' AND _KSupplier.FinancialAccountType = 'K' AND _KSupplier.ValidFrom <= $session.system_date AND _KSupplier.ValidTo >= $session.system_date AND _KSupplier.VATRegistration is not initial  -- association [0..*]
LEFT OUTER JOIN I_GLAccountInCompanyCode AS _GLAccount ON _GLAccount.CompanyCode = _Acdoca.CompanyCode AND _GLAccount.GLAccount = _Acdoca.GLAccount  -- association [0..1]
LEFT OUTER JOIN I_RO_SAFTMvtTypeTableEntry AS _MovementType1 ON _MovementType1.GoodsMovementType = _Matdoc.GoodsMovementType AND _MovementType1.Plant = _Acdoca.Plant AND _MovementType1.TargetGLAccount = _Acdoca.GLAccount AND _MovementType1.AccountingDocumentType = _Acdoca.AccountingDocumentType AND _MovementType1.DebitCreditCode = _Acdoca.DebitCreditCode  -- association [0..1]
LEFT OUTER JOIN I_RO_SAFTMvtTypeTableEntry AS _MovementType2 ON _MovementType2.GoodsMovementType = _Matdoc.GoodsMovementType AND _MovementType2.Plant = _Acdoca.Plant AND _MovementType2.TargetGLAccount = _Acdoca.GLAccount AND _MovementType2.AccountingDocumentType = _Acdoca.AccountingDocumentType AND _MovementType2.DebitCreditCode = ''  -- association [0..1]
LEFT OUTER JOIN I_RO_SAFTMvtTypeTableEntry AS _MovementType3 ON _MovementType3.GoodsMovementType = _Matdoc.GoodsMovementType AND _MovementType3.Plant = _Acdoca.Plant AND _MovementType3.TargetGLAccount = _Acdoca.GLAccount AND _MovementType3.AccountingDocumentType = '' AND _MovementType3.DebitCreditCode = ''  -- association [0..1]
LEFT OUTER JOIN I_RO_SAFTMvtTypeTableEntry AS _MovementType4 ON _MovementType4.GoodsMovementType = _Matdoc.GoodsMovementType AND _MovementType4.Plant = _Acdoca.Plant AND _MovementType4.TargetGLAccount = _Acdoca.GLAccount AND _MovementType4.AccountingDocumentType = '' AND _MovementType4.DebitCreditCode = _Acdoca.DebitCreditCode  -- association [0..1]
LEFT OUTER JOIN I_RO_SAFTMvtTypeTableEntry AS _MovementType5 ON _MovementType5.GoodsMovementType = _Matdoc.GoodsMovementType AND _MovementType5.Plant = _Acdoca.Plant AND _MovementType5.TargetGLAccount = '' AND _MovementType5.AccountingDocumentType = _Acdoca.AccountingDocumentType AND _MovementType5.DebitCreditCode = _Acdoca.DebitCreditCode  -- association [0..1]
LEFT OUTER JOIN I_RO_SAFTMvtTypeTableEntry AS _MovementType6 ON _MovementType6.GoodsMovementType = _Matdoc.GoodsMovementType AND _MovementType6.Plant = _Acdoca.Plant AND _MovementType6.TargetGLAccount = '' AND _MovementType6.AccountingDocumentType = '' AND _MovementType6.DebitCreditCode = ''  -- association [0..1]
LEFT OUTER JOIN I_RO_SAFTMvtTypeTableEntry AS _MovementType7 ON _MovementType7.GoodsMovementType = _Matdoc.GoodsMovementType AND _MovementType7.Plant = '' AND _MovementType7.TargetGLAccount = '' AND _MovementType7.AccountingDocumentType = '' AND _MovementType7.DebitCreditCode = ''  -- association [0..1]
;