I_CUSTSALESPARTNERFUNC

CDS View

Customer Sales Area Partner Function

I_CUSTSALESPARTNERFUNC is a CDS View in S/4HANA. Customer Sales Area Partner Function. It contains 12 fields. 7 CDS views read from this table.

CDS Views using this table (7)

ViewTypeJoinVDMDescription
/SCMTMS/CV_BPOrgRelshp view from BOPF: /SCMTMS/BuPa Org Relationship
A_CustSalesPartnerFunc view from BASIC Sales Partner Functions
C_SupplierDfltReturnToAddr view inner CONSUMPTION Supplier Default Return to Address
I_BPAddlCustPartFuncTP view from TRANSACTIONAL BO view for Additional Partner Functions
I_BPCustPartnerFunctionGov view_entity union_all COMPOSITE BP Customer Partner Function Governance
P_ARCustSalesPartnerFunc view from CONSUMPTION Customer Sales Area Partner Function
P_SuplrReturnToPartnerFunction view union COMPOSITE

Fields (12)

KeyField CDS FieldsUsed in Views
KEY Customer Customer,CustomerForEdit 3
KEY DistributionChannel DistributionChannel,DistributionChannelForEdit 4
KEY Division Division,DivisionForEdit 4
KEY PartnerCounter PartnerCounter,PartnerCounterForEdit 3
KEY PartnerFunction PartnerFunction,PartnerFunctionForEdit 3
KEY SalesOrganization SalesOrganization,SalesOrganizationForEdit 4
BPCustomerNumber BPCustomerNumber 4
ContactPerson ContactPerson 1
CustomerPartnerDescription CustomerPartnerDescription 2
DefaultPartner DefaultPartner 3
PartnerFunctionType PartnerFunctionType 1
PersonnelNumber PersonnelNumber 1

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 Sales Area Partner Function
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_CUSTSALESPARTNERFUNC (
    CUSTOMER,
    DISTRIBUTIONCHANNEL,
    DIVISION,
    PARTNERCOUNTER,
    PARTNERFUNCTION,
    SALESORGANIZATION,
    BPCUSTOMERNUMBER,
    CONTACTPERSON,
    CUSTOMERPARTNERDESCRIPTION,
    DEFAULTPARTNER,
    PARTNERFUNCTIONTYPE,
    PERSONNELNUMBER,
    PRIMARY KEY (CUSTOMER, DISTRIBUTIONCHANNEL, DIVISION, PARTNERCOUNTER, PARTNERFUNCTION, SALESORGANIZATION)
);