P_PT_SAFTISALTERNATEACCOUNT

CDS View

P_PT_SAFTISALTERNATEACCOUNT is a CDS View in S/4HANA. 19 CDS views read from this table.

Used by 19 CDS view(s)

CDS Views using this table (19)

ViewTypeJoinVDMDescription
C_PT_SAFTAccountGenLedgerC view_entity inner CONSUMPTION GL Account of Gen Ledger Document - Cube
I_PT_SAFTAccountingCustomer view inner COMPOSITE SAF-T PT Accounting Customer
I_PT_SAFTAcctgCustTaxRegnNmbr view inner COMPOSITE SAF-T Accounting Tax Registration Number
I_PT_SAFTAcctgOneTimeCustomer view inner COMPOSITE SAF-T PT Accounting One Time Customer
I_PT_SAFTAcctgSupTaxRegnNmbr view inner COMPOSITE SAF-T PT Registration Number Suppliers
I_PT_SAFTBillgCustTaxRegnNmbr view inner COMPOSITE SAF-T Billing Tax Registration Number
I_PT_SAFTBillingCustomer view inner COMPOSITE SAF-T PT Billing Customer
I_PT_SAFTBillingOneTimeCust view inner COMPOSITE SAF-T PT Billing One Time Custmer
I_PT_SAFTGenLdgrOneTmeSupplier view inner COMPOSITE SAFT PT GLEntries OTS
I_PT_SAFTGenLedCustTaxRegnNmbr view inner COMPOSITE SAF-T PT GL Registration Number Customer
I_PT_SAFTGenLedgerCustomer view inner COMPOSITE SAF-T PT Gen Ledger Customer
I_PT_SAFTGenLedgerItem view inner COMPOSITE SAF-T PT Journal Ledger Entry Item
I_PT_SAFTGenLedgerOneTimeCust view inner COMPOSITE SAF-T PT Gen Ledger OneTimeCustomer
I_PT_SAFTGenLedgerSupplier view inner COMPOSITE SAFT PT GLEntries Supplier
I_PT_SAFTPaymentCustomer view inner COMPOSITE SAF-T Payment Customer
I_PT_SAFTPaymentOneTimeCust view inner COMPOSITE SAF-T Payment One Time Customer
I_PT_SAFTPaytCustTaxRegnNmbr view inner COMPOSITE SAF-T Payment Tax Registration Number
I_PT_SAFTSettlmtMgmtCustomer view inner COMPOSITE SAF-T PT Settlement Management Customer
I_PT_SAFTSettlmtMgmtTaxRegNmbr view inner COMPOSITE SAF-T PT Settlement Mgm Tax Reg Customer 
@AbapCatalog.sqlViewName: 'PPTISALTACCT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@VDM.private: true
@VDM.viewType: #COMPOSITE 
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass:  #MIXED
@ObjectModel.usageType.serviceQuality: #D
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.personalData.blocking : #NOT_REQUIRED
define view P_PT_SAFTIsAlternateAccount 
  as select from I_PT_SAFTGenericSettings as a
  
  inner join I_FinancialStatementVersion as b on b.FinancialStatementVariant = a.FinancialStatementVersion
  
  inner join I_CompanyCode as c on c.CompanyCode = a.CompanyCode
  
{

  key a.CompanyCode,

  case
    when b.ChartOfAccounts <> c.ChartOfAccounts
     then 'X'
     else ''
  end                                        as IsAltAcct //Alternate Accounts Being Used

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

Learn More