P_PL_SAFTMaterialDocumentRecd

DDL: P_PL_SAFTMATERIALDOCUMENTRECD SQL: PPLSAFTMATDOCREC Type: view COMPOSITE
58 Fields 3 Data Sources 3 Associations

P_PL_SAFTMaterialDocumentRecd is a Composite CDS View in SAP S/4HANA. It reads from 3 data sources (I_MaterialDocumentRecord, I_Material, I_PL_SAFTMaterialDocItemBasic) and exposes 58 fields with key fields CompanyCode, PL_GoodsMovementTypeCategory, Plant, StorageLocation, MaterialDocumentYear. It has 3 associations to related views.

Data Sources (3)

SourceAliasJoin Type
I_MaterialDocumentRecord a inner
I_Material m inner
I_PL_SAFTMaterialDocItemBasic v inner

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_ProductValuationBasic _ProductValuation a.Material = _ProductValuation.Product and a.InventoryValuationType = _ProductValuation.ValuationType and a.CompanyCode = _ProductValuation.ValuationArea
[0..1] P_PL_SAFTPOSupplierInvoice _POSupplierInvoice a.PurchaseOrder = _POSupplierInvoice.PurchasingDocument and a.PurchaseOrderItem = _POSupplierInvoice.PurchasingDocumentItem
[0..1] P_PL_SAFTGdsMvtBillDocument _GoodsMovementBillingDocument a.DeliveryDocument = _GoodsMovementBillingDocument.DeliveryDocument and a.DeliveryDocumentItem = _GoodsMovementBillingDocument.DeliveryDocumentItem

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PPLSAFTMATDOCREC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #P view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (58)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_MaterialDocumentRecord CompanyCode Receiver Company Code
KEY PL_GoodsMovementTypeCategory z PL_GoodsMovementTypeCategory
KEY Plant I_MaterialDocumentRecord Plant Valuation Area
KEY StorageLocation I_MaterialDocumentRecord StorageLocation StorageLocation
KEY MaterialDocumentYear z MaterialDocumentYear Material Document Year
KEY MaterialDocument z MaterialDocument Material Doc.
KEY MaterialDocumentItem z MaterialDocumentItem Material Document Item
FiscalYear I_MaterialDocumentRecord FiscalYear G/L Fiscal Year
Material I_MaterialDocumentRecord Material Vehicle Model
InventoryValuationType I_MaterialDocumentRecord InventoryValuationType Valuation Type
Customer I_MaterialDocumentRecord Customer Sold-to Party
Supplier I_MaterialDocumentRecord Supplier Supplier
IssuingOrReceivingPlant I_MaterialDocumentRecord IssuingOrReceivingPlant Transfer Plant
IssuingOrReceivingStorageLoc I_MaterialDocumentRecord IssuingOrReceivingStorageLoc Receiving SLoc.
IssgOrRcvgSpclStockInd I_MaterialDocumentRecord IssgOrRcvgSpclStockInd Special Stock
GoodsReceiptType I_MaterialDocumentRecord GoodsReceiptType Receipt Ind.
GoodsRecipientName I_MaterialDocumentRecord GoodsRecipientName Recipient Name
DocumentDate I_MaterialDocumentRecord DocumentDate Journal Entry Date
PostingDate I_MaterialDocumentRecord PostingDate Posting Date for GR
PurchaseOrder I_MaterialDocumentRecord PurchaseOrder Purchasing Document
PurchaseOrderItem I_MaterialDocumentRecord PurchaseOrderItem Purchasing Document Item
DeliveryDocument I_MaterialDocumentRecord DeliveryDocument Outbound Delivery
DeliveryDocumentItem I_MaterialDocumentRecord DeliveryDocumentItem Outb. Delivery Item
BillOfLading I_MaterialDocumentRecord BillOfLading
GoodsMovementType I_MaterialDocumentRecord GoodsMovementType Movement Type
DebitCreditCode I_MaterialDocumentRecord DebitCreditCode Single-Character Flag
IsAutomaticallyCreated I_MaterialDocumentRecord IsAutomaticallyCreated Is Automatically Created
InventorySpecialStockType I_MaterialDocumentRecord InventorySpecialStockType Special Stock Type
MasterFixedAsset I_MaterialDocumentRecord MasterFixedAsset Fixed Asset
FixedAsset I_MaterialDocumentRecord FixedAsset Sub-number
ControllingArea I_MaterialDocumentRecord ControllingArea Controlling Area
CostCenter I_MaterialDocumentRecord CostCenter Cost Center
ManufacturingOrder I_MaterialDocumentRecord ManufacturingOrder Order
WBSElementInternalID I_MaterialDocumentRecord WBSElementInternalID WBS Internal ID
GLAccount I_MaterialDocumentRecord GLAccount General Ledger
MaterialBaseUnit I_MaterialDocumentRecord MaterialBaseUnit Valuation Unit
CompanyCodeCurrency I_MaterialDocumentRecord CompanyCodeCurrency Local Currency
_Plant _Plant
_StorageLocation _StorageLocation
_IssuingOrReceivingPlant _IssuingOrReceivingPlant
_IssuingOrReceivingStorageLoc _IssuingOrReceivingStorageLoc
_Material _Material
_MaterialBaseUnit _MaterialBaseUnit
_ProductValuation _ProductValuation
_Customer _Customer
_Supplier _Supplier
_PurchaseOrder _PurchaseOrder
_PurchaseOrderItem _PurchaseOrderItem
_DeliveryDocument _DeliveryDocument
_DeliveryDocumentItem _DeliveryDocumentItem
_GoodsMovementBillingDocument _GoodsMovementBillingDocument
_POSupplierInvoice _POSupplierInvoice
_MasterFixedAsset _MasterFixedAsset
_FixedAsset _FixedAsset
_CostCenter _CostCenter
_ManufacturingOrder _ManufacturingOrder
_WBSElement _WBSElement
_GLAccount _GLAccount

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_PL_SAFTMaterialDocumentRecd.
-- 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: PPLSAFTMATDOCREC

CREATE VIEW P_PL_SAFTMaterialDocumentRecd AS
SELECT
  a.CompanyCode AS CompanyCode,
  z.PL_GoodsMovementTypeCategory AS PL_GoodsMovementTypeCategory,
  a.Plant AS Plant,
  a.StorageLocation AS StorageLocation,
  z.MaterialDocumentYear AS MaterialDocumentYear,
  z.MaterialDocument AS MaterialDocument,
  z.MaterialDocumentItem AS MaterialDocumentItem,
  a.FiscalYear AS FiscalYear,
  a.Material AS Material,
  a.InventoryValuationType AS InventoryValuationType,
  a.Customer AS Customer,
  a.Supplier AS Supplier,
  a.IssuingOrReceivingPlant AS IssuingOrReceivingPlant,
  a.IssuingOrReceivingStorageLoc AS IssuingOrReceivingStorageLoc,
  a.IssgOrRcvgSpclStockInd AS IssgOrRcvgSpclStockInd,
  a.GoodsReceiptType AS GoodsReceiptType,
  a.GoodsRecipientName AS GoodsRecipientName,
  a.DocumentDate AS DocumentDate,
  a.PostingDate AS PostingDate,
  a.PurchaseOrder AS PurchaseOrder,
  a.PurchaseOrderItem AS PurchaseOrderItem,
  a.DeliveryDocument AS DeliveryDocument,
  a.DeliveryDocumentItem AS DeliveryDocumentItem,
  a.BillOfLading AS BillOfLading,
  a.GoodsMovementType AS GoodsMovementType,
  a.DebitCreditCode AS DebitCreditCode,
  a.IsAutomaticallyCreated AS IsAutomaticallyCreated,
  a.InventorySpecialStockType AS InventorySpecialStockType,
  a.MasterFixedAsset AS MasterFixedAsset,
  a.FixedAsset AS FixedAsset,
  a.ControllingArea AS ControllingArea,
  a.CostCenter AS CostCenter,
  a.ManufacturingOrder AS ManufacturingOrder,
  a.WBSElementInternalID AS WBSElementInternalID,
  a.GLAccount AS GLAccount,
  a.MaterialBaseUnit AS MaterialBaseUnit,
  a.CompanyCodeCurrency AS CompanyCodeCurrency
INNER JOIN I_MaterialDocumentRecord AS a ON /* join condition not captured in parsed metadata */
INNER JOIN I_PL_SAFTMaterialDocItemBasic AS v ON /* join condition not captured in parsed metadata */
INNER JOIN I_Material AS m ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ProductValuationBasic AS _ProductValuation ON a.Material = _ProductValuation.Product AND a.InventoryValuationType = _ProductValuation.ValuationType AND a.CompanyCode = _ProductValuation.ValuationArea  -- association [0..1]
LEFT OUTER JOIN P_PL_SAFTPOSupplierInvoice AS _POSupplierInvoice ON a.PurchaseOrder = _POSupplierInvoice.PurchasingDocument AND a.PurchaseOrderItem = _POSupplierInvoice.PurchasingDocumentItem  -- association [0..1]
LEFT OUTER JOIN P_PL_SAFTGdsMvtBillDocument AS _GoodsMovementBillingDocument ON a.DeliveryDocument = _GoodsMovementBillingDocument.DeliveryDocument AND a.DeliveryDocumentItem = _GoodsMovementBillingDocument.DeliveryDocumentItem  -- association [0..1]
;

Learn More