I_SAPCLIENT
SAP Client
I_SAPCLIENT is a CDS View in S/4HANA. SAP Client. It contains 3 fields. 171 CDS views read from this table.
CDS Views using this table (171)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| 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 | |
| H_HU_StRpDeclTaxAmount | view | from | Convert amt to declarable amount | |
| H_HU_StRpECSLEazon2 | view | from | HU helper view for tag EAZON | |
| H_Hu_Strpecslformid | view | from | HU ECSL: form id tag | |
| H_HU_StRpECSLRoundNeg | view | from | HU ECSL SRF helper rounding negative | |
| H_HU_StRpECSlsListRptgPerd | view | from | HU ECSL reporting period | |
| 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 | Helper view to format timestamp for NL ECSL | |
| I_ControllingArea | view_entity | cross | 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_IN_GSTRetsConsistencyVH | view_entity | union | BASIC | F4 for Consistency Status |
| I_MySessionContext | view_entity | 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_AU_STRPBASCALCULATION | view | from | COMPOSITE | AU BAS Summary Calculation |
| P_AU_StRpBASGLBalSum | view | union_all | CONSUMPTION | AU BAS GL Balance Sum |
| P_ClassicPayingValuation | view | from | BASIC | Paying Valuation Area |
| P_ClientBehavior | view | from | BASIC | Client classification for TDT |
| P_CnsldtnProfitCenterHierVH | view_entity | from | COMPOSITE | Consolidation Profit Center Hierarchy |
| P_CnsldtnProfitCenterHierVH | view_entity | union_all | COMPOSITE | Consolidation Profit Center Hierarchy |
| P_CnsldtnSegmentHierarchyVH | view_entity | from | COMPOSITE | Consolidation Segment Hierarchy |
| P_CnsldtnSegmentHierarchyVH | view_entity | union_all | COMPOSITE | Consolidation Segment Hierarchy |
| P_CnsldtnTemporalElimHierNode | view_entity | union | COMPOSITE | Consolidation Universal Hierarchy Node |
| P_CnsldtnTemporalHierarchyNode | view_entity | union | COMPOSITE | Consolidation Universal Hierarchy Node |
| P_CnsldtnTemporalNodeHier | view_entity | union | COMPOSITE | Consolidation Universal Hierarchy |
| P_Comonavg_Amount | view | inner | COMPOSITE | s |
| P_DefaultCurrencyPair | view | from | COMPOSITE | Default Currency Pairs |
| P_DefaultCurrencyPair | view | union_all | COMPOSITE | Default Currency Pairs |
| 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 | Flow Category to Key Figure with Client |
| P_Fqmtransactiondate | view | inner | BASIC | Transaction Dates |
| P_Fqmtransdate | view | inner | COMPOSITE | Transaction date |
| P_KZ_DATE_HELPER | view | from | COMPOSITE | Helper for sum |
| P_KZ_FILENAME_HELPER | view | from | COMPOSITE | KZ VAT FileName Helper View |
| P_KZ_VAT_HELPER | view | from | COMPOSITE | KZ VAT Helper View |
| P_Ldcmpcurr | view_entity | cross | BASIC | Currencies for ledger an Company Code |
| P_Lfodaterange | view | inner | COMPOSITE | Range of dates |
| P_Lfomonth | view | inner | COMPOSITE | Month range for liquidity forecast |
| P_MaterialStockPeriods | view_entity | union_all | COMPOSITE | Periods for all possible period types |
| P_MatlStkPerdsInMonth | view_entity | from | COMPOSITE | Periods in months |
| P_PH_TaxReturnCalculation | view_entity | from | BASIC | Calculated Values for PH VAT Declaration |
| P_PH_TAXRETURNCALCULATION2 | view_entity | from | BASIC | Calculated Values for PH VAT Declaration |
| P_PL_SAFTReportSequence | view | from | BASIC | SAF-T PL Report Sequence |
| P_PlanData_RT_01 | view | inner | COMPOSITE | Select from ACDOCP; Consolidation Unit; Period and Year |
| P_ProcMonPeriodMonthStart | view | from | COMPOSITE | Process Observer: Month Period Start Date |
| P_ProcMonPeriodMonthStartSyst | view | from | COMPOSITE | Process Observer: Month Period Start Date |
| P_ProcMonPeriodStart | view | from | COMPOSITE | Process Observer: Period Start Time Stamp |
| P_ProcMonPeriodStartSyst | view | from | COMPOSITE | Process Observer: Period Start Time Stamp |
| P_RealTimeRptdFinData_01 | view | inner | COMPOSITE | Select from ACDOCA; Consolidation Unit; Period and Year |
| P_RepFinData_RT_Aggr_02 | view | inner | COMPOSITE | Consolidation Unit; Period and Year |
| P_ReportedFinancialData_RT_01 | view | inner | COMPOSITE | Select from ACDOCA; Consolidation Unit; Period and Year |
| P_RFD_RT_AGGR_simple_02 | view | inner | COMPOSITE | Consolidation Unit; Period and Year |
| P_RU_DSVATSPLedgersJournal3 | view | from | CONSUMPTION | SPLedgers/Journal: External Invoice Determination |
| P_RU_DSVATSPLedgersJournal6 | view | from | CONSUMPTION | SPLedgers/Journal: Exclude submitted documents |
| P_RU_GtdFromImCD2 | view | from | COMPOSITE | FI RU determine GTD from ImCD 2 |
| P_RU_GtdFromImCD3 | view | from | COMPOSITE | FI RU determine GTD from ImCD & Country |
| P_RU_GtdFromImCD4 | view | from | COMPOSITE | FI RU determine GTD from ImCD 2 |
| P_RU_Invoicepayment1 | view | from | CONSUMPTION | Payment Order Number and Date for Invoice (obsoleted) |
| P_RU_InvoicePayment2 | view | from | CONSUMPTION | Payment Order Number and Date for Invoice (obsoleted) |
| P_RU_InvoicePayment3 | view | from | CONSUMPTION | Payment Order Number and Date for Invoice (obsoleted) |
| P_RU_PurchaseOrderHistoryGRIR1 | view | from | CONSUMPTION | FI RU PurchaseOrder History GR/IR-1 |
| P_RU_SuplrCustAcctgDocItem | view | from | CONSUMPTION | Operational Accounting Document Item |
| P_RU_SupplierInvoiceAcctgDoc | view | from | COMPOSITE | FI RU get Material Receipt Date: MM |
| P_Ru_VatDocExtras | view | from | CONSUMPTION | Long Document Texts and Addition Info |
| P_RU_VATExtraInfoWithoutSttg | view | from | CONSUMPTION | Long Document Texts and Addition Info |
| P_RU_VATExtraInfoWithoutSttg1 | view | from | COMPOSITE | Long Document Texts and Addition Info |
| P_RU_VATInvoiceJournal3 | view | from | CONSUMPTION | Invoice Journal: BusinessPartner, Agent-2 |
| P_RU_VATInvoiceJournal4 | view | from | CONSUMPTION | Invoice Journal: Additional data |
| P_RU_VATRETURN10_LINK | view | from | CONSUMPTION | Link between outgoing and incoming invoices for VAT Return |
| P_RU_VATRETURN10_LINK_AMOUNT | view | from | CONSUMPTION | Additional information for defining amounts |
| P_RU_VATRETURN10_LINK_CORREV | view | from | CONSUMPTION | Additional information for defining amounts |
| P_RU_VATRETURN10_LINK_FULL | view | from | CONSUMPTION | Full data required for linking |
| P_RU_VatRevisionDocument | view | from | CONSUMPTION | VAT Invoice Correction and Revision |
| P_RU_VatSPLedgerMatlRcptDateMM | view | from | CONSUMPTION | FI RU get Material Receipt Date: MM |
| P_SDDocControllingObjectStsT2 | view | inner | BASIC | SD Document Controlling Object Status Text |
| P_SelectDefault | view | from | COMPOSITE | Select Default Currency Pairs |
| P_SG_F7ENVELOP | view | from | COMPOSITE | ENVELOPE For F7 |
| P_US_WhldgTaxCodeThldFields | view | from | COMPOSITE | feefwe |
| P_US_WhldgTaxCodeThldFields | view | union | COMPOSITE | feefwe |
| 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 | Sales Purchase Ledgers Helper View (obsoleted) | |
| SRF_RuHelperPurchaseLedger | view | from | Purchase Ledger Helper View | |
| SRF_RuHelperSalesLedger | view | from | Sales Purchase Ledgers Helper View | |
| SRF_RuHelperSPLedger | view | from | Sales Purchase Ledgers Helper View | |
| SRF_RUHELPERVATRETURN | view | from | Helper view for vat return | |
| SRF_RUHelperVATReturn_Link | view | from | VAT Return Section 10 linking | |
| SRF_RUHelperVATReturn1011 | view | from | Helper view for VAT Return sections 10 and 11 | |
| Srf_RuSumIntSPLedger | view | from | Add two integer values together | |
| Srf_RuSumSalesLedger | view | from | Add two values together | |
| 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 Helper View for Formulas Calculation | |
| SRF_RUVATReturnHelperRelevFlag | view | from | Helper for relevance flag | |
| SRF_RUVATReturnHelperSec1_V1 | view | from | SRF Helper View for Section 1 | |
| SRF_RUVATReturnHelperSec2_V1 | view | from | SRF Helper View for Section 2 | |
| SRF_RUVATReturnHelperSec3_V1_1 | view | from | SRF Helper View for Section 3 | |
| SRF_RUVATReturnHelperSec4D_V1 | view | from | SRF Helper View for Section 4 | |
| SRF_RUVATReturnHelperSec4O_V1 | view | from | SRF Helper View for Section 4 | |
| SRF_RUVATReturnHelperSec4R_V1 | view | from | SRF Helper View for Section 4 | |
| SRF_RUVATReturnHelperSec5_V1 | view | from | SRF Helper View for Section 5 | |
| SRF_RUVATReturnHelperSec6D_V1 | view | from | SRF Helper View for Section 6 | |
| SRF_RUVATReturnHelperSec6O_V1 | view | from | SRF Helper View for Section 6 | |
| SRF_RUVATReturnHelperSec6R_V1 | view | from | SRF Helper View for Section 6 | |
| SRF_RUVATReturnHelperSec7_V1 | view | from | SRF Helper View for Section 7 | |
| SRF_RUVATReturnHelperSec7T_V1 | view | from | SRF Helper View for Section 7 | |
| 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 | Calculated Values for SG VAT Declaration | |
| SRFHELPERUKWHLDGTAXITEM | view | from | Calculated Values for GB Withholding tax | |
| SrfHelperWwhldgGBEnvelope | view | from | Calculated Values for GB GovTalk Envelope XML |
Fields (3)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| GroupCurrency | DisplayCurrency,MaterialGroupDisplayCurrency,SupplierDisplayCurrency | 3 | |
| LogicalSystem | LogicalSystem | 8 | |
| sapclient | SAPClient | 5 |
@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
}