P_GRAndInvcHistoryBcs

DDL: P_GRANDINVCHISTORYBCS SQL: PGRCGRINVCHIST Type: view COMPOSITE
30 Fields 3 Associations

Good Reciepts and Invoices History

P_GRAndInvcHistoryBcs is a Composite CDS View that provides data about "Good Reciepts and Invoices History" in SAP S/4HANA. It has 3 associations to related views.

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_PurchasingDocument _PurchasingDocument $projection.PurchasingDocument = _PurchasingDocument.PurchasingDocument
[0..1] I_SupplierInvoiceItemPurOrdRef _SupplierInvoiceItemPurOrdRef $projection.PurchasingDocument = _SupplierInvoiceItemPurOrdRef.PurchaseOrder and $projection.PurchasingDocumentItem = _SupplierInvoiceItemPurOrdRef.PurchaseOrderItem and $projection.PurchasingHistoryDocumentYear = _SupplierInvoiceItemPurOrdRef.FiscalYear and $projection.PurchasingHistoryDocument = _SupplierInvoiceItemPurOrdRef.SupplierInvoice and ( $projection.PurchasingHistoryCategory = 'G' or $projection.PurchasingHistoryCategory = 'I' or $projection.PurchasingHistoryCategory = 'K' or $projection.PurchasingHistoryCategory = 'M' or $projection.PurchasingHistoryCategory = 'N' or $projection.PurchasingHistoryCategory = 'P' or $projection.PurchasingHistoryCategory = 'Q' or $projection.PurchasingHistoryCategory = 'R' or $projection.PurchasingHistoryCategory = 'S' or $projection.PurchasingHistoryCategory = 'T' or $projection.PurchasingHistoryCategory = 'W' or $projection.PurchasingHistoryCategory = 'X' )
[0..1] I_GoodsMovementDocument _GoodsMovementDocument $projection.PurchasingHistoryDocument = _GoodsMovementDocument.MaterialDocument and $projection.PurchasingHistoryDocumentItem = _GoodsMovementDocument.MaterialDocumentItem and $projection.PurchasingHistoryDocumentYear = _GoodsMovementDocument.MaterialDocumentYear and ( $projection.PurchasingHistoryCategory = 'E' or $projection.PurchasingHistoryCategory = 'F' )

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName PGRCGRINVCHIST view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Good Reciepts and Invoices History view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
VDM.private true view
AbapCatalog.buffering.status #NOT_ALLOWED view
AccessControl.personalData.blocking #REQUIRED view

Fields (30)

KeyFieldSource TableSource FieldDescription
KEY PurchasingDocument PurchasingDocument Purchasing Document
KEY PurchasingDocumentItem PurchasingDocumentItem Purchasing Doc. Item
KEY AccountAssignmentNumber AccountAssignmentNumber Account Assgmt No.
KEY PurchasingHistoryDocumentType PurchasingHistoryDocumentType
KEY PurchasingHistoryDocumentYear PurchasingHistoryDocumentYear
KEY PurchasingHistoryDocument PurchasingHistoryDocument
KEY PurchasingHistoryDocumentItem PurchasingHistoryDocumentItem
PurchasingDocumentCategory _PurchasingDocument PurchasingDocumentCategory Doc. Category
PurchasingDocumentType _PurchasingDocument PurchasingDocumentType RFQ Type
PurchasingDocumentSubtype _PurchasingDocument PurchasingDocumentSubtype Control
CompanyCode _PurchasingDocument CompanyCode Receiver Company Code
PurchasingDocumentOrigin _PurchasingDocument PurchasingDocumentOrigin Status
PurchasingOrganization _PurchasingDocument PurchasingOrganization Purchasing Organization
PurchasingGroup _PurchasingDocument PurchasingGroup Purchasing Group
PurchasingHistoryCategory PurchasingHistoryCategory
SupplierInvoice _SupplierInvoiceItemPurOrdRef SupplierInvoice
FiscalYear _SupplierInvoiceItemPurOrdRef FiscalYear G/L Fiscal Year
InvoiceCreatedByUser
InvoiceCreationDate
MaterialDocument _GoodsMovementDocument MaterialDocument Material Doc.
GRCreatedByUser _GoodsMovementDocument CreatedByUser User Name
GoodsReceiptLatestCreationDate _GoodsMovementDocument CreationDate Time Stamp
InvoicingParty Supplier
SupplierName
_PurchasingDocument _PurchasingDocument
_PurchasingDocumentCategory _PurchasingDocument _PurchasingDocumentCategory
_PurchasingDocumentType _PurchasingDocument _PurchasingDocumentType
_CompanyCode _PurchasingDocument _CompanyCode
_PurchasingDocumentOrigin _PurchasingDocument _PurchasingDocumentOrigin
_FiscalYear _SupplierInvoiceItemPurOrdRef _FiscalYear

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_GRAndInvcHistoryBcs.
-- 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: PGRCGRINVCHIST

CREATE VIEW P_GRAndInvcHistoryBcs AS
SELECT
  PurchasingDocument,
  PurchasingDocumentItem,
  AccountAssignmentNumber,
  PurchasingHistoryDocumentType,
  PurchasingHistoryDocumentYear,
  PurchasingHistoryDocument,
  PurchasingHistoryDocumentItem,
  _PurchasingDocument.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  _PurchasingDocument.PurchasingDocumentType AS PurchasingDocumentType,
  _PurchasingDocument.PurchasingDocumentSubtype AS PurchasingDocumentSubtype,
  _PurchasingDocument.CompanyCode AS CompanyCode,
  _PurchasingDocument.PurchasingDocumentOrigin AS PurchasingDocumentOrigin,
  _PurchasingDocument.PurchasingOrganization AS PurchasingOrganization,
  _PurchasingDocument.PurchasingGroup AS PurchasingGroup,
  PurchasingHistoryCategory,
  _SupplierInvoiceItemPurOrdRef.SupplierInvoice AS SupplierInvoice,
  _SupplierInvoiceItemPurOrdRef.FiscalYear AS FiscalYear,
  _SupplierInvoiceItemPurOrdRef._SupplierInvoice.CreatedByUser AS InvoiceCreatedByUser,
  _SupplierInvoiceItemPurOrdRef._SupplierInvoice.CreationDate AS InvoiceCreationDate,
  _GoodsMovementDocument.MaterialDocument AS MaterialDocument,
  _GoodsMovementDocument.CreatedByUser AS GRCreatedByUser,
  _GoodsMovementDocument.CreationDate AS GoodsReceiptLatestCreationDate,
  _SupplierInvoiceItemPurOrdRef._SupplierInvoice.InvoicingParty AS InvoicingParty,
  _SupplierInvoiceItemPurOrdRef._SupplierInvoice._Supplier.SupplierName AS SupplierName,
  _PurchasingDocument._PurchasingDocumentCategory AS _PurchasingDocumentCategory,
  _PurchasingDocument._PurchasingDocumentType AS _PurchasingDocumentType,
  _PurchasingDocument._CompanyCode AS _CompanyCode,
  _PurchasingDocument._PurchasingDocumentOrigin AS _PurchasingDocumentOrigin,
  _SupplierInvoiceItemPurOrdRef._FiscalYear AS _FiscalYear
LEFT OUTER JOIN I_PurchasingDocument AS _PurchasingDocument ON PurchasingDocument = _PurchasingDocument.PurchasingDocument  -- association [1..1]
LEFT OUTER JOIN I_SupplierInvoiceItemPurOrdRef AS _SupplierInvoiceItemPurOrdRef ON PurchasingDocument = _SupplierInvoiceItemPurOrdRef.PurchaseOrder AND PurchasingDocumentItem = _SupplierInvoiceItemPurOrdRef.PurchaseOrderItem AND PurchasingHistoryDocumentYear = _SupplierInvoiceItemPurOrdRef.FiscalYear AND PurchasingHistoryDocument = _SupplierInvoiceItemPurOrdRef.SupplierInvoice AND ( PurchasingHistoryCategory = 'G' OR PurchasingHistoryCategory = 'I' OR PurchasingHistoryCategory = 'K' OR PurchasingHistoryCategory = 'M' OR PurchasingHistoryCategory = 'N' OR PurchasingHistoryCategory = 'P' OR PurchasingHistoryCategory = 'Q' OR PurchasingHistoryCategory = 'R' OR PurchasingHistoryCategory = 'S' OR PurchasingHistoryCategory = 'T' OR PurchasingHistoryCategory = 'W' OR PurchasingHistoryCategory = 'X' )  -- association [0..1]
LEFT OUTER JOIN I_GoodsMovementDocument AS _GoodsMovementDocument ON PurchasingHistoryDocument = _GoodsMovementDocument.MaterialDocument AND PurchasingHistoryDocumentItem = _GoodsMovementDocument.MaterialDocumentItem AND PurchasingHistoryDocumentYear = _GoodsMovementDocument.MaterialDocumentYear AND ( PurchasingHistoryCategory = 'E' OR PurchasingHistoryCategory = 'F' )  -- association [0..1]
;

Learn More