P_RU_VATInTransitBillingDoc

DDL: P_RU_VATINTRANSITBILLINGDOC SQL: PRUVATTRNSTBILD Type: view CONSUMPTION

P_RU_VATInTransitBillingDoc is a Consumption CDS View in SAP S/4HANA. It reads from 2 data sources (P_RU_AcctgDocReferenceID, I_CFinBillingDocument) and exposes 8 fields.

2 data source(s) 8 fields

Data Sources (2)

SourceAliasJoin Type
P_RU_AcctgDocReferenceID AccDocRefID from
I_CFinBillingDocument BillDoc inner

Annotations (5)

NameValueLevelField
VDM.private true view
VDM.viewType #CONSUMPTION view
AbapCatalog.sqlViewName PRUVATTRNSTBILD view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (8)

KeyFieldSource TableSource FieldDescription
CompanyCode P_RU_AcctgDocReferenceID CompanyCode
AccountingDocument P_RU_AcctgDocReferenceID AccountingDocument
FiscalYear P_RU_AcctgDocReferenceID FiscalYear
ReferenceIDType P_RU_AcctgDocReferenceID ReferenceIDType
ReferenceIDDocumentNumber P_RU_AcctgDocReferenceID ReferenceIDDocumentNumber
ReferenceIDDocumentYear P_RU_AcctgDocReferenceID ReferenceIDDocumentYear
SoldToParty I_CFinBillingDocument SoldToParty
SenderLogicalSystem P_RU_AcctgDocReferenceID SenderLogicalSystem 
@VDM.private: true
@VDM.viewType: #CONSUMPTION
@AbapCatalog.sqlViewName: 'PRUVATTRNSTBILD'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED
define view P_RU_VATInTransitBillingDoc
  as select from P_RU_AcctgDocReferenceID as AccDocRefID

    inner join   I_CFinBillingDocument    as BillDoc on  BillDoc.CentralFinanceBillingDocument = AccDocRefID.ReferenceIDDocumentNumber
                                                     and BillDoc.SenderLogicalSystem           = AccDocRefID.SenderLogicalSystem
{
  AccDocRefID.CompanyCode,
  AccDocRefID.AccountingDocument,
  AccDocRefID.FiscalYear,

  AccDocRefID.ReferenceIDType,
  AccDocRefID.ReferenceIDDocumentNumber,
  AccDocRefID.ReferenceIDDocumentYear,

  BillDoc.SoldToParty,
  AccDocRefID.SenderLogicalSystem
}
where
  AccDocRefID.DocumentReferenceID like 'VAT^%'

//  as select from P_RU_AcctgDocReferenceID as AccDocRefID

//

//    inner join   I_BillingDocument        as BillDoc on BillDoc.BillingDocument = AccDocRefID.ReferenceIDDocumentNumber

//{

//  AccDocRefID.CompanyCode,

//  AccDocRefID.AccountingDocument,

//  AccDocRefID.FiscalYear,

//

//  AccDocRefID.ReferenceIDType,

//  AccDocRefID.ReferenceIDDocumentNumber,

//  AccDocRefID.ReferenceIDDocumentYear,

//

//  BillDoc.SoldToParty,

//  AccDocRefID.SenderLogicalSystem

//}

//where

//      AccDocRefID.SenderLogicalSystem =    ''

//  and AccDocRefID.DocumentReferenceID like 'VAT^%'

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CFINBILLINGDOCUMENT",
"P_RU_ACCTGDOCREFERENCEID"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More