P_SOFAProcFlow41

SOFA Process Flow: Level +4 Accounting | view: PSOFAPROCF41 | Extraction: Not supported | Component: Sales Analytics

Tables used: BKPF, VBRK, VBKD, VEDA, VBAK, VBFA

🔑 Keys (5)
💰 Amounts
∑ Quantities
📅 Dates (2)
☰ Categorical (6)
Other (2)
🔗 Relations (8)

Column Name	Description
SalesDocument	Sales Document
SDDocumentCategory	SD Document Category	Show values
Level3Document	Subsequent Sales and Distribution Document
Level3DocumentCategory	Document Category of Subsequent Document	Show values
AccountingDocument	Journal Entry

Column Name	Description

Column Name	Description

Column Name	Description
RequestedDeliveryDate	Requested Delivery Date
SalesDocumentDate	Document Date (Date Received/Sent)

Column Name	Description
SDDocumentCategory	SD Document Category	Show values
Level3DocumentCategory	Document Category of Subsequent Document	Show values
OverallSDProcessStatus	Overall Processing Status (Header/All Items)	Show values
OverallTotalDeliveryStatus	Overall Delivery Status (All Items)	Show values
OverallOrdReltdBillgStatus	Order-Related Billing Status (All Items)	Show values
Level2DocumentCategory	Document Category of Subsequent Document	Show values

Column Name	Description	Domain name
PurchaseOrderByCustomer	Customer Reference	BSTKD
FiscalYear	Fiscal Year	GJAHR

Master Data Relations	Join Conditions
Company Code Company Code Client	`P_SOFAPROCFLOW41.COMPANYCODE == T001.BUKRS` `P_SOFAPROCFLOW41.MANDT == T001.MANDT`
Distribution channel in order header Distribution Channel Sales Organization Client	`P_SOFAPROCFLOW41.DISTRIBUTIONCHANNEL == TVKOV.VTWEG` `P_SOFAPROCFLOW41.SALESORGANIZATION == TVKOV.VKORG` `P_SOFAPROCFLOW41.MANDT == TVKOV.MANDT`
Division in order header Division Distribution Channel Sales Organization Client	`P_SOFAPROCFLOW41.ORGANIZATIONDIVISION == TVTA.SPART` `P_SOFAPROCFLOW41.DISTRIBUTIONCHANNEL == TVTA.VTWEG` `P_SOFAPROCFLOW41.SALESORGANIZATION == TVTA.VKORG` `P_SOFAPROCFLOW41.MANDT == TVTA.MANDT`
Order type in order header Sales Document Type Client	`P_SOFAPROCFLOW41.SALESDOCUMENTTYPE == TVAK.AUART` `P_SOFAPROCFLOW41.MANDT == TVAK.MANDT`
Sales group Sales office Client Sales group	`P_SOFAPROCFLOW41.SALESOFFICE == TVBVK.VKBUR` `P_SOFAPROCFLOW41.MANDT == TVBVK.MANDT` `P_SOFAPROCFLOW41.SALESGROUP == TVBVK.VKGRP`
Sales organization in order header Sales Organization Client	`P_SOFAPROCFLOW41.SALESORGANIZATION == TVKO.VKORG` `P_SOFAPROCFLOW41.MANDT == TVKO.MANDT`
Sold-to Party Sold-to Party Client	`P_SOFAPROCFLOW41.SOLDTOPARTY == KNA1.KUNNR` `P_SOFAPROCFLOW41.MANDT == KNA1.MANDT`

Other Relations \| to Master Data Relations ↑	Join Conditions
Sales office Division Distribution Channel Sales office Sales Organization Client	`P_SOFAPROCFLOW41.ORGANIZATIONDIVISION == TVKBZ.SPART` `P_SOFAPROCFLOW41.DISTRIBUTIONCHANNEL == TVKBZ.VTWEG` `P_SOFAPROCFLOW41.SALESOFFICE == TVKBZ.VKBUR` `P_SOFAPROCFLOW41.SALESORGANIZATION == TVKBZ.VKORG` `P_SOFAPROCFLOW41.MANDT == TVKBZ.MANDT`