C_RO_SAFTMaterialDocumentItem

DDL: C_RO_SAFTMATERIALDOCUMENTITEM SQL: CROSAFTMATDOC Type: view CONSUMPTION
27 Fields 1 Data Sources

RO SAFT Material Document Item

C_RO_SAFTMaterialDocumentItem is a Consumption CDS View that provides data about "RO SAFT Material Document Item" in SAP S/4HANA. It reads from 1 data source (I_RO_SAFTAccountingItem) and exposes 27 fields with key fields MaterialDocument, MaterialDocumentYear, MaterialDocumentLine.

Data Sources (1)

SourceAliasJoin Type
I_RO_SAFTAccountingItem _AccountingItem inner

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CROSAFTMATDOC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
Analytics.internalName #LOCAL view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #NOT_REQUIRED view
Metadata.allowExtensions true view
EndUserText.label RO SAFT Material Document Item view

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY MaterialDocument _MaterialDocItem MaterialDocument Material Doc.
KEY MaterialDocumentYear _MaterialDocItem MaterialDocumentYear Material Document Year
KEY MaterialDocumentLine _MaterialDocItem MaterialDocumentLine Line ID
Plant _MaterialDocItem Plant Valuation Area
ProjectNetworkHasSpecialStock _MaterialDocItem ProjectNetworkHasSpecialStock
GoodsMovementType _MaterialDocItem GoodsMovementType Movement Type
EntryUnit _MaterialDocItem EntryUnit Unit of Entry
GoodsMovementEntryQty _MaterialDocItem GoodsMovementEntryQty
PostingDate I_RO_SAFTAccountingItem PostingDate Posting Date for GR
Product _MaterialDocItem Product Product Sold
AlternativeUnit _MaterialDocItem AlternativeUnit Base UoM
GoodsMovementQuantity _MaterialDocItem GoodsMovementQuantity
DocumentReferenceID _MaterialDocItem DocumentReferenceID Reference
Batch _MaterialDocItem Batch Lot No.
StorageLocation _MaterialDocItem StorageLocation StorageLocation
DebitCreditCode _MaterialDocItem DebitCreditCode Single-Character Flag
ActiveGLAccount _MaterialDocItem ActiveGLAccount
TargetGLAccount I_RO_SAFTAccountingItem TargetGLAccount G/L Account
CompanyVATRegistration I_RO_SAFTAccountingItem CompanyVATRegistration VAT Reg. No.
AccountingDocumentType _MaterialDocItem AccountingDocumentType Journal Entry Type
MaterialDocumentItemText _MaterialDocItem MaterialDocumentItemText Text
MaterialLedgerTransactionType _MaterialDocItem MaterialLedgerTransactionType
OriginalReferenceDocument _MaterialDocItem OriginalReferenceDocument Reference Key
CompanyCode I_RO_SAFTAccountingItem CompanyCode Receiver Company Code
AccountingDocument I_RO_SAFTAccountingItem AccountingDocument Journal Entry
FiscalYear I_RO_SAFTAccountingItem FiscalYear G/L Fiscal Year
AccountType I_RO_SAFTAccountingItem AccountType Accounting Type(dtl)

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 C_RO_SAFTMaterialDocumentItem.
-- 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: CROSAFTMATDOC

CREATE VIEW C_RO_SAFTMaterialDocumentItem AS
SELECT
  _MaterialDocItem.MaterialDocument AS MaterialDocument,
  _MaterialDocItem.MaterialDocumentYear AS MaterialDocumentYear,
  _MaterialDocItem.MaterialDocumentLine AS MaterialDocumentLine,
  _MaterialDocItem.Plant AS Plant,
  _MaterialDocItem.ProjectNetworkHasSpecialStock AS ProjectNetworkHasSpecialStock,
  _MaterialDocItem.GoodsMovementType AS GoodsMovementType,
  _MaterialDocItem.EntryUnit AS EntryUnit,
  _MaterialDocItem.GoodsMovementEntryQty AS GoodsMovementEntryQty,
  _AccountingItem.PostingDate AS PostingDate,
  _MaterialDocItem.Product AS Product,
  _MaterialDocItem.AlternativeUnit AS AlternativeUnit,
  _MaterialDocItem.GoodsMovementQuantity AS GoodsMovementQuantity,
  _MaterialDocItem.DocumentReferenceID AS DocumentReferenceID,
  _MaterialDocItem.Batch AS Batch,
  _MaterialDocItem.StorageLocation AS StorageLocation,
  _MaterialDocItem.DebitCreditCode AS DebitCreditCode,
  _MaterialDocItem.ActiveGLAccount AS ActiveGLAccount,
  _AccountingItem.TargetGLAccount AS TargetGLAccount,
  _AccountingItem.CompanyVATRegistration AS CompanyVATRegistration,
  _MaterialDocItem.AccountingDocumentType AS AccountingDocumentType,
  _MaterialDocItem.MaterialDocumentItemText AS MaterialDocumentItemText,
  _MaterialDocItem.MaterialLedgerTransactionType AS MaterialLedgerTransactionType,
  _MaterialDocItem.OriginalReferenceDocument AS OriginalReferenceDocument,
  _AccountingItem.CompanyCode AS CompanyCode,
  _AccountingItem.AccountingDocument AS AccountingDocument,
  _AccountingItem.FiscalYear AS FiscalYear,
  _AccountingItem.AccountType AS AccountType
INNER JOIN I_RO_SAFTAccountingItem AS _AccountingItem ON /* join condition not captured in parsed metadata */
;

Learn More