I_SAPCLIENT

CDS View

SAP Client

I_SAPCLIENT is a CDS View in S/4HANA. SAP Client. It contains 3 fields. 170 CDS views read from this table.

Used by 170 CDS view(s) 3 fields

CDS Views using this table (170)

ViewTypeJoinVDMDescription
A_VMSVehicle view inner COMPOSITE Vehicle Details
A_VMSVehicleHistory view inner COMPOSITE Vehicle History
A_VMSVehicleIncomingInvoice view inner COMPOSITE Vehicle Incoming Invoice
A_VMSVehicleInvoice view inner COMPOSITE Vehicle Outgoing Invoice
A_VMSVehicleLocation view inner COMPOSITE Vehicle Location
A_VMSVehiclePurchaseOrder view inner COMPOSITE Vehicle Purchase Order
A_VMSVehicleSalesOrder view inner COMPOSITE Vehicle Sales Order
A_VMSVehicleToEquipment view inner COMPOSITE Vehicle to Equipment Mapping
ACR_PL_SAFT_HELPER_CALC_2 view from SAF-T PL: Helper class calculations 2
ACR_PL_SAFT_HELPER_ITEM_TOTAL view from SAF-T PL: Helper class for item totals
ACR_PL_SAFT_HELPER_SET_AMOUNTS view from SAF-T PL: Helper class check all GT 0
ACR_PL_SAFT_HELPER_SUM_AMOUNT view from SAF-T PL: Helper class for sum amounts
C_Customer360Configuration view_entity from CONSUMPTION Customer 360 System Configuration
GLE_ADB_KFC_ARCHIVE view_entity from Archive Data for ADB KFC
H_HU_StRpDeclTaxAmount view from Convert amt to declarable amount
H_HU_StRpECSLEazon2 view from
H_Hu_Strpecslformid view from
H_HU_StRpECSLRoundNeg view from
H_HU_StRpECSlsListRptgPerd view from
H_HU_StRpFormatDate view from Initial Datum To Empty String
H_NL_Round view from Round amount without decimal places
H_NL_TimeStamp view from
I_ControllingArea view left_outer BASIC Controlling Area
I_CurEHSLocationInclRoot view union COMPOSITE Current revision of EHS Locations
I_CurrentEHSParentLocationID view union COMPOSITE Current EHS Location and Parent ID
I_EHSCmplncAnlysFltrTaskC view from COMPOSITE Compliance Analysis FIlter Cube
I_EHSCountriesExclGroups view union BASIC Countries/Regions excluding groups
I_EHSCountriesTextExclGroups view union BASIC Country/Region names excluding groups
I_EHSLocationIncludingRoot view union COMPOSITE EHS Location Including the Root Location
I_FinWBSElementHierarchy view_entity union_all COMPOSITE Fin WBS Element Hierarchy
I_MySessionContext view from BASIC Session Context of the current user
I_OptionalMyEHSLocationFilter view union_all COMPOSITE Optional My EHS Location Filter
I_RU_MaterialReceiptDateMM view from COMPOSITE FI RU get Material Receipt Date: MM
P_Actualcashflowdaterange view inner COMPOSITE
P_AU_STRPBASCALCULATION view from COMPOSITE
P_AU_StRpBASGLBalSum view union_all CONSUMPTION
P_ClassicPayingValuation view from BASIC
P_ClientBehavior view from BASIC
P_Comonavg_Amount view inner COMPOSITE
P_DefaultCurrencyPair view from COMPOSITE
P_DefaultCurrencyPair view union_all COMPOSITE
P_DisplayCurrency view from CONSUMPTION Display Currency of the Total Amount KPI
P_DisplayCurrencyMaterialGroup view from CONSUMPTION Display currency used for Material Group related Spends(PUC)
P_DisplayCurrencySupplier view from CONSUMPTION Display currency for supplier related spends
P_FqmFlowTypeKeyFigure view inner BASIC
P_Fqmtransactiondate view inner BASIC
P_Fqmtransdate view inner COMPOSITE
P_KZ_DATE_HELPER view from COMPOSITE
P_KZ_FILENAME_HELPER view from COMPOSITE
P_KZ_VAT_HELPER view from COMPOSITE
P_Lfodaterange view inner COMPOSITE
P_Lfomonth view inner COMPOSITE
P_Liquidityforecast_Daterange view inner COMPOSITE
P_MaterialStockPeriods view union_all COMPOSITE
P_MatlStkPerdsInMonth view from COMPOSITE
P_PH_TAXRETURNCALCULATION2 view_entity from BASIC
P_PL_SAFTReportSequence view from BASIC
P_PlanData_RT_01 view inner COMPOSITE
P_ProcMonPeriodMonthStart view from COMPOSITE
P_ProcMonPeriodMonthStartSyst view from COMPOSITE
P_ProcMonPeriodStart view from COMPOSITE
P_ProcMonPeriodStartSyst view from COMPOSITE
P_RealTimeRptdFinData_01 view inner COMPOSITE
P_RepFinData_RT_Aggr_02 view inner COMPOSITE
P_ReportedFinancialData_RT_01 view inner COMPOSITE
P_RFD_RT_AGGR_simple_02 view inner COMPOSITE
P_RU_DSVATSPLedgersJournal3 view from CONSUMPTION
P_RU_DSVATSPLedgersJournal6 view from CONSUMPTION
P_RU_GtdFromImCD2 view from COMPOSITE
P_RU_GtdFromImCD3 view from COMPOSITE
P_RU_GtdFromImCD4 view from COMPOSITE
P_RU_Invoicepayment1 view from CONSUMPTION
P_RU_InvoicePayment2 view from CONSUMPTION
P_RU_InvoicePayment3 view from CONSUMPTION
P_RU_PurchaseOrderHistoryGRIR1 view from CONSUMPTION
P_RU_SuplrCustAcctgDocItem view from CONSUMPTION
P_RU_SupplierInvoiceAcctgDoc view from COMPOSITE
P_Ru_VatDocExtras view from CONSUMPTION
P_RU_VATExtraInfoWithoutSttg view from CONSUMPTION
P_RU_VATExtraInfoWithoutSttg1 view from COMPOSITE
P_RU_VATInvoiceJournal3 view from CONSUMPTION
P_RU_VATInvoiceJournal4 view from CONSUMPTION
P_RU_VATRETURN10_LINK view from CONSUMPTION
P_RU_VATRETURN10_LINK_AMOUNT view from CONSUMPTION
P_RU_VATRETURN10_LINK_CORREV view from CONSUMPTION
P_RU_VATRETURN10_LINK_FULL view from CONSUMPTION
P_RU_VatRevisionDocument view from CONSUMPTION
P_RU_VatSPLedgerMatlRcptDateMM view from CONSUMPTION
P_SDDocControllingObjectStsT2 view inner BASIC
P_SelectDefault view from COMPOSITE
P_SG_F7ENVELOP view from COMPOSITE
P_US_WhldgTaxCodeThldFields view from COMPOSITE
P_US_WhldgTaxCodeThldFields view union COMPOSITE
R_IN_GSTR3BPaymentItemTP view_entity from TRANSACTIONAL India GSTR3B Payment Item
R_IN_GSTR3BPaymentProposalTP view_entity from TRANSACTIONAL India GSTR3B Payment Proposal
R_IN_GSTRetsSlsRegDocumentTP view_entity from TRANSACTIONAL Document header view parent root view
R_IN_GSTRetsSlsRegTaxItemTP view_entity from TRANSACTIONAL India GSTR Sales Register document root child view TP
R_SalesRegisterSummaryTP view_entity from TRANSACTIONAL Root View for Summary
srf_eco view from Mapped Aggregated Values for CBR France
SRF_HELPER_AT_AUDIT_FILENAME view from SRF_HELPER_AT_AUDIT_FILENAME
SRF_HELPER_AT_BOP_L1 view from SRF helper for AT_BOP_L1
SRF_Helper_Cut_Decimals view from Cuts of decimals from an amount field
SRF_HELPER_DK_VAT_BOXES view from Calculated Values for DK VAT Declaration
Srf_Helper_Gb_Ecsl view from Calculated Values for GB EC Sales List
SRF_HELPER_IT_VAT_BOXES view from Calculate tax boxes
SRF_HELPER_IT_VAT_PARAM_FC view from Parameter FC from Reporting Entities
SRF_HELPER_IT_VAT_PERIOD view from Date to Period and Begin Enddate
SRF_HELPER_IT_VAT_PERIOD view union Date to Period and Begin Enddate
SRF_HELPER_IT_VAT_SYDATE view from Get the Systemdate
SRF_HELPER_IT_VAT_YEAR view from Get the year from reporting date
SRF_Helper_MY_VATDeclaration view from Calculated Values for MY VAT Declaration
SRF_Helper_PH_ENVELOP view from Calculated Values for PH VAT Declaration
SRF_HELPER_SE_ORGNO view from Create SE Orgno with a line middle and skip last figures
SRF_HELPER_SE_VAT_BOXES view from Calculated Values for SE VAT Declaration
SRF_HELPER_SE_VAT_YEARPERIOD view from Get the concat year and period
SRF_Helper_VATRegnStrtWthCntry view from Check if VAT regn starts with ctry/reg.
SRF_IT_VAT_SUM view from Sum of boxes positive or negative
SRF_PT_STP_PHASE view from Calculate SubstitutionDeclaration From ACR Phase
Srf_Rte view from Mapped Aggregated Values for CBR France
SRF_Ru_HelperInvoiceJournal1 view from
SRF_RuHelperPurchaseLedger view from Purchase Ledger Helper View
SRF_RuHelperSalesLedger view from
SRF_RuHelperSPLedger view from Sales Purchase Ledgers Helper View
SRF_RUHELPERVATRETURN view from Helper view for vat return
SRF_RUHelperVATReturn_Link view from
SRF_RUHelperVATReturn1011 view from
Srf_RuSumIntSPLedger view from Add two integer values together
Srf_RuSumSalesLedger view from
Srf_RuSumSPLedger view from Add two values together
SRF_RUVATReturnEAEUHelper1 view from Helper for VAT Return for import from EAEU
SRF_RUVATReturnFormulas_V1_2 view from
SRF_RUVATReturnHelperRelevFlag view from Helper for relevance flag
SRF_RUVATReturnHelperSec1_V1 view from
SRF_RUVATReturnHelperSec2_V1 view from
SRF_RUVATReturnHelperSec3_V1_1 view from
SRF_RUVATReturnHelperSec4D_V1 view from
SRF_RUVATReturnHelperSec4O_V1 view from
SRF_RUVATReturnHelperSec4R_V1 view from
SRF_RUVATReturnHelperSec5_V1 view from
SRF_RUVATReturnHelperSec6D_V1 view from
SRF_RUVATReturnHelperSec6O_V1 view from
SRF_RUVATReturnHelperSec6R_V1 view from
SRF_RUVATReturnHelperSec7_V1 view from
SRF_RUVATReturnHelperSec7T_V1 view from
Srf_UsHelpAmount view from Helper view to convert amount with no decimals
Srf_Ushelpamountcodes view from Amount Codes
Srf_UsHelpAmt view from Helper view to convert amount with no decimals
Srf_UsHelpDirectSales view from Direct Sales Indicator
Srf_UsHelpMailAddr view from Helper view for mailing address
Srf_Ushelpnetincome view from Helper view for Net income
Srf_UsHelpPayeeAddr view from Helper view for payee address
Srf_Ushelppayeeaddrpdf view from Helper View for Payee Address in PDF
Srf_Ushelpregion view from Helper view for Payer region and PayerCountryName
Srf_UsHelpSeqNo view from Sequence Number
Srf_UsHelpTaxNoType view from BP Tax Identification Number Type
Srf_Ushelpzipcode view from Helper view to convert ZIP code
Srf_Ushlp1042pdf view from Helper view for 1042S PDF
Srf_UsHlpPayerAddrPdf view from Helper View for Payee Address in PDF
Srf_Ushlptaxrate view from Helper view for Exemption tax rate
SRF_USTaxForm view from US Tax Form
Srf_ZA_Helper_SumAmts view from Helper View for obtaining the Sum of all Monetary Fields
Srfhelperbetaxitemamt view_entity from Calculated Values for BE Withholding Item
Srfhelperbewhldgcocode view_entity from Calculated values for BE Withholding Item
Srfhelperbewhldgtaxitem view_entity from Calculated Values for BE Withholding Item
Srfhelperfrwhldgtaxitem view_entity from Calculated Values for FR Withholding Item
SRFHelperGBEnvelope view from Calculated Values for GB GovTalk Envelope XML
SRFHelperGBVATDeclaration view from Calculated Values for GB VAT Declaration
SRFHelperSGVATDeclaration view from
SRFHELPERUKWHLDGTAXITEM view from Calculated Values for GB Withholding tax
SrfHelperWwhldgGBEnvelope view from Calculated Values for GB GovTalk Envelope XML

Fields (3)

KeyField CDS FieldsUsed in Views
GroupCurrency DisplayCurrency,MaterialGroupDisplayCurrency,SupplierDisplayCurrency 3
LogicalSystem LogicalSystem 8
sapclient SAPClient 6 
@ClientHandling.algorithm: #SESSION_VARIABLE //Inserted by VDM CDS Suite Plugin

@ObjectModel.representativeKey: 'SAPClient'
@ObjectModel.usageType.dataClass: #CUSTOMIZING
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #M
@AbapCatalog.sqlViewName: 'ISAPCLIENT'
@EndUserText.label: 'SAP Client'
@Analytics : {dataCategory: #DIMENSION, dataExtraction.enabled : true}
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #BASIC

define view I_SAPClient
  as select from t000
  association [0..1] to I_Currency      as _GroupCurrency on $projection.GroupCurrency = _GroupCurrency.Currency
  association [0..1] to I_LogicalSystem as _LogicalSystem on $projection.LogicalSystem = _LogicalSystem.LogicalSystem
{
      // Added for issue 1570150780

      @AbapCatalog.INTERNAL.ISMANDT
  key mandt      as SAPClient,
      mtext      as SAPClientName,
      @ObjectModel.foreignKey.association: '_GroupCurrency'
      mwaer      as GroupCurrency,
      cccategory as SAPClientRole,
      @ObjectModel.foreignKey.association: '_LogicalSystem'
      logsys     as LogicalSystem,
      _GroupCurrency,
      _LogicalSystem
}

Learn More