CUSTOMER_D - I_BUSINESSPARTNERTP I_BUSINESSPARTNERCUSTOMERTP
I_BUSINESSPARTNERTP I_BUSINESSPARTNERCUSTOMERTP information is stored in SAP table CUSTOMER_D.
It is part of development package VDM_MD_BP in software component LO-MD-BP. This development package consists of objects that can be grouped under "VDM Master Data BP".
It is part of development package VDM_MD_BP in software component LO-MD-BP. This development package consists of objects that can be grouped under "VDM Master Data BP".
Fields for table CUSTOMER_D
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 6 | |
| DRAFTUUID | UUID serving as key (parent key, root key) | X | /BOBF/UUID | RAW | 16 | |
| PARENTDRAFTUUID | UUID serving as key (parent key, root key) | /BOBF/UUID | RAW | 16 | ||
| BUSINESSPARTNER | Business Partner Number | BU_PARTNER | CHAR | 20 | ||
| CUSTOMER | Customer Number | KUNNR | CHAR | 20 | ||
| BUSINESSPARTNERFOREDIT | Business Partner Number | BU_PARTNER | CHAR | 20 | ||
| BUSINESSPARTNERUUID | Business Partner GUID | BU_PARTNER_GUID | RAW | 16 | ||
| CUSTOMERACCOUNTGROUP | Customer Account Group | KTOKD | CHAR | 8 | ||
| ALTERNATIVEPAYERACCOUNT | Account Number of an Alternative Payer | KNRZA | CHAR | 20 | ||
| DATAMEDIUMEXCHANGEINDICATOR | Report key for data medium exchange | DTAMS | CHAR | 2 | ||
| SUPPLIER | Account Number of Supplier | LIFNR | CHAR | 20 | ||
| CUSTOMERCLASSIFICATION | Customer Classification | KUKLA | CHAR | 4 | ||
| VATLIABILITY | Liable for VAT | STKZU | CHAR | 2 | ||
| POSTINGISBLOCKED | Central posting block | SPERB_X | CHAR | 2 | ||
| DELIVERYISBLOCKED | Central delivery block for the customer | LIFSD_X | CHAR | 4 | ||
| BILLINGISBLOCKEDFORCUSTOMER | Central billing block for customer | FAKSD_X | CHAR | 4 | ||
| ORDERISBLOCKEDFORCUSTOMER | Central order block for customer | AUFSD_X | CHAR | 4 | ||
| ISNATURALPERSON | Natural Person | STKZN | CHAR | 2 | ||
| AUTHORIZATIONGROUP | Authorization Group | BRGRU | CHAR | 8 | ||
| DELIVERYDATETYPERULE | Delivery Date Rule | SD_DELIVERY_DATE_TYPE_RULE | CHAR | 2 | ||
| EXPRESSTRAINSTATIONNAME | Express train station | BAHNE | CHAR | 50 | ||
| TRAINSTATIONNAME | Train station | BAHNS | CHAR | 50 | ||
| CITYLOCATIONCOORDINATESCODE | City Coordinates | LOCCO | CHAR | 20 | ||
| PLANT | Plant | WERKS_D | CHAR | 8 | ||
| CUSTOMERCORPORATEGROUP | Group key | KONZS | CHAR | 20 | ||
| DATAEXCHANGEINSTRUCTIONKEY | Instruction Key for Data Medium Exchange | DTAWS | CHAR | 4 | ||
| INDUSTRYCODE1 | Industry code 1 | BRAN1_D | CHAR | 20 | ||
| INDUSTRYCODE2 | Industry code 2 | BRAN2 | CHAR | 20 | ||
| INDUSTRYCODE3 | Industry code 3 | BRAN3 | CHAR | 20 | ||
| ISCOMPETITOR | Indicator: Competitor | DEAR1 | CHAR | 2 | ||
| ISSALESPARTNER | Indicator: Sales partner | DEAR2 | CHAR | 2 | ||
| ISDEFAULTSOLDTOPARTY | ID for default sold-to party | DEAR5 | CHAR | 2 | ||
| ISCONSUMER | Indicator: Consumer | DEAR6 | CHAR | 2 | ||
| FISCALADDRESS | Account number of the master record with the fiscal address | FISKN_D | CHAR | 20 | ||
| CITYCODE | City Code | CITYC | CHAR | 8 | ||
| COUNTY | County Code | COUNC | CHAR | 6 | ||
| FREEDEFINEDATTRIBUTE03 | Attribute 3 | KATR3 | CHAR | 4 | ||
| CUSTOMERCONDITIONGROUP1 | Customer condition group 1 | KDKG1 | CHAR | 4 | ||
| CUSTOMERCONDITIONGROUP2 | Customer condition group 2 | KDKG2 | CHAR | 4 | ||
| CUSTOMERCONDITIONGROUP3 | Customer condition group 3 | KDKG3 | CHAR | 4 | ||
| CUSTOMERCONDITIONGROUP4 | Customer condition group 4 | KDKG4 | CHAR | 4 | ||
| CUSTOMERCONDITIONGROUP5 | Customer condition group 5 | KDKG5 | CHAR | 4 | ||
| BPISEQUALIZATIONTAXSUBJECT | Checkbox | XFELD | CHAR | 2 | ||
| SALESISBLOCKEDFORCUSTOMER | Checkbox | XFELD | CHAR | 2 | ||
| LANGUAGE | Language Key | SPRAS | LANG | 2 | ||
| PAYMENTREASON | Payment Reason | FARP_PAYT_RSN | CHAR | 8 | ||
| REGION | Region (State, Province, County) | REGIO | CHAR | 6 | ||
| COUNTRY | Country/Region Key | LAND1 | CHAR | 6 | ||
| TRADINGPARTNER | Company ID of Trading Partner | RASSC | CHAR | 12 | ||
| DELETIONINDICATOR | Central Deletion Flag for Master Record | LOEVM_X | CHAR | 2 | ||
| HASACTIVEENTITY | Draft - Indicator - Has active document | SDRAFT_HAS_ACTIVE | CHAR | 2 | ||
| .INCLUDE | SDRAFT_WRITE_DRAFT_ADMIN | 0 | ||||
| DRAFTENTITYCREATIONDATETIME | Draft Created On | SDRAFT_CREATED_AT | DEC | 11 | ||
| DRAFTENTITYLASTCHANGEDATETIME | Draft Last Changed On | SDRAFT_LAST_CHANGED_AT | DEC | 11 | ||
| DRAFTADMINISTRATIVEDATAUUID | Technical ID for the Administrative Data of a Draft Document | SDRAFT_ADMIN_UUID | RAW | 16 | ||
| DRAFTENTITYCONSISTENCYSTATUS | Draft - Consistency Status | SDRAFT_CONSISTENCY_STATUS | CHAR | 2 | ||
| DRAFTENTITYOPERATIONCODE | Draft - Operation Code | SDRAFT_OPERATION_CODE | CHAR | 2 | ||
| .INCLUDE | INCL_EEW_KNA1 | 0 | ||||
| KNA1_EEW_CUST | data element for customer | KNA1_EEW_CUST | CHAR | 2 | ||
| .INCLU--AP | CRMS4_BP_KNA1 | 0 | ||||
| RULE_EXCLUSION | Account Excluded from Rule-Based Assignment | CRMT_BUS_RULE_EXCLUSION | CHAR | 2 |