P_PURORDMAINTAINPDOCWACCASLINE

CDS View

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

P_PURORDMAINTAINPDOCWACCASLINE is a CDS View in S/4HANA. PO Maintenance: Pur. Doc. Item with Account Assignment Line. It contains 8 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 8 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_PurOrdMaintainRefDocumentAll view left_outer CONSUMPTION PO Maintenance: Ref. Doc. for PO Create (Item + Inforecord)

Fields (8)

KeyField CDS FieldsUsed in Views
ControllingArea ControllingArea 1
CostCenter CostCenter 1
FunctionalArea FunctionalArea 1
GLAccount GLAccount 1
ProfitCenter ProfitCenter 1
SalesOrder SalesOrder 1
SalesOrderItem SalesOrderItem 1
WBSElementInternalID WBSElementInternalID 1 
@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