The BPADDCSA_D table in SAP ERP or S/4HANA stores I_BUSINESSPARTNERTP I_BPADDLCUSTSALESAREATP data. There are total 58 fields in BPADDCSA_D table. The I_BUSINESSPARTNERTP I_BPADDLCUSTSALESAREATP table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of BPADDCSA_D table. It is in VDM Master Data BP (VDM_MD_BP) ABAP package and is part of the Business Partners (LO-MD-BP) module.
SAP BPADDCSA_D Table Fields
Following is the list of fields that are available in SAP BPADDCSA_D table. The primary key fields of the table are MANDT (Client), DRAFTUUID (UUID serving as key (parent key, root key)).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT (3) | |
| DRAFTUUID | UUID serving as key (parent key, root key) | /BOBF/UUID | RAW (16) | |
| PARENTDRAFTUUID | UUID serving as key (parent key, root key) | /BOBF/UUID | RAW (16) | |
| ROOTDRAFTUUID | UUID serving as key (parent key, root key) | /BOBF/UUID | RAW (16) | |
| BUSINESSPARTNER | Business Partner Number | BU_PARTNER | CHAR (10) | |
| CUSTOMER | Customer Number | KUNNR | CHAR (10) | |
| SALESORGANIZATION | Sales Organization | VKORG | CHAR (4) | |
| DISTRIBUTIONCHANNEL | Distribution Channel | VTWEG | CHAR (2) | |
| DIVISION | Division | SPART | CHAR (2) | |
| BUSINESSPARTNERFOREDIT | Business Partner Number | BU_PARTNER | CHAR (10) | |
| SALESORGANIZATIONFOREDIT | Sales Organization | VKORG | CHAR (4) | |
| DISTRIBUTIONCHANNELFOREDIT | Distribution Channel | VTWEG | CHAR (2) | |
| DIVISIONFOREDIT | Division | SPART | CHAR (2) | |
| CUSTOMERFOREDIT | Customer Number | KUNNR | CHAR (10) | |
| CUSTOMERGROUP | Customer Group | KDGRP | CHAR (2) | |
| SALESOFFICE | Sales office | VKBUR | CHAR (4) | |
| SALESGROUP | Sales group | VKGRP | CHAR (3) | |
| ACCOUNTBYCUSTOMER | Shipper’s (Our) Account Number at the Customer or Vendor | EIKTO | CHAR (12) | |
| CUSTOMERABCCLASSIFICATION | Customer classification (ABC analysis) | KLABC | CHAR (2) | |
| CURRENCY | Currency | WAERS_V02D | CUKY (5) | |
| CUSTOMERPRICEGROUP | Customer Price Group | KONDA | CHAR (2) | |
| CUSTOMERPRICINGPROCEDURE | Customer Classification for Pricing Procedure Determination | KALKS | CHAR (2) | |
| ORDERCOMBINATIONISALLOWED | Order Combination Indicator | KZAZU_D | CHAR (1) | |
| SHIPPINGCONDITION | Shipping Conditions | VSBED | CHAR (2) | |
| SUPPLYINGPLANT | Delivering Plant (Own or External) | DWERK_EXT | CHAR (4) | |
| DELIVERYISBLOCKEDFORCUSTOMER | Customer delivery block (sales area) | LIFSD_V | CHAR (2) | |
| BILLINGISBLOCKEDFORCUSTOMER | Billing block for customer (sales and distribution) | FAKSD_V | CHAR (2) | |
| COMPLETEDELIVERYISDEFINED | Complete Delivery Defined for Each Sales Order? | AUTLF | CHAR (1) | |
| PARTIALDELIVERYISALLOWED | Partial delivery at item level | KZTLF | CHAR (1) | |
| INVOICEDATE | Invoice Dates (Calendar Identification) | PERFK | CHAR (2) | |
| INCOTERMSCLASSIFICATION | Incoterms (Part 1) | INCO1 | CHAR (3) | |
| INCOTERMSTRANSFERLOCATION | Incoterms (Part 2) | INCO2 | CHAR (28) | |
| INCOTERMSVERSION | Incoterms Version | INCOV | CHAR (4) | |
| INCOTERMSLOCATION1 | Incoterms Location 1 | INCO2_L | CHAR (70) | |
| INCOTERMSLOCATION2 | Incoterms Location 2 | INCO3_L | CHAR (70) | |
| CUSTOMERPAYMENTTERMS | Terms of payment key | DZTERM | CHAR (4) | |
| CUSTOMERACCOUNTASSIGNMENTGROUP | Account Assignment Group for this customer | KTGRD | CHAR (2) | |
| ORDERISBLOCKEDFORCUSTOMER | Customer order block (sales area) | AUFSD_V | CHAR (2) | |
| PRICELISTTYPE | Price List Type | PLTYP | CHAR (2) | |
| SALESDISTRICT | Sales District | BZIRK | CHAR (6) | |
| INVOICELISTSCHEDULE | Invoice List Schedule (calendar identification) | PERRL | CHAR (2) | |
| EXCHANGERATETYPE | Exchange Rate Type | KURST | CHAR (4) | |
| AUTHORIZATIONGROUP | Authorization Group | BEGRU | CHAR (4) | |
| ITEMORDERPROBABILITYINPERCENT | Order Probability of the Item | AWAHR | NUMC (3) | |
| ADDITIONALCUSTOMERGROUP1 | Customer group 1 | KVGR1 | CHAR (3) | |
| ADDITIONALCUSTOMERGROUP2 | Customer group 2 | KVGR2 | CHAR (3) | |
| ADDITIONALCUSTOMERGROUP3 | Customer group 3 | KVGR3 | CHAR (3) | |
| ADDITIONALCUSTOMERGROUP4 | Customer group 4 | KVGR4 | CHAR (3) | |
| ADDITIONALCUSTOMERGROUP5 | Customer group 5 | KVGR5 | CHAR (3) | |
| PAYMENTGUARANTEEPROCEDURE | Customer payment guarantee procedure | KABSSCH_CM | CHAR (4) | |
| SALESITEMPROPOSAL | Item proposal | VSORT | CHAR (10) | |
| CUSTPRODPROPOSALPROCEDURE | Customer procedure for product proposal | PVKSM | CHAR (2) | |
| HASACTIVEENTITY | Draft – Indicator – Has active document | SDRAFT_HAS_ACTIVE | CHAR (1) | |
| DRAFTENTITYCREATIONDATETIME | Draft Created On | SDRAFT_CREATED_AT | DEC (21) | |
| DRAFTENTITYLASTCHANGEDATETIME | Draft Last Changed On | SDRAFT_LAST_CHANGED_AT | DEC (21) | |
| DRAFTADMINISTRATIVEDATAUUID | Technical ID for the Administrative Data of a Draft Document | SDRAFT_ADMIN_UUID | RAW (16) | |
| DRAFTENTITYCONSISTENCYSTATUS | Draft Consistency Status | SDRAFT_CONSISTENCY_STATUS | CHAR (1) | |
| DRAFTENTITYOPERATIONCODE | Draft – Operation Code | SDRAFT_OPERATION_CODE | CHAR (1) |
