I_CUSTOMER_VH

CDS View
30 Fields 6 CDS Views

Customer

I_CUSTOMER_VH is a CDS View in S/4HANA. Customer. It contains 30 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
C_GHOOperatorVH view from CONSUMPTION Operator
C_PCLblConfignShipToPartyVH view_entity from CONSUMPTION Configurations for Labels Ship To Party
I_JP_InvoiceSummaryPayerVH view_entity from COMPOSITE Invoice Summary Payer
I_JP_InvoiceSummaryRecipientVH view_entity from COMPOSITE Invoice Summary Recipient
I_PhysInvtryCustomerVH view_entity inner COMPOSITE Customers in Physical Inventory
I_PhysInvtryStockOwnerVH view_entity inner COMPOSITE Stock Owners in Physical Inventory

Fields (30)

KeyField CDS FieldsUsed in Views
KEY Customer Customer 6
AuthorizationGroup AuthorizationGroup 6
BPAddrCityName BPAddrCityName 1
BPAddrStreetName BPAddrStreetName 1
BPCustomerName BPCustomerName 1
BusinessPartner BusinessPartner 4
BusinessPartnerName1 BusinessPartnerName1 1
BusinessPartnerName2 BusinessPartnerName2 1
BusinessPartnerType BusinessPartnerType 4
CityName CityName 5
Country Country 5
CustomerAccountGroup CustomerAccountGroup 6
CustomerName CustomerName 5
DataController1 DataController1 2
DataController10 DataController10 2
DataController2 DataController2 2
DataController3 DataController3 2
DataController4 DataController4 2
DataController5 DataController5 2
DataController6 DataController6 2
DataController7 DataController7 2
DataController8 DataController8 2
DataController9 DataController9 2
DataControllerSet DataControllerSet 4
IsBusinessPurposeCompleted IsBusinessPurposeCompleted 6
IsCompetitor IsCompetitor 5
OrganizationBPName1 OrganizationBPName1 5
OrganizationBPName2 OrganizationBPName2 5
PostalCode PostalCode 5
StreetName StreetName 5

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_VH (
    CUSTOMER,
    AUTHORIZATIONGROUP,
    BPADDRCITYNAME,
    BPADDRSTREETNAME,
    BPCUSTOMERNAME,
    BUSINESSPARTNER,
    BUSINESSPARTNERNAME1,
    BUSINESSPARTNERNAME2,
    BUSINESSPARTNERTYPE,
    CITYNAME,
    COUNTRY,
    CUSTOMERACCOUNTGROUP,
    CUSTOMERNAME,
    DATACONTROLLER1,
    DATACONTROLLER10,
    DATACONTROLLER2,
    DATACONTROLLER3,
    DATACONTROLLER4,
    DATACONTROLLER5,
    DATACONTROLLER6,
    DATACONTROLLER7,
    DATACONTROLLER8,
    DATACONTROLLER9,
    DATACONTROLLERSET,
    ISBUSINESSPURPOSECOMPLETED,
    ISCOMPETITOR,
    ORGANIZATIONBPNAME1,
    ORGANIZATIONBPNAME2,
    POSTALCODE,
    STREETNAME,
    PRIMARY KEY (CUSTOMER)
);

Learn More