P_RO_SAFTCACTGPYITEM0

DDL: P_RO_SAFTCACTGPYITEM0 Type: view_entity CONSUMPTION
29 Fields 1 Data Sources

P_RO_SAFTCACTGPYITEM0 is a Consumption CDS View in SAP S/4HANA. It reads from 1 data source (P_RO_SAFTCActgJournalItemExc) and exposes 29 fields with key fields CompanyCode, CASrcDocumentCat, CASrcDocumentType, CASrcDocumentNumber, CADocumentNumber.

Data Sources (1)

SourceAliasJoin Type
P_RO_SAFTCActgJournalItemExc P_RO_SAFTCActgJournalItemExc from

Parameters (1)

NameTypeDefault
P_AlternativeGLAccountIsUsed saft_ro_alt_gl_account_flag

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.private true view
VDM.viewType #CONSUMPTION view

Fields (29)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode Item CompanyCode Receiver Company Code
KEY CASrcDocumentCat Item CASrcDocumentCat
KEY CASrcDocumentType Item CASrcDocumentType
KEY CASrcDocumentNumber Item CASrcDocumentNumber
KEY CADocumentNumber Item CADocumentNumber Document Number
KEY CAItemType Item CAItemType
KEY ItemNumber Item ItemNumber Item ID
CASrcBusinessPartner Item CASrcBusinessPartner
CASrcActiveGLAccount Item CASrcActiveGLAccount
TransactionCurrency Item TransactionCurrency Transaction Currency
CompanyCodeCurrency Item CompanyCodeCurrency Local Currency
CADocumentOriginCode Item CADocumentOriginCode Document Origin
TaxCode Item TaxCode Tax Code
TaxItem Item TaxItem Tax Item
PostingDate Item PostingDate Posting Date for GR
DocumentDate Item DocumentDate Journal Entry Date
TaxReportingDate Item TaxReportingDate Tax Reporting Date
CreationDate Item CreationDate Time Stamp
CreatedByUser Item CreatedByUser User Name
ProfitCenter Item ProfitCenter Profit Center
Segment Item Segment Segment number
RO_SAFTStandardAccount Item RO_SAFTStandardAccount
CASrcOfficialDocumentNumber Item CASrcOfficialDocumentNumber
RO_SAFTJournalTransDescription Item RO_SAFTJournalTransDescription
AmountInCompanyCodeCurrency
AmountInTransactionCurrency
DebitAmountInCoCodeCrcy Item DebitAmountInCoCodeCrcy Debit Amount in Company Code Currency
CreditAmountInCoCodeCrcy Item CreditAmountInCoCodeCrcy Credit Amount in Company Code Currency
CARecnclnKeyIsTransferredToGL Item CARecnclnKeyIsTransferredToGL

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

CREATE VIEW P_RO_SAFTCACTGPYITEM0 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,
  Item.CASrcActiveGLAccount AS CASrcActiveGLAccount,
  Item.TransactionCurrency AS TransactionCurrency,
  Item.CompanyCodeCurrency AS CompanyCodeCurrency,
  Item.CADocumentOriginCode AS CADocumentOriginCode,
  Item.TaxCode AS TaxCode,
  Item.TaxItem AS TaxItem,
  Item.PostingDate AS PostingDate,
  Item.DocumentDate AS DocumentDate,
  Item.TaxReportingDate AS TaxReportingDate,
  Item.CreationDate AS CreationDate,
  Item.CreatedByUser AS CreatedByUser,
  Item.ProfitCenter AS ProfitCenter,
  Item.Segment AS Segment,
  Item.RO_SAFTStandardAccount AS RO_SAFTStandardAccount,
  Item.CASrcOfficialDocumentNumber AS CASrcOfficialDocumentNumber,
  Item.RO_SAFTJournalTransDescription AS RO_SAFTJournalTransDescription,
  abs(Item.AmountInCompanyCodeCurrency) AS AmountInCompanyCodeCurrency,
  abs(Item.AmountInTransactionCurrency) AS AmountInTransactionCurrency,
  Item.DebitAmountInCoCodeCrcy AS DebitAmountInCoCodeCrcy,
  Item.CreditAmountInCoCodeCrcy AS CreditAmountInCoCodeCrcy,
  Item.CARecnclnKeyIsTransferredToGL AS CARecnclnKeyIsTransferredToGL
FROM P_RO_SAFTCActgJournalItemExc
;

Learn More