P_PurOrdMaintainPDocAccAssLine

DDL: P_PURORDMAINTAINPDOCACCASSLINE SQL: PPOMAINTACCLINE Type: view CONSUMPTION

P_PurOrdMaintainPDocAccAssLine is a Consumption CDS View in SAP S/4HANA. It reads from 2 data sources (I_PurgDocAccountAssignment, P_PurOrdMaintainPdocAccAssHlpr) and exposes 11 fields with key fields PurchasingDocument, PurchasingDocumentItem.

2 data source(s) 11 fields

Data Sources (2)

SourceAliasJoin Type
I_PurgDocAccountAssignment AccAss from
P_PurOrdMaintainPdocAccAssHlpr P_PurOrdMaintainPdocAccAssHlpr inner

Annotations (4)

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

Fields (11)

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

define view P_PurOrdMaintainPDocAccAssLine  

  as select from I_PurgDocAccountAssignment as AccAss 
  
    inner join P_PurOrdMaintainPdocAccAssHlpr on  AccAss.PurchasingDocument      = P_PurOrdMaintainPdocAccAssHlpr.PurchasingDocument  
                                              and AccAss.PurchasingDocumentItem  = P_PurOrdMaintainPdocAccAssHlpr.PurchasingDocumentItem
                                              and AccAss.AccountAssignmentNumber = P_PurOrdMaintainPdocAccAssHlpr.AccountAssignmentNumber  
  
{
        key AccAss.PurchasingDocument     as PurchasingDocument,
                
        key AccAss.PurchasingDocumentItem as PurchasingDocumentItem,
               
            AccAss.AccountAssignmentNumber as AccountAssignmentNumber,
                
            AccAss.CostCenter              as CostCenter,
               
            AccAss.GLAccount               as GLAccount,
            
            AccAss.ControllingArea         as ControllingArea,
            
            AccAss.WBSElementInternalID    as WBSElementInternalID,
            
            AccAss.FunctionalArea          as FunctionalArea,
            
            AccAss.SalesOrder              as SalesOrder,
            
            AccAss.SalesOrderItem          as SalesOrderItem,
            
            AccAss.ProfitCenter            as ProfitCenter
}              
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PURGDOCACCOUNTASSIGNMENT",
"P_PURORDMAINTAINPDOCACCASSHLPR"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More