I_BUSINESSPARTNERSALESAREATP

CDS View
66 Fields 1 CDS Views

Association View For BP Sales Area

I_BUSINESSPARTNERSALESAREATP is a CDS View in S/4HANA. Association View For BP Sales Area. It contains 66 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_BusinessPartnerSalesArea view from CONSUMPTION Consumption view for customer sales area

Fields (66)

KeyField CDS FieldsUsed in Views
KEY BusinessPartner BusinessPartner 1
KEY DistributionChannel DistributionChannel 1
KEY Division Division 1
KEY SalesOrganization SalesOrganization 1
AccountByCustomer AccountByCustomer 1
AdditionalCustomerGroup1 AdditionalCustomerGroup1 1
AdditionalCustomerGroup2 AdditionalCustomerGroup2 1
AdditionalCustomerGroup3 AdditionalCustomerGroup3 1
AdditionalCustomerGroup4 AdditionalCustomerGroup4 1
AdditionalCustomerGroup5 AdditionalCustomerGroup5 1
AuthorizationGroup AuthorizationGroup 1
BillingIsBlockedForCustomer BillingIsBlockedForCustomer 1
BusinessPartnerForEdit BusinessPartnerForEdit 1
BusinessPartnerUUID BusinessPartnerUUID 1
CompleteDeliveryIsDefined CompleteDeliveryIsDefined 1
CreditControlArea CreditControlArea 1
Currency Currency 1
Customer Customer 1
CustomerABCClassification CustomerABCClassification 1
CustomerAccountAssignmentGroup CustomerAccountAssignmentGroup 1
CustomerGroup CustomerGroup 1
CustomerIsRebateRelevant CustomerIsRebateRelevant 1
CustomerPaymentTerms CustomerPaymentTerms 1
CustomerPriceGroup CustomerPriceGroup 1
CustomerPricingProcedure CustomerPricingProcedure 1
CustomerStatisticsGroup CustomerStatisticsGroup 1
CustProdProposalProcedure CustProdProposalProcedure 1
DeliveryIsBlockedForCustomer DeliveryIsBlockedForCustomer 1
DeliveryPriority DeliveryPriority 1
DistributionChannelForEdit DistributionChannelForEdit 1
DivisionForEdit DivisionForEdit 1
ExchangeRateType ExchangeRateType 1
IncotermsClassification IncotermsClassification 1
IncotermsDvtgLocIdentifier IncotermsDvtgLocIdentifier 1
IncotermsLocation1 IncotermsLocation1 1
IncotermsLocation1Identifier IncotermsLocation1Identifier 1
IncotermsLocation2 IncotermsLocation2 1
IncotermsLocation2Identifier IncotermsLocation2Identifier 1
IncotermsSupChnDvtgLocAddlUUID IncotermsSupChnDvtgLocAddlUUID 1
IncotermsTransferLocation IncotermsTransferLocation 1
IncotermsVersion IncotermsVersion 1
InspSbstHasNoTimeOrQuantity InspSbstHasNoTimeOrQuantity 1
InvoiceDate InvoiceDate 1
InvoiceListSchedule InvoiceListSchedule 1
ItemOrderProbabilityInPercent ItemOrderProbabilityInPercent 1
ManualInvoiceMaintIsRelevant ManualInvoiceMaintIsRelevant 1
MaxNmbrOfPartialDelivery MaxNmbrOfPartialDelivery 1
OrderCombinationIsAllowed OrderCombinationIsAllowed 1
OrderIsBlockedForCustomer OrderIsBlockedForCustomer 1
OverdelivTolrtdLmtRatioInPct OverdelivTolrtdLmtRatioInPct 1
PartialDeliveryIsAllowed PartialDeliveryIsAllowed 1
PaymentGuaranteeProcedure PaymentGuaranteeProcedure 1
PriceListType PriceListType 1
ProductUnitGroup ProductUnitGroup 1
SalesDistrict SalesDistrict 1
SalesGroup SalesGroup 1
SalesItemProposal SalesItemProposal 1
SalesOffice SalesOffice 1
SalesOrganizationForEdit SalesOrganizationForEdit 1
SalesOrganizationName SalesOrganizationName 1
ShippingCondition ShippingCondition 1
SlsDocIsRlvtForProofOfDeliv SlsDocIsRlvtForProofOfDeliv 1
SlsUnlmtdOvrdelivIsAllwd SlsUnlmtdOvrdelivIsAllwd 1
SuplrIsRlvtForSettlmtMgmt SuplrIsRlvtForSettlmtMgmt 1
SupplyingPlant SupplyingPlant 1
UnderdelivTolrtdLmtRatioInPct UnderdelivTolrtdLmtRatioInPct 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.

-- Association View For BP Sales Area
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_BUSINESSPARTNERSALESAREATP (
    BUSINESSPARTNER,
    DISTRIBUTIONCHANNEL,
    DIVISION,
    SALESORGANIZATION,
    ACCOUNTBYCUSTOMER,
    ADDITIONALCUSTOMERGROUP1,
    ADDITIONALCUSTOMERGROUP2,
    ADDITIONALCUSTOMERGROUP3,
    ADDITIONALCUSTOMERGROUP4,
    ADDITIONALCUSTOMERGROUP5,
    AUTHORIZATIONGROUP,
    BILLINGISBLOCKEDFORCUSTOMER,
    BUSINESSPARTNERFOREDIT,
    BUSINESSPARTNERUUID,
    COMPLETEDELIVERYISDEFINED,
    CREDITCONTROLAREA,
    CURRENCY,
    CUSTOMER,
    CUSTOMERABCCLASSIFICATION,
    CUSTOMERACCOUNTASSIGNMENTGROUP,
    CUSTOMERGROUP,
    CUSTOMERISREBATERELEVANT,
    CUSTOMERPAYMENTTERMS,
    CUSTOMERPRICEGROUP,
    CUSTOMERPRICINGPROCEDURE,
    CUSTOMERSTATISTICSGROUP,
    CUSTPRODPROPOSALPROCEDURE,
    DELIVERYISBLOCKEDFORCUSTOMER,
    DELIVERYPRIORITY,
    DISTRIBUTIONCHANNELFOREDIT,
    DIVISIONFOREDIT,
    EXCHANGERATETYPE,
    INCOTERMSCLASSIFICATION,
    INCOTERMSDVTGLOCIDENTIFIER,
    INCOTERMSLOCATION1,
    INCOTERMSLOCATION1IDENTIFIER,
    INCOTERMSLOCATION2,
    INCOTERMSLOCATION2IDENTIFIER,
    INCOTERMSSUPCHNDVTGLOCADDLUUID,
    INCOTERMSTRANSFERLOCATION,
    INCOTERMSVERSION,
    INSPSBSTHASNOTIMEORQUANTITY,
    INVOICEDATE,
    INVOICELISTSCHEDULE,
    ITEMORDERPROBABILITYINPERCENT,
    MANUALINVOICEMAINTISRELEVANT,
    MAXNMBROFPARTIALDELIVERY,
    ORDERCOMBINATIONISALLOWED,
    ORDERISBLOCKEDFORCUSTOMER,
    OVERDELIVTOLRTDLMTRATIOINPCT,
    PARTIALDELIVERYISALLOWED,
    PAYMENTGUARANTEEPROCEDURE,
    PRICELISTTYPE,
    PRODUCTUNITGROUP,
    SALESDISTRICT,
    SALESGROUP,
    SALESITEMPROPOSAL,
    SALESOFFICE,
    SALESORGANIZATIONFOREDIT,
    SALESORGANIZATIONNAME,
    SHIPPINGCONDITION,
    SLSDOCISRLVTFORPROOFOFDELIV,
    SLSUNLMTDOVRDELIVISALLWD,
    SUPLRISRLVTFORSETTLMTMGMT,
    SUPPLYINGPLANT,
    UNDERDELIVTOLRTDLMTRATIOINPCT,
    PRIMARY KEY (BUSINESSPARTNER, DISTRIBUTIONCHANNEL, DIVISION, SALESORGANIZATION)
);

Learn More