P_Purchaseorders_Fs

DDL: P_PURCHASEORDERS_FS SQL: PPURORDERSFS Type: view BASIC Package: VDM_MD_PRODUCT_OBSOLETE
26 Fields 9 Data Sources

Private factsheet - Purchase Orders

P_Purchaseorders_Fs is a Basic CDS View that provides data about "Private factsheet - Purchase Orders" in SAP S/4HANA. It reads from 9 data sources and exposes 26 fields with key field PurchasingDocument. Part of development package VDM_MD_PRODUCT_OBSOLETE.

Data Sources (9)

SourceAliasJoin Type
I_CompanyCode Company left_outer
I_PurchasingDocumentTypeText DocumentTypeName left_outer
P_PlantAddrDetails_Fs PlantData left_outer
I_PurchasingDocument PurchaseDoc from
I_PurchasingDocumentItem PurchaseDocItem left_outer
I_PurchasingGroup PurgGroup left_outer
I_PurchasingOrganization PurgOrg left_outer
P_Prchinforecordslang_Fs Supplier left_outer
P_Usercontactcard_Fs UserName left_outer

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName PPURORDERSFS view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #BASIC view
VDM.private true view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY PurchasingDocument I_PurchasingDocument PurchasingDocument Purchasing Document
CompanyCode I_PurchasingDocument CompanyCode Receiver Company Code
Material I_PurchasingDocumentItem Material Vehicle Model
CompanyCodeName I_CompanyCode CompanyCodeName Company Name
PersonFullName P_Usercontactcard_Fs PersonFullName Full Name
IncotermsClassification I_PurchasingDocument IncotermsClassification Incoterms
IncotermsTransferLocation I_PurchasingDocument IncotermsTransferLocation Incoterms 2
PurchasingGroup I_PurchasingDocument PurchasingGroup Purchasing Group
PurchasingOrganization I_PurchasingDocument PurchasingOrganization Purchasing Organization
AdditionalName P_Prchinforecordslang_Fs AdditionalName Name 2
Supplier I_PurchasingDocument Supplier Supplier
SupplyingPlant I_PurchasingDocument SupplyingPlant Supplying Plant
PaymentTerms I_PurchasingDocument PaymentTerms Pyt Terms
PurchaseContract I_PurchasingDocument PurchaseContract Purchasing Doc.
CreatedByUser I_PurchasingDocument CreatedByUser User Name
DocumentCurrency I_PurchasingDocument DocumentCurrency Document Currency
PurchasingDocumentOrderDate I_PurchasingDocument PurchasingDocumentOrderDate PO Date
CreationDate I_PurchasingDocument CreationDate Time Stamp
PurchasingDocumentType I_PurchasingDocument PurchasingDocumentType RFQ Type
PurchasingGroupName I_PurchasingGroup PurchasingGroupName Purchasing Grp. Name
PurchasingOrganizationName I_PurchasingOrganization PurchasingOrganizationName Purch. Org. Name
SupplierName
PurchasingDocumentCategory I_PurchasingDocument PurchasingDocumentCategory Doc. Category
Language I_PurchasingDocument Language Report Text Language
PurchasingDocumentTypeName I_PurchasingDocumentTypeText PurchasingDocumentTypeName Description
PlantName P_PlantAddrDetails_Fs PlantName Plant Name

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_Purchaseorders_Fs.
-- 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: PPURORDERSFS

CREATE VIEW P_Purchaseorders_Fs AS
SELECT
  PurchaseDoc.PurchasingDocument AS PurchasingDocument,
  PurchaseDoc.CompanyCode AS CompanyCode,
  PurchaseDocItem.Material AS Material,
  Company.CompanyCodeName AS CompanyCodeName,
  UserName.PersonFullName AS PersonFullName,
  PurchaseDoc.IncotermsClassification AS IncotermsClassification,
  PurchaseDoc.IncotermsTransferLocation AS IncotermsTransferLocation,
  PurchaseDoc.PurchasingGroup AS PurchasingGroup,
  PurchaseDoc.PurchasingOrganization AS PurchasingOrganization,
  Supplier.AdditionalName AS AdditionalName,
  PurchaseDoc.Supplier AS Supplier,
  PurchaseDoc.SupplyingPlant AS SupplyingPlant,
  PurchaseDoc.PaymentTerms AS PaymentTerms,
  PurchaseDoc.PurchaseContract AS PurchaseContract,
  PurchaseDoc.CreatedByUser AS CreatedByUser,
  PurchaseDoc.DocumentCurrency AS DocumentCurrency,
  PurchaseDoc.PurchasingDocumentOrderDate AS PurchasingDocumentOrderDate,
  PurchaseDoc.CreationDate AS CreationDate,
  PurchaseDoc.PurchasingDocumentType AS PurchasingDocumentType,
  PurgGroup.PurchasingGroupName AS PurchasingGroupName,
  PurgOrg.PurchasingOrganizationName AS PurchasingOrganizationName,
  Concat(Concat(concat_with_space(Supplier.SupplierName , '(', 1),ltrim(PurchaseDoc.Supplier, '0')),')') AS SupplierName,
  PurchaseDoc.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  PurchaseDoc.Language AS Language,
  DocumentTypeName.PurchasingDocumentTypeName AS PurchasingDocumentTypeName,
  PlantData.PlantName AS PlantName
FROM I_PurchasingDocument AS PurchaseDoc
LEFT OUTER JOIN I_PurchasingDocumentItem AS PurchaseDocItem ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CompanyCode AS Company ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PurchasingGroup AS PurgGroup ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PurchasingOrganization AS PurgOrg ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_Usercontactcard_Fs AS UserName ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_Prchinforecordslang_Fs AS Supplier ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PurchasingDocumentTypeText AS DocumentTypeName ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_PlantAddrDetails_Fs AS PlantData ON /* join condition not captured in parsed metadata */
;

Learn More