P_PurOrdMaintainPDocWAccAsLine

DDL: P_PURORDMAINTAINPDOCWACCASLINE SQL: PPOMAINTPDWACALN Type: view CONSUMPTION Package: ODATA_MM_PUR_PO_MAINTAIN

PO Maintenance: Pur. Doc. Item with Account Assignment Line

P_PurOrdMaintainPDocWAccAsLine is a Consumption CDS View that provides data about "PO Maintenance: Pur. Doc. Item with Account Assignment Line" in SAP S/4HANA. It reads from 2 data sources (P_PurOrdMaintainPDocAccAssLine, I_PurchasingDocumentItem) and exposes 12 fields with key fields PurchasingDocument, PurchasingDocumentItem. Part of development package ODATA_MM_PUR_PO_MAINTAIN.

2 data source(s) 12 fields

Data Sources (2)

SourceAliasJoin Type
P_PurOrdMaintainPDocAccAssLine AccAssLine inner
I_PurchasingDocumentItem PDocItem from

Annotations (4)

NameValueLevelField
VDM.viewType #CONSUMPTION view
AbapCatalog.sqlViewName PPOMAINTPDWACALN view
VDM.private true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY PurchasingDocument I_PurchasingDocumentItem PurchasingDocument
KEY PurchasingDocumentItem I_PurchasingDocumentItem PurchasingDocumentItem
AccountAssignmentCategory I_PurchasingDocumentItem AccountAssignmentCategory
AccountAssignmentNumber P_PurOrdMaintainPDocAccAssLine AccountAssignmentNumber
CostCenter P_PurOrdMaintainPDocAccAssLine CostCenter
GLAccount P_PurOrdMaintainPDocAccAssLine GLAccount
ControllingArea P_PurOrdMaintainPDocAccAssLine ControllingArea
WBSElementInternalID P_PurOrdMaintainPDocAccAssLine WBSElementInternalID
FunctionalArea P_PurOrdMaintainPDocAccAssLine FunctionalArea
SalesOrder P_PurOrdMaintainPDocAccAssLine SalesOrder
SalesOrderItem P_PurOrdMaintainPDocAccAssLine SalesOrderItem
ProfitCenter P_PurOrdMaintainPDocAccAssLine ProfitCenter 
@VDM.viewType: #CONSUMPTION
@AbapCatalog.sqlViewName: 'PPOMAINTPDWACALN'
@VDM.private: true
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY

//--------------------------------------------------------------------------------------------------------------

// Remark: 

// Currently only the following Account Assignment Categories are supported in FIORI apps "Create/Manage PO":

//  -> 'C': Sales Order

//  -> 'K': Cost Center

//  -> 'P': Project

//  -> 'S': Third-Party

//  -> 'U': Unknown

//--------------------------------------------------------------------------------------------------------------


define view P_PurOrdMaintainPDocWAccAsLine  

  as select from I_PurchasingDocumentItem     as PDocItem
  
    inner join P_PurOrdMaintainPDocAccAssLine as AccAssLine on  PDocItem.PurchasingDocument     = AccAssLine.PurchasingDocument
                                                            and PDocItem.PurchasingDocumentItem = AccAssLine.PurchasingDocumentItem
  
{
     key PDocItem.PurchasingDocument        as PurchasingDocument,
               
     key PDocItem.PurchasingDocumentItem    as PurchasingDocumentItem,
     
         PDocItem.AccountAssignmentCategory as AccountAssignmentCategory,
               
         AccAssLine.AccountAssignmentNumber as AccountAssignmentNumber,
                
         AccAssLine.CostCenter              as CostCenter,
              
         AccAssLine.GLAccount               as GLAccount,
            
         AccAssLine.ControllingArea         as ControllingArea,
            
         AccAssLine.WBSElementInternalID    as WBSElementInternalID,
            
         AccAssLine.FunctionalArea          as FunctionalArea,
            
         AccAssLine.SalesOrder              as SalesOrder,
            
         AccAssLine.SalesOrderItem          as SalesOrderItem,
            
         AccAssLine.ProfitCenter            as ProfitCenter   
}
where PDocItem.AccountAssignmentCategory = 'C'
   or PDocItem.AccountAssignmentCategory = 'K'
   or PDocItem.AccountAssignmentCategory = 'P'
   or PDocItem.AccountAssignmentCategory = 'S'
   or PDocItem.AccountAssignmentCategory = 'U'

Learn More