P_RO_SAFTCActgSIItem

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_RO_SAFTCActgSIItem.
-- 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.
-- Parameters: P_AlternativeGLAccountIsUsed : saft_ro_alt_gl_account_flag, P_UserSystemIdentifier : sysid

CREATE VIEW P_RO_SAFTCActgSIItem AS
SELECT
  Item.CompanyCode AS CompanyCode,
  Item.CASrcDocumentCat AS CASrcDocumentCat,
  Item.CASrcDocumentType AS CASrcDocumentType,
  Item.CASrcDocumentNumber AS CASrcDocumentNumber,
  Item.CADocumentNumber AS CADocumentNumber,
  Item.CAItemType AS CAItemType,
  Item.ItemNumber AS ItemNumber,
  Item.CASrcBusinessPartner AS CASrcBusinessPartner,
  CustomerTaxType.VATRegistration AS CustomerTaxID5,
  CustomerTaxType.StreetName AS StreetName,
  CustomerTaxType.CityName AS CityName,
  CustomerTaxType.PostalCode AS PostalCode,
  CustomerTaxType.Country AS Country,
  Item.CASrcActiveGLAccount AS CASrcActiveGLAccount,
  Item.CASrcDebitCreditCode AS CASrcDebitCreditCode,
  Item.CASrcSaftStandardAccount AS CASrcSaftStandardAccount,
  Item.CAInvcgProcess AS CAInvcgProcess,
  Item.CAInvcgType AS CAInvcgType,
  Item.CAInvcgCategory AS CAInvcgCategory,
  Item.CAInvcgCorrectionCategory AS CAInvcgCorrectionCategory,
  Item.RO_SAFTStandardAccount AS RO_SAFTStandardAccount,
  Item.TransactionCurrency AS TransactionCurrency,
  Item.CompanyCodeCurrency AS CompanyCodeCurrency,
  Item.TaxCode AS TaxCode,
  Item.TaxItem AS TaxItem,
  Item.PostingDate AS PostingDate,
  Item.DocumentDate AS DocumentDate,
  case when Item.TaxReportingDate <> '00000000' then Item.TaxReportingDate else Item.DocumentDate end as TaxReportingDate AS DocumentDateendasTaxReportingDate,
  cast ( substring(Item.PostingDate, 1, 4 ) as fis_gjahr ) AS PeriodYear,
  cast ( substring(Item.PostingDate, 5, 2 ) as fins_bat_fiscal_period ) AS Period,
  Item.CreationDate AS CreationDate,
  Item.CADocumentType AS CADocumentType,
  Item.CADocumentOriginCode AS CADocumentOriginCode,
  Item.CreatedByUser AS CreatedByUser,
  Item.ProfitCenter AS ProfitCenter,
  Item.Segment AS Segment,
  Item.BaseUnit AS BaseUnit,
  case when Item.QuantityInBaseUnit = 0 then case Item.RO_SAFTIsDefaultZeroQuantity when 'X' then cast(0 as quan1_12) else cast(1 as quan1_12) end else abs(Item.QuantityInBaseUnit) end as Quantity AS QuantityInBaseUnitendasQuantity,
  coalesce(UoM.SourceUnitOfMeasureFactor, '') AS SourceUnitOfMeasureFactor,
  Item.DebitCreditCode AS DebitCreditCode,
  Item.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  Item.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  Item.DebitAmountInCoCodeCrcy AS DebitAmountInCoCodeCrcy,
  Item.CreditAmountInCoCodeCrcy AS CreditAmountInCoCodeCrcy,
  cast('0' as text) AS SelfBillingValueItemDesc,
  cast('NULL' as farp_sgtxt) AS DocumentItemText,
  cast(concat( $parameters.P_UserSystemIdentifier, concat(cast( $session.client as char3 ) , Item.CADocumentNumber ) ) as text18) AS RO_SAFTSystemID,
  Item.CASrcOfficialDocumentNumber AS RO_SAFTSourceDocument,
  Item.CARecnclnKeyIsTransferredToGL AS CARecnclnKeyIsTransferredToGL
FROM P_RO_SAFTCACTGSIITEM0
;