P_SalesDocumentsForProjects

Billing Receivables - Sales generated in Projects | view: PSDSALESFORPROJ | TRAN | Extraction: Not supported | Component: S/4HANA Professional Services Cloud - CPM
Tables used: VBAPVBAKVBAPVBKDVEDAPROJPRPS
Column Name Description
Column Name Description
SalesOrderNetAmount Net Value of the Order Item in Document Currency
DebitMemoRequestNetAmount Net Value of the Order Item in Document Currency
InvcdDebitMemoReqAmtInprojCrcy Net Value of the Order Item in Document Currency
OpenBillingRequestAmount Net Value of the Order Item in Document Currency
BillingRequestOverdueAmount Net Value of the Order Item in Document Currency
Column Name Description
Column Name Description
CurrentDate null
BillingDocumentDate Billing Date
Column Name Description
SDDocumentCategory SD Document Category Show values
ReferenceSDDocumentCategory Document Category of Preceding SD Document Show values
SDDocumentRejectionStatus Rejection Status (Item) Show values
OrderRelatedBillingStatus Order-Related Billing Status (Item) Show values
Column Name Description Domain name
SalesOrder Document number of the reference document VBELN
SalesOrderItem null
DebitMemoRequest Sales Document VBELN
DebitMemoRequestItem null
FiscalPeriod Posting period POPER
FiscalYear Fiscal Year GJAHR
Project Project definition PS_PSPID
WBSElement Work Breakdown Structure Element (WBS Element) PS_POSID
Master Data Relations Join Conditions
Material: order item
  • Client
  • Material Number
  • P_SALESDOCUMENTSFORPROJECTS.MANDT == MARA.MANDT
  • P_SALESDOCUMENTSFORPROJECTS.MATERIAL == MARA.MATNR
Profile ID for project structure
  • Client
  • Project Profile
  • P_SALESDOCUMENTSFORPROJECTS.MANDT == TCJ41.MANDT
  • P_SALESDOCUMENTSFORPROJECTS.PROJECTPROFILECODE == TCJ41.PROFIDPROJ
Sales document item category
  • Client
  • Sales document item category
  • P_SALESDOCUMENTSFORPROJECTS.MANDT == TVPT.MANDT
  • P_SALESDOCUMENTSFORPROJECTS.SALESDOCUMENTITEMCATEGORY == TVPT.PSTYV