I_CUSTOMER

CDS View
74 Fields 156 CDS Views

Customer

I_CUSTOMER is a CDS View in S/4HANA. Customer. It contains 74 fields. 156 CDS views read from this table.

CDS Views using this table (156)

ViewTypeJoinVDMDescription
A_Customer view from BASIC Customer
A_SeasonSalesPeriod view left_outer COMPOSITE API view for season sd periods
C_AR_StRpVATForm731ItemC view left_outer CONSUMPTION Argentina VAT Form 731
C_AR_StRpVATForm731ItemLogC view left_outer CONSUMPTION Argentina VAT Form 731 with Rptd item log data
C_BadDebtReserveCustomerVH view from CONSUMPTION BDRA- Customer Value Help
C_CashFlowItemCustomer view from CONSUMPTION Customer of Cash Flow Item
C_CN_CustVH view from CONSUMPTION Customer Value Help
C_Competitoridtemp view from CONSUMPTION Competitor ID Value Help
C_CorrespondenceCustomerVH view from CONSUMPTION Correspondence Customer Value Help
C_Customer360 view_entity from CONSUMPTION Customer 360
C_CustomerList_2 view_entity from CONSUMPTION Customer List
C_CustomerOP view from CONSUMPTION Customer
C_CustomerProjectDetails view left_outer CONSUMPTION Customer Project Details
C_Customersuppliercompanycode view from CONSUMPTION Customer/Supplier/Company Code Information
C_CustProjCustomerDetails view from CONSUMPTION Customer Project Customer Details
C_CustProjCustSrvcOrgDetails view from CONSUMPTION Customer Project Service Organisation Details For Customer
C_DbtflAcctsValnCustomerVH view from CONSUMPTION DAV - Customer Value Help
C_DspPaytCardCustomerCard view from CONSUMPTION Payment Card - Customer Contact Card
C_EntProjCustomerContactCard view_entity from CONSUMPTION Enterprise Project Customer Details
C_ESJICustomerQuery view from CONSUMPTION Customer
C_GRC_CustomerChangeLog view inner CONSUMPTION Customer change log
C_InspLotCustValHelp view from CONSUMPTION Customer Value Help
C_JITBusinessPartnerVH view_entity from CONSUMPTION Business Partner
C_JournalEntryCustomerCard view from CONSUMPTION Journal Entry Customer Contact Card
C_LCMContactsOrgValueHelp view from CONSUMPTION Value Help for Contact Org. of BP
C_MrkdDeltnNoPostgBlkCust view from CONSUMPTION Customer marked for delete without block
C_NoCompanyCodeCustomer view from CONSUMPTION Customer with no company code assignment
C_PermitToWorkPartnerValueHelp view inner CONSUMPTION PTW Profile specific BusinessPartnerData
C_ProjectBillingCustomerCard view from CONSUMPTION Project Billing - Customer Contact Card
C_PurgCustomerBPShipToAddrVH view inner CONSUMPTION Customer Ship to Addresses
C_PurOrdMaintainCustValHelp view from CONSUMPTION PO Maintenance: Value Help for Customer
C_Q2CCustomerQuickView view_entity from CONSUMPTION Customer
C_QltyCertCustomerVH view from CONSUMPTION Quality Certificate Customer
C_RevnVarCustVH view from CONSUMPTION Value help for Customer
C_RO_SAFTCustomer view inner CONSUMPTION Customer Master Data for RO SAFT
C_RO_StRpDomesticSlsPurListC view left_outer CONSUMPTION Romania Domestic Sales and Purchase List - Cube
C_RO_StRpTaxItemWithEUTaxClfnC view left_outer CONSUMPTION EU Sales Tax Item View for RO
C_SalesInsightCustomerVH view from CONSUMPTION Sales Insight: Customer Value Help
C_SalesOrderByMonth view left_outer CONSUMPTION Sales Order by Month
C_SDDocumentCustomerVH view inner CONSUMPTION SD Document Ship to Party
C_SegmtnSoldToPartyVH_F9070 view_entity from CONSUMPTION Sold To Party
C_ShipToPartyValueHelp view from CONSUMPTION Ship to Party
C_SoldToSalesAreaVH view from CONSUMPTION Sold-to Party
C_SoldToValueHelp view from CONSUMPTION Sold-to Party
C_SupDmndOvwTotDmndQuery view left_outer CONSUMPTION Query View for Total Demand
C_SupDmndTotSlsOrdQuery view left_outer CONSUMPTION Query View for Total Demand
C_SupDmndTotSTOQuery view left_outer CONSUMPTION Query View for Total Demand
C_SustCustomerAddressDEX view_entity from CONSUMPTION Customer Address data extractor
C_VMSVehicleB2CSoldToPartyVH view_entity from CONSUMPTION Sold To Party Search Help
C_VMSVehSoldToPartyQuickView view_entity from CONSUMPTION Sold to party card
C_WarrantyCustomerValueHelp view from CONSUMPTION Warranty Customer
CIC_SOURCE_OF_SUPPLY_JOIN view left_outer Source of Supply for valid partners
ESH_N_CUSTOMERS_T view from
FAC_CUSTOMERVH view from Value help for customer
FAC_DART_Z3_C_BP_ADDRESS view from Business Partner Address for Customer
FAC_DART_Z3_Customer view left_outer Customer Master Data
FARMLVD_APAR_ACCDOC view left_outer Cleared Receivable Item Information
FARMLVD_APAR_ACCDOC_AUTH view left_outer Rec Item Auth Check Helper View
FARMLVD_OPEN_PAYMTADV view left_outer Open Payment Advice Information
FARMLVD_PAYMTADV view left_outer Payment Advice Information
I_AR_StRpTaxItem view left_outer COMPOSITE Argentina VAT Tax Line Item Calculation
I_BadDebtReserveCustomer view from COMPOSITE Bad Debt Reserve Adequacy Customer
I_BalanceAuditTrail view left_outer COMPOSITE Line Items for Balance Audit Trail
I_BPAdditionalCustomerTP view inner TRANSACTIONAL BO view for Additional Customers of BP
I_BPAddlCustEmailAddressTP view inner TRANSACTIONAL BO view for email for MLTAS customers
I_BPAddlCustFaxNumberTP view inner TRANSACTIONAL BO view for Fax Numb of MLTAS Customers
I_BPAddlCustMblPhNumberTP view inner TRANSACTIONAL BO view for Mob Ph of MLTAS Customers
I_BPAddlCustTelNmbrTP view inner TRANSACTIONAL BO view for Tel nos of MLTAS Customers
I_BPAddlCustWebsiteURLTP view inner TRANSACTIONAL BO view for Website URL of MLTAS Customers
I_BPCustomerGov view_entity union_all COMPOSITE BP Customer Data Governance
I_BPCustomerMultiAddrVH view inner COMPOSITE Customers by Multiple Addresses
I_BR_NFPartner_VendCust view union COMPOSITE Brazil Nota Fiscal Customer and Supplier
I_CN_GoldenTaxCustomerTypeDetn view from COMPOSITE Golden Tax Customer Type Determination
I_CnsldtnMasterData view union_all COMPOSITE Consolidation - Combined Master Data
I_CO_BPRelationshipRole view_entity inner COMPOSITE
I_CollsCustomerVH view from COMPOSITE Customer VH
I_CommodityCustomer view from BASIC Customer Master for Commodities
I_Customer_VH view from BASIC Customer
I_CustomerChangeLog view inner COMPOSITE Customer change log
I_DbtflAcctsValnCustomer view from COMPOSITE DAV Customer Information
I_EmlTmplCustSuplrCompanyCode view from COMPOSITE Email Template Data Provider
I_EngmntProjCustInfo view from BASIC Billg Info for Engmnt Project Customer
I_EngmntProjCustomer view from BASIC Engagement Project Customer
I_IN_StRpGSTRet view left_outer COMPOSITE Tax Item Details for GST Returns
I_LU_SAFTGenLedgerDocumentBP view_entity inner COMPOSITE Business Partner Document for SAFT LU
I_MaterialSampleDetails view left_outer COMPOSITE CDS View for Material Sample Details
I_MX_BPRelationshipRole view_entity inner COMPOSITE Provides Business Partners Roles
I_NO_SAFTCustomerMasterData view_entity inner COMPOSITE Master data of customers for SAFT
I_NO_SAFTCustomersInPeriod view_entity inner COMPOSITE List of all customers in report period
I_PartnerCompanyCustomerAuthzn view from BASIC Customer Authorization in Company
I_PH_SuplrCustJournalCube view left_outer COMPOSITE PH CAS Supplier Customer Journal Cube
I_ProjCustSrvcOrgDetails view from COMPOSITE Customer Service Organisation Details
I_PT_SAFTBillgAcctgCustomer view_entity inner COMPOSITE Customer from Accounting Document
I_PT_SAFTBillgPaytCust view_entity inner COMPOSITE Customer from Payment Document
I_PT_SAFTCustomerSalesInvoice view_entity inner COMPOSITE Customer from Billing Document
I_PT_SAFTDeliveryCustDetail view inner COMPOSITE Details of Portugal SAFT Customer
I_PT_SAFTSlsInvcBillgCust view_entity inner COMPOSITE Customer from Billing Document
I_SAFTAccountingCustomer view inner COMPOSITE SAF-T Regular Accounting Customers
I_SAFTBillingCustomer view inner COMPOSITE SAF-T Regular Billing Customers
I_SAFTDeliveryCustomer view inner BASIC SAF-T Regular Billing Customers
I_SAFTSettlementMgmtCustomer view inner COMPOSITE SAF-T Settlement Management Customer
I_VisualNominations view left_outer COMPOSITE Visual Nominations
I_VisualSimulation view left_outer COMPOSITE IPW Simulation in Visualization
P_AR_BPRelationshipRole view_entity inner COMPOSITE
P_AR_CustomerReceivableTotal view inner CONSUMPTION
P_Arbsitmopenitem view left_outer COMPOSITE
P_ARCustomerUnion view from CONSUMPTION AR Customer Union
P_ARCustomerUnion view union_all CONSUMPTION AR Customer Union
P_ARLineItemMixedAccount view inner BASIC
P_BG_SAFTCustomer view_entity inner CONSUMPTION
P_BPPartnerFunctionNumber view from COMPOSITE
P_CN_CADECustomer view inner CONSUMPTION
P_CnsldtnCustomer view from COMPOSITE
P_CnsldtnCustomerT view from COMPOSITE
P_CO_DIANMinXrefCustomer view from CONSUMPTION All Formats - Customer XREF
P_CollsAcctColl view_entity inner COMPOSITE Collections Account - FI
P_CreditLimitUtilizationBseg1 view inner COMPOSITE
P_CrExp view inner COMPOSITE
P_CrExpFi view inner COMPOSITE
P_CrExpFiMain view inner COMPOSITE
P_CustomerAsSupplier view from COMPOSITE
P_CustomerAuthorizationGroup view from COMPOSITE
P_CustomerAuthznInCompany view from BASIC
P_CustomerByExternalID view from CONSUMPTION
P_CustomerSupplierSH view_entity from COMPOSITE
P_CustomerWithPaymentAdvice view from CONSUMPTION Customers With Payment Advices
P_DRFEWMCustomer view from BASIC
P_EngmntProjReviewData view left_outer COMPOSITE
P_Fiarcn_Bp_Cust view from CONSUMPTION Customer and Business Partner
P_I_Customer_F2187 view from CONSUMPTION P view to get properties for Cust360
P_IN_CUSTOMERGSTHEALTHCHECK view_entity inner COMPOSITE
P_IN_CustomerTaxNumber view_entity from COMPOSITE
P_IsCustomerEUMember view_entity from CONSUMPTION
P_LU_SAFTJournalItemBP view inner COMPOSITE
P_NO_SAFTJournalCustSup view inner COMPOSITE
P_NO_SAFTJournalCustSupMD view inner COMPOSITE SAF-T Norway Journal Item BP Master Data
P_OffsettingAccount view union_all COMPOSITE
P_OffsettingAccountVH view union_all COMPOSITE
P_PaytReceiptCustomerVH view inner COMPOSITE
P_ProdAllocPlngBusPartners view from COMPOSITE
P_PT_SAFTTAXLAND view inner COMPOSITE
P_RO_SAFTCustomer view inner CONSUMPTION Customer Data for RO SAFT
P_RU_CustomerData1 view from COMPOSITE
P_SI4_TrainingData10 view left_outer COMPOSITE
P_SPP_PredictionData06 view left_outer COMPOSITE
P_SPP_TrainingData06 view left_outer COMPOSITE
P_StRpBillingDocumentItem view left_outer COMPOSITE
P_StRpSalesInvoiceItem view inner CONSUMPTION Private View for Sales Invoice List
P_TW_TaxItem view left_outer COMPOSITE
P_WLF_CDS_KNA1_BG view from BASIC
SHSM_M_CMKU view left_outer Claims Relating to a Customer
SHSM_SHP_VIEW_GDSI view inner CDS-based Value Help Selection Method SHP_VIEW_GDSI
SHSM_SHP_VIEW_GDSIM view inner CDS-based Value Help Selection Method SHP_VIEW_GDSIM
SHSM_SHP_VIEW_LIKP_OUT view inner CDS-based Value Help Selection Method SHSM_SHP_VIEW_LIKP_OUT
SHSM_SHP_VIEW_PICK view inner CDS-based Value Help Selection Method SHP_VIEW_PICK
SHSM_V_LINF_M view left_outer Delivery info for the Project System

Fields (74)

KeyField CDS FieldsUsed in Views
KEY AddressID AddressID 16
KEY Customer Account,BusinessPartner,ContactCardID,Customer,customer_account,CustomerForEdit,CustomerNum,Partner 54
_AddressRepresentation _Addr,_AddressRepresentation 4
_CustomerAccountGroupText _CustomerAccountGroupText 1
_CustomerClassification _CustomerClassification 3
_CustomerClassificationText _CustomerClassificationText 1
_CustomerCompany _CustomerCompany 2
_CustomerToBusinessPartner _CustomerToBusinessPartner 1
_StandardAddress _StandardAddress 3
AlternativePayeeIsAllowed AlternativePayeeIsAllowed 3
AlternativePayerAccount AlternativePayerAccount 3
AuthorizationGroup AuthorizationGroup,BEGRU,customer_begru,CustomerBasicAuthorizationGrp 47
BillingIsBlockedForCustomer BillingIsBlockedForCustomer 4
BPAddrCityName BPAddrCityName 2
BPAddrStreetName BPAddrStreetName 1
BPCustomerFullName BusinessPartnerFullName 1
BPCustomerName BPCustomerName 5
BusinessPartner BusinessPartner 1
BusinessPartnerName1 BusinessPartnerName1,CustomerName 8
BusinessPartnerName2 BusinessPartnerName2 7
BusinessPartnerUUID BusinessPartnerUUID 1
CityName CityName 17
Country Country,CustomerCountry,ShipToPartyCountry 18
CreatedByUser CreatedByUser 7
CreationDate CreationDate 5
CustomerAccountGroup CustomerAccountGroup,ReferenceAccountGroup 39
CustomerClassification CustomerClassification 8
CustomerCorporateGroup CustomerCorporateGroup 1
CustomerFullName CustomerFullName,FullName,PartnerFullName 10
CustomerName customer_name,CustomerName,Name,SoldToPartyName 33
DataController1 DataController1 26
DataController10 DataController10 26
DataController2 DataController2 26
DataController3 DataController3 26
DataController4 DataController4 26
DataController5 DataController5 26
DataController6 DataController6 26
DataController7 DataController7 26
DataController8 DataController8 26
DataController9 DataController9 26
DataControllerSet DataControllerSet 28
DataMediumExchangeIndicator DataMediumExchangeIndicator 1
DeletionIndicator DeletionIndicator 4
DeliveryDateTypeRule DeliveryDateTypeRule 1
DeliveryIsBlocked DeliveryIsBlocked 5
FaxNumber FaxNumber 1
Industry Industry 4
IsBusinessPurposeCompleted IsBusinessPurposeCompleted 25
IsCompetitor IsCompetitor 1
IsOneTimeAccount IsOneTimeAccount 19
Language Language 1
OrderIsBlockedForCustomer OrderIsBlockedForCustomer 4
OrganizationBPName1 CustomerName,OrganizationBPName1 16
OrganizationBPName2 OrganizationBPName2 15
PaymentReason PaymentReason 1
PostalCode PostalCode 12
PostingIsBlocked PostingIsBlocked 6
Region Region 2
ResponsibleType ResponsibleType 3
SortField SortField 1
StreetName StreetName 6
Supplier Supplier 4
TaxJurisdiction TaxJurisdiction 2
TaxNumber1 TaxNumber1 13
TaxNumber2 TaxNumber2 11
TaxNumber3 TaxNumber3 2
TaxNumber4 TaxNumber4 2
TaxNumber5 TaxNumber5 2
TaxNumberType TaxNumberType 4
TelephoneNumber1 TelephoneNumber1 2
TelephoneNumber2 TelephoneNumber2 1
TradingPartner TradingPartner 1
VATLiability VATLiability 2
VATRegistration CustomerVATRegistration,VATRegistration 10

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Customer
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_CUSTOMER (
    ADDRESSID,
    CUSTOMER,
    _ADDRESSREPRESENTATION,
    _CUSTOMERACCOUNTGROUPTEXT,
    _CUSTOMERCLASSIFICATION,
    _CUSTOMERCLASSIFICATIONTEXT,
    _CUSTOMERCOMPANY,
    _CUSTOMERTOBUSINESSPARTNER,
    _STANDARDADDRESS,
    ALTERNATIVEPAYEEISALLOWED,
    ALTERNATIVEPAYERACCOUNT,
    AUTHORIZATIONGROUP,
    BILLINGISBLOCKEDFORCUSTOMER,
    BPADDRCITYNAME,
    BPADDRSTREETNAME,
    BPCUSTOMERFULLNAME,
    BPCUSTOMERNAME,
    BUSINESSPARTNER,
    BUSINESSPARTNERNAME1,
    BUSINESSPARTNERNAME2,
    BUSINESSPARTNERUUID,
    CITYNAME,
    COUNTRY,
    CREATEDBYUSER,
    CREATIONDATE,
    CUSTOMERACCOUNTGROUP,
    CUSTOMERCLASSIFICATION,
    CUSTOMERCORPORATEGROUP,
    CUSTOMERFULLNAME,
    CUSTOMERNAME,
    DATACONTROLLER1,
    DATACONTROLLER10,
    DATACONTROLLER2,
    DATACONTROLLER3,
    DATACONTROLLER4,
    DATACONTROLLER5,
    DATACONTROLLER6,
    DATACONTROLLER7,
    DATACONTROLLER8,
    DATACONTROLLER9,
    DATACONTROLLERSET,
    DATAMEDIUMEXCHANGEINDICATOR,
    DELETIONINDICATOR,
    DELIVERYDATETYPERULE,
    DELIVERYISBLOCKED,
    FAXNUMBER,
    INDUSTRY,
    ISBUSINESSPURPOSECOMPLETED,
    ISCOMPETITOR,
    ISONETIMEACCOUNT,
    LANGUAGE,
    ORDERISBLOCKEDFORCUSTOMER,
    ORGANIZATIONBPNAME1,
    ORGANIZATIONBPNAME2,
    PAYMENTREASON,
    POSTALCODE,
    POSTINGISBLOCKED,
    REGION,
    RESPONSIBLETYPE,
    SORTFIELD,
    STREETNAME,
    SUPPLIER,
    TAXJURISDICTION,
    TAXNUMBER1,
    TAXNUMBER2,
    TAXNUMBER3,
    TAXNUMBER4,
    TAXNUMBER5,
    TAXNUMBERTYPE,
    TELEPHONENUMBER1,
    TELEPHONENUMBER2,
    TRADINGPARTNER,
    VATLIABILITY,
    VATREGISTRATION,
    PRIMARY KEY (ADDRESSID, CUSTOMER)
);

Learn More