FVD_TYP_BORROWER SAP (All Data for the Partner) Structure details
Description: All Data for the Partner
Related tables to FVD_TYP_BORROWER
Access table FVD_TYP_BORROWER
Structure field list including key, data, relationships and ABAP select examples
FVD_TYP_BORROWER is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "All Data for the Partner" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_FVD_TYP_BORROWER TYPE FVD_TYP_BORROWER.
The FVD_TYP_BORROWER table consists of various fields, each holding specific information or linking keys about All Data for the Partner data available in SAP. These include MANDT (Client), SNUMOBJ (Key for number range object), SOBJEKT (Internal key for object for business partner table), PARTNR (Business Partner Number).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can Be Enhanced (Deep)
SAP FVD_TYP_BORROWER structure fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
VDGPO | 0 | ||||||||
MANDT | Client | MANDT | CLNT | 3 | MANDT | ||||
SNUMOBJ | Key for number range object | VVNUMOBJ | CHAR | 2 | VVNUMOBJ | ||||
SOBJEKT | Internal key for object for business partner table | VVSOBJGPO | CHAR | 13 | CHAR13 | ||||
PARTNR | Business Partner Number | BP_PARTNR_NEW | CHAR | 10 | ALPHA | BU_PARTNER | BPA | BUPA | |
ROLETYP | BP Role | BU_PARTNERROLE | CHAR | 6 | BU_ROLE | BUPA_ROLE | |||
DTRANS | Flow data key: System date | VVDTRANS | DATS | 8 | DATUM | ||||
DBEBEZ | Date of start of relationship | DBEBEZ | DATS | 8 | DATUM | ||||
DENBEZ | Date of end of relationship | DENBEZ | DATS | 8 | DATUM | ||||
APPL | Application Category | BP_APPL | CHAR | 4 | BP_APPL | H_TPZ12 | |||
ADR_REF | Address ID | BP_ADR_REF_NEW | CHAR | 10 | BU_ADRKIND | ||||
ROLE | CML Correspondence Role Type of Recipient | TB_ROLE_CORR | CHAR | 4 | T_ROLE_CORR | ||||
PBEZ | Percentage rate of relationship | PBEZ | DEC | 10(7) | DEC3_7 | ||||
BBEZ | Relationship amount | BBEZ | CURR | 13(2) | WERTV7 | ||||
SBBEZ | Currency Key | WAERS | CUKY | 5 | WAERS | FWS | |||
KUNNR | Customer Numbers | KUNNR | CHAR | 10 | ALPHA | KUNNR | KUN | C_KUNNR | |
GZLSCH | Payment method for credit memos | VVGZLSCH | CHAR | 1 | ZLSCH | ||||
BVTYP | Partner Bank Type | BVTYP | CHAR | 4 | BVTYP | ||||
ZLSCH | Payment Method | DZLSCH | CHAR | 1 | ZLSCH | ||||
SDUNNDOC | Type of Dunning Letter | SDUNNDOC | CHAR | 1 | SDUNNDOC | ||||
SDUNNBUC | Post Dunning Charges and Interest to This Partner | SDUNNBUC | CHAR | 1 | XFELD | ||||
NORDER | Order Number | NORDER | NUMC | 8 | NUM8 | ORD | |||
MNDID | Unique Referene to Mandate per Payment Recipient | SEPA_MNDID | CHAR | 35 | ID035 | ||||
VDGPODEB | 0 | ||||||||
MANDT | Client | MANDT | CLNT | 3 | MANDT | ||||
SNUMOBJ | Key for number range object | VVNUMOBJ | CHAR | 2 | VVNUMOBJ | ||||
SOBJEKT | Internal key for object for business partner table | VVSOBJGPO | CHAR | 13 | CHAR13 | ||||
PARTNR | Business Partner Number | BP_PARTNR_NEW | CHAR | 10 | ALPHA | BU_PARTNER | BPA | BUPA | |
ROLETYP | BP Role | BU_PARTNERROLE | CHAR | 6 | BU_ROLE | BUPA_ROLE | |||
DTRANS | Flow data key: System date | VVDTRANS | DATS | 8 | DATUM | ||||
DBEBEZ | Date of start of relationship | DBEBEZ | DATS | 8 | DATUM | ||||
DENBEZ | Date of end of relationship | DENBEZ | DATS | 8 | DATUM | ||||
EXTPARTNR | External Business Partner ID | BP_EXT_PNR | CHAR | 15 | CHAR15 | ||||
XROLETYP | BP Role Title | BU_PARTNERROLETITL | CHAR | 25 | TEXT25 | ||||
XPARTNER | Partner/address string | VVXPAADR | CHAR | 60 | CHAR60 | ||||
KUNNR | Customer Numbers | KUNNR | CHAR | 10 | ALPHA | KUNNR | KUN | C_KUNNR | |
ROLE | Business Partner Role Type | BP_ROLE | CHAR | 4 | BP_ROLE | ||||
APPL | Application Category | BP_APPL | CHAR | 4 | BP_APPL | H_TPZ12 | |||
ADR_REF | Address ID | BP_ADR_REF_NEW | CHAR | 10 | BU_ADRKIND | ||||
PBEZ | Percentage rate of relationship | PBEZ | DEC | 10(7) | DEC3_7 | ||||
BBEZ | Relationship amount | BBEZ | CURR | 13(2) | WERTV7 | ||||
SBBEZ | Currency Key | WAERS | CUKY | 5 | WAERS | FWS | |||
ZLSCH | Payment Method | DZLSCH | CHAR | 1 | ZLSCH | ||||
BVTYP | Partner Bank Type | BVTYP | CHAR | 4 | BVTYP | ||||
MABER | Dunning Area | MABER | CHAR | 2 | MABER | ||||
SDEBZUSA | Customer indicator | KZDEB | CHAR | 1 | XFELD | ||||
KNRZE | Head office account number (in branch accounts) | KNRZE | CHAR | 10 | ALPHA | KUNNR | |||
SANTART | Type of share in an object in partner role | VVSANTART | NUMC | 2 | VVSANTART | ||||
NAME1 | Name 1 | NAME1_GP | CHAR | 35 | NAME | ||||
XDEBFI | Customer transferred from FI | VVXDEBFI | CHAR | 1 | XFELD | ||||
ROLE_ALLG | BP Role | BU_PARTNERROLE | CHAR | 6 | BU_ROLE | BUPA_ROLE | |||
XROLE_ALLG | BP Role Title | BU_PARTNERROLETITL | CHAR | 25 | TEXT25 | ||||
PAY_DATA_C | Change payment method or bank cat. | PAY_DATA_C | CHAR | 1 | XFELD | ||||
SDUNNDOC | Type of Dunning Letter | SDUNNDOC | CHAR | 1 | SDUNNDOC | ||||
SDUNNBUC | Post Dunning Charges and Interest to This Partner | SDUNNBUC | CHAR | 1 | XFELD | ||||
LIFNR | Account Number of Vendor or Creditor | LIFNR | CHAR | 10 | ALPHA | LIFNR | LIF | KRED_C | |
LIFBVTYP | Partner Bank Type | BVTYP | CHAR | 4 | BVTYP | ||||
MNDID | Unique Referene to Mandate per Payment Recipient | SEPA_MNDID | CHAR | 35 | ID035 | ||||
BUT000 | 0 | ||||||||
CLIENT | Client | MANDT | CLNT | 3 | MANDT | ||||
PARTNER | Business Partner Number | BU_PARTNER | CHAR | 10 | ALPHA | BU_PARTNER | BPA | BUPA | |
TYPE | Business partner category | BU_TYPE | CHAR | 1 | BU_TYPE | BPY | |||
BPKIND | Business Partner Type | BU_BPKIND | CHAR | 4 | BU_KIND | ||||
BU_GROUP | Business Partner Grouping | BU_GROUP | CHAR | 4 | BU_GROUP | BPP | |||
BPEXT | Business Partner Number in External System | BU_BPEXT | CHAR | 20 | CHAR20 | ||||
BU_SORT1 | Search term 1 for business partner | BU_SORT1 | CHAR | 20 | BU_SORT1 | ||||
BU_SORT2 | Search term 2 for business partner | BU_SORT2 | CHAR | 20 | BU_SORT1 | ||||
SOURCE | Data Origin Types | BU_SOURCE | CHAR | 4 | BU_SOURCE | ||||
TITLE | Form-of-Address Key | AD_TITLE | CHAR | 4 | AD_TITLE | ||||
XDELE | Central Archiving Flag | BU_XDELE | CHAR | 1 | XFELD | ||||
XBLCK | Central Block for Business Partner | BU_XBLCK | CHAR | 1 | XFELD | ||||
AUGRP | Authorization Group | BU_AUGRP | CHAR | 4 | BU_AUGRP | ||||
TITLE_LET | Salutation | BU_TITLE_LET | CHAR | 50 | TEXT50 | ||||
BU_LOGSYS | Logical system | LOGSYS | CHAR | 10 | ALPHA | LOGSYS | |||
CONTACT | Business Partner: Contact Permission | BU_CONTACT | CHAR | 1 | BU_CONTACT | ||||
NOT_RELEASED | Indicator: Not Released | BU_XNOT_RELEASED | CHAR | 1 | XFELD | ||||
NOT_LG_COMPETENT | Indicator: Not Legally Competent | BU_NOT_LEG_COMPETENT | CHAR | 1 | BOOLE | ||||
PRINT_MODE | Business Partner Print Format | BU_PRINT_MODE | CHAR | 1 | BU_PRINT_MODE | ||||
BP_EEW_DUMMY | Dummy function in length 1 | DUMMY | CHAR | 1 | DUMMY | ||||
.INCLU--AP | 0 | ||||||||
NAPR | Business Partner Is a Natural Person Under the Tax Laws | BU_NATURAL_PERSON | CHAR | 1 | BU_NATURAL_PERSON | ||||
BBP_IPISP | Tax Split | BBP_J_1BINDEQU | CHAR | 1 | XFELD | ||||
.INCLU--AP | 0 | ||||||||
RATE | Cost Rate/Revenue Rate for Project Costing | DPR_TV_RATE | CHAR | 15 | DPR_RATE_TYPE | ||||
NAME_ORG1 | Name 1 of organization | BU_NAMEOR1 | CHAR | 40 | BU_NAME | ||||
NAME_ORG2 | Name 2 of organization | BU_NAMEOR2 | CHAR | 40 | BU_NAME | ||||
NAME_ORG3 | Name 3 of organization | BU_NAMEOR3 | CHAR | 40 | BU_NAME | ||||
NAME_ORG4 | Name 4 of organization | BU_NAMEOR4 | CHAR | 40 | BU_NAME | ||||
LEGAL_ENTY | BP: Legal form of organization | BU_LEGENTY | CHAR | 2 | BU_LEGENTY | H_TB019 | |||
IND_SECTOR | Industry sector | BU_INDSECT | CHAR | 10 | BU_INDSECT | H_TB023 | |||
LEGAL_ORG | Legal Entity of Organization | BU_LEGAL_ORG | CHAR | 2 | BU_LEGAL_ORG | ||||
FOUND_DAT | Date organization founded | BU_FOUND_DAT | DATS | 8 | DATUM | ||||
LIQUID_DAT | Liquidation date of organization | BU_LIQUID_DAT | DATS | 8 | |||||
LOCATION_1 | International location number (part 1) | BBBNR | NUMC | 7 | NUM07 | ||||
LOCATION_2 | International location number (Part 2) | BBSNR | NUMC | 5 | NUM05 | ||||
LOCATION_3 | Check digit for the international location number | BUBKZ | NUMC | 1 | NUM01 | ||||
NAME_LAST | Last name of business partner (person) | BU_NAMEP_L | CHAR | 40 | BU_NAME | ||||
NAME_FIRST | First name of business partner (person) | BU_NAMEP_F | CHAR | 40 | BU_NAME | ||||
NAME_LST2 | Other Last Name of a Person | BU_NAMEPL2 | CHAR | 40 | BU_NAME | ||||
NAME_LAST2 | Name at birth of business partner | BU_BIRTHNM | CHAR | 40 | BU_NAME | ||||
NAMEMIDDLE | Middle name or second forename of a person | BU_NAMEMID | CHAR | 40 | BU_NAME | ||||
TITLE_ACA1 | Academic Title: Key | AD_TITLE1 | CHAR | 4 | AD_TITLE1 | AD_TITLE1 | |||
TITLE_ACA2 | Second academic title (key) | AD_TITLE2 | CHAR | 4 | AD_TITLE1 | ||||
TITLE_ROYL | Name supplement, e.g. noble title (key) | AD_TITLES | CHAR | 4 | AD_TITLES | ||||
PREFIX1 | Name Prefix (Key) | AD_PREFIX | CHAR | 4 | AD_PREFIX | ||||
PREFIX2 | 2nd name prefix (key) | AD_PREFIX2 | CHAR | 4 | AD_PREFIX | ||||
NAME1_TEXT | Full Name | BU_NAME1TX | CHAR | 80 | TEXT80 | ||||
NICKNAME | Nickname of Business Partner (Person) | BU_NICKNAM | CHAR | 40 | BU_NAME | ||||
INITIALS | 'Middle Initial' or personal initials | AD_INITS | CHAR | 10 | CHAR10 | ||||
NAMEFORMAT | Name format | AD_FORMAT | CHAR | 2 | AD_NAMFORM | ||||
NAMCOUNTRY | Country for name format rule | AD_NAMCTRY | CHAR | 3 | LAND1 | ||||
LANGU_CORR | Business Partner: Correspondence Language | BU_LANGU_CORR | LANG | 1 | ISOLA | SPRAS | |||
XSEXM | Selection: Business partner is male | BU_XSEXM | CHAR | 1 | XFELD | ||||
XSEXF | Selection: Business partner is female | BU_XSEXF | CHAR | 1 | XFELD | ||||
BIRTHPL | Birthplace of business partner | BU_BIRTHPL | CHAR | 40 | TEXT40 | ||||
MARST | Marital Status of Business Partner | BU_MARST | CHAR | 1 | BU_MARST | ||||
EMPLO | Name of Employer of a Natural Person | BU_EMPLO | CHAR | 35 | BU_EMPLO | ||||
JOBGR | Occupation/group | BU_JOBGR | CHAR | 4 | BU_JOBGR | ||||
NATIO | Nationality | BU_NATIO | CHAR | 3 | LAND1 | ||||
CNTAX | Obsolete Field | BU_CNTAX | CHAR | 3 | LAND1 | ||||
CNDSC | Ctry of Origin: Non-Res. Companies | BU_CNDSC | CHAR | 3 | LAND1 | ||||
PERSNUMBER | Person number | AD_PERSNUM | CHAR | 10 | ALPHA | AD_PERSNUM | CDT | ADDRESS | |
XSEXU | Selection: Sex of business partner is not known | BU_XSEXU | CHAR | 1 | XFELD | ||||
XUBNAME | Obsolete Field | BU_XUBNAME | CHAR | 12 | XUBNAME | ||||
BU_LANGU | Business partner: Language | BU_LANGU | LANG | 1 | ISOLA | SPRAS | |||
BIRTHDT | Date of Birth of Business Partner | BU_BIRTHDT | DATS | 8 | DATUM | ||||
DEATHDT | Date of death of business partner | BU_DEATHDT | DATS | 8 | DATUM | ||||
PERNO | Personnel Number | BU_PERNO | NUMC | 8 | PERSONID | ||||
CHILDREN | Obsolete Field | BU_CHILDREN | NUMC | 2 | NUMC2 | ||||
MEM_HOUSE | Obsolete Field | BU_MEM_HOUSE | DEC | 2 | DEC2 | ||||
PARTGRPTYP | Group type | BU_GRPTYP | CHAR | 4 | BU_GRPTYP | H_TB025 | |||
NAME_GRP1 | Name 1 (group) | BU_NAMEGR1 | CHAR | 40 | BU_NAME | ||||
NAME_GRP2 | Name 2 (group) | BU_NAMEGR2 | CHAR | 40 | BU_NAME | ||||
MC_NAME1 | Search Help Field 1 (Name 1/Last Name) | BU_MCNAME1 | CHAR | 35 | CHAR35 | ||||
MC_NAME2 | Search Help Field 2 (Name 2/First Name) | BU_MCNAME2 | CHAR | 35 | CHAR35 | ||||
CRUSR | User who created the object | BU_CRUSR | CHAR | 12 | USNAM | ||||
CRDAT | Date on which the object was created | BU_CRDAT | DATS | 8 | DATUM | ||||
CRTIM | Time at which the object was created | BU_CRTIM | TIMS | 6 | UZEIT | ||||
CHUSR | Last user to change object | BU_CHUSR | CHAR | 12 | USNAM | ||||
CHDAT | Date when object was last changed | BU_CHDAT | DATS | 8 | DATUM | ||||
CHTIM | Time at which object was last changed | BU_CHTIM | TIMS | 6 | UZEIT | ||||
PARTNER_GUID | Business Partner GUID | BU_PARTNER_GUID | RAW | 16 | SYSUUID | ||||
ADDRCOMM | Address Number | BU_ADDRCOMM | CHAR | 10 | ALPHA | AD_ADDRNUM | ADR | ||
TD_SWITCH | Planned Change Documents for Partner Were Converted | BU_TD_SWITCH | CHAR | 1 | CHAR1 | ||||
IS_ORG_CENTRE | Indicator: Business Partner Is Also an Organizational Center | BU_IS_ORG_CENTRE | CHAR | 1 | BU_IS_ORG_CENTRE | ||||
DB_KEY | UUID in X form (binary) | SYSUUID_X | RAW | 16 | SYSUUID | ||||
VALID_FROM | Validity Start BUT000 BP Data | BU_BP_VALID_FROM | DEC | 15 | TZNTSTMPS | ||||
VALID_TO | Validity End BUT000 BP Data | BU_BP_VALID_TO | DEC | 15 | TZNTSTMPS | ||||
XPCPT | Business Purpose Completed Flag | BU_XPCPT | CHAR | 1 | BU_XPCPT | ||||
.INCLU--AP | 0 | ||||||||
NATPERS | Business Partner Is a Natural Person Under the Tax Laws | BU_NATURAL_PERSON | CHAR | 1 | BU_NATURAL_PERSON | ||||
.INCLU--AP | 0 | ||||||||
PAR_REL | Business Partner Released | BP_PAR_REL | CHAR | 1 | BP_PAR_REL | ||||
BP_SORT | Sort Field for Phonetic Search; Obsolete | BP_SORT_PH | CHAR | 20 | CHAR20 | ||||
.INCLU--AP | 0 | ||||||||
KBANKS | Bank country key | BANKS | CHAR | 3 | LAND1 | BKL | |||
KBANKL | Bank Keys | BANKK | CHAR | 15 | BANKK | BNK | |||
.INCLU--AP | 0 | ||||||||
BUT0BK | 0 | ||||||||
KNA1 | 0 | ||||||||
MANDT | Client | MANDT | CLNT | 3 | MANDT | ||||
KUNNR | Customer Numbers | KUNNR | CHAR | 10 | ALPHA | KUNNR | KUN | C_KUNNR | |
LAND1 | Country Key | LAND1_GP | CHAR | 3 | LAND1 | C_LAND1 | |||
NAME1 | Name 1 | NAME1_GP | CHAR | 35 | NAME | ||||
NAME2 | Name 2 | NAME2_GP | CHAR | 35 | NAME | ||||
ORT01 | City | ORT01_GP | CHAR | 35 | TEXT35 | ||||
PSTLZ | Postal Code | PSTLZ | CHAR | 10 | PSTLZ | ||||
REGIO | STATE (State, Province, County) | REGIO | CHAR | 3 | REGIO | ||||
SORTL | Sort field | SORTL | CHAR | 10 | CHAR10 | ||||
STRAS | House number and street | STRAS_GP | CHAR | 35 | TEXT35 | ||||
TELF1 | First telephone number | TELF1 | CHAR | 16 | TEXT16 | ||||
TELFX | Fax Number | TELFX | CHAR | 31 | TEXT31 | ||||
XCPDK | Indicator: Is the account a one-time account? | XCPDK | CHAR | 1 | XFELD | ||||
ADRNR | Address | ADRNR | CHAR | 10 | ALPHA | ADRNR | |||
MCOD1 | Search term for matchcode search | MCDD1 | CHAR | 25 | CHAR25 | ||||
MCOD2 | Search Term for Matchcode Search | MCDD2 | CHAR | 25 | CHAR25 | ||||
MCOD3 | Search term for matchcode search | MCDD3 | CHAR | 25 | CHAR25 | ||||
ANRED | Title | ANRED | CHAR | 15 | TEXT15 | ||||
AUFSD | Central order block for customer | AUFSD_X | CHAR | 2 | KAUFS | ||||
BAHNE | Express train station | BAHNE | CHAR | 25 | BAHNH | ||||
BAHNS | Train station | BAHNS | CHAR | 25 | BAHNH | ||||
BBBNR | International location number (part 1) | BBBNR | NUMC | 7 | NUM07 | ||||
BBSNR | International location number (Part 2) | BBSNR | NUMC | 5 | NUM05 | ||||
BEGRU | Authorization Group | BRGRU | CHAR | 4 | BRGRU | ||||
BRSCH | Industry key | BRSCH | CHAR | 4 | BRSCH | ||||
BUBKZ | Check digit for the international location number | BUBKZ | NUMC | 1 | NUM01 | ||||
DATLT | Data communication line no. | DATLT | CHAR | 14 | TEXT14 | ||||
ERDAT | Date on which the Record Was Created | ERDAT_RF | DATS | 8 | DATUM | ||||
ERNAM | Name of Person who Created the Object | ERNAM_RF | CHAR | 12 | USNAM | ||||
EXABL | Indicator: Unloading points exist | EXABL | CHAR | 1 | XFELD | ||||
FAKSD | Central billing block for customer | FAKSD_X | CHAR | 2 | FAKSP | ||||
FISKN | Account number of the master record with the fiscal address | FISKN_D | CHAR | 10 | ALPHA | KUNNR | |||
KNAZK | Working Time Calendar | KNAZK | CHAR | 2 | WFCID | ||||
KNRZA | Account number of an alternative payer | KNRZA | CHAR | 10 | ALPHA | KUNNR | |||
KONZS | Group key | KONZS | CHAR | 10 | KONZS | ||||
KTOKD | Customer Account Group | KTOKD | CHAR | 4 | KTOKD | KGD | |||
KUKLA | Customer classification | KUKLA | CHAR | 2 | KUKLA | ||||
LIFNR | Account Number of Vendor or Creditor | LIFNR | CHAR | 10 | ALPHA | LIFNR | LIF | KRED_C | |
LIFSD | Central delivery block for the customer | LIFSD_X | CHAR | 2 | LIFSP | ||||
LOCCO | City Coordinates | LOCCO | CHAR | 10 | LOCCO | ||||
LOEVM | Central Deletion Flag for Master Record | LOEVM_X | CHAR | 1 | XFELD | ||||
NAME3 | Name 3 | NAME3_GP | CHAR | 35 | NAME | ||||
NAME4 | Name 4 | NAME4_GP | CHAR | 35 | NAME | ||||
NIELS | Nielsen ID | NIELS | CHAR | 2 | NIELS | ||||
ORT02 | District | ORT02_GP | CHAR | 35 | TEXT35 | ||||
PFACH | PO Box | PFACH | CHAR | 10 | PFACH | ||||
PSTL2 | P.O. Box Postal Code | PSTL2 | CHAR | 10 | PSTLZ | ||||
COUNC | County Code | COUNC | CHAR | 3 | COUNC | ||||
CITYC | City Code | CITYC | CHAR | 4 | CITYC | ||||
RPMKR | Regional Market | RPMKR | CHAR | 5 | RPMKR | ||||
SPERR | Central posting block | SPERB_X | CHAR | 1 | XFELD | ||||
SPRAS | Language Key | SPRAS | LANG | 1 | ISOLA | SPRAS | SPR | H_T002 | |
STCD1 | Tax Number 1 | STCD1 | CHAR | 16 | STCD1 | ||||
STCD2 | Tax Number 2 | STCD2 | CHAR | 11 | STCD2 | ||||
STKZA | Indicator: Business Partner Subject to Equalization Tax? | STKZA | CHAR | 1 | STKZA | ||||
STKZU | Liable for VAT | STKZU | CHAR | 1 | XFELD | ||||
TELBX | Telebox number | TELBX | CHAR | 15 | TEXT15 | ||||
TELF2 | Second telephone number | TELF2 | CHAR | 16 | TEXT16 | ||||
TELTX | Teletex number | TELTX | CHAR | 30 | TEXT30 | ||||
TELX1 | Telex number | TELX1 | CHAR | 30 | TEXT30 | ||||
LZONE | Transportation zone to or from which the goods are delivered | LZONE | CHAR | 10 | ZONE | ||||
XZEMP | Indicator: Is an alternative payer allowed in document? | XREGU | CHAR | 1 | XFELD | ||||
VBUND | Company ID of trading partner | RASSC | CHAR | 6 | ALPHA | RCOMP | PGS | ||
STCEG | VAT Registration Number | STCEG | CHAR | 20 | STCEG | ||||
DEAR1 | Indicator: Competitor | DEAR1 | CHAR | 1 | XFELD | ||||
DEAR2 | Indicator: Sales partner | DEAR2 | CHAR | 1 | XFELD | ||||
DEAR3 | Indicator: Sales prospect | DEAR3 | CHAR | 1 | DEAR3 | ||||
DEAR4 | Indicator for customer type 4 | DEAR4 | CHAR | 1 | XFELD | ||||
DEAR5 | ID for default sold-to party | DEAR5 | CHAR | 1 | XFELD | ||||
GFORM | Legal status | GFORM | CHAR | 2 | GFORM | ||||
BRAN1 | Industry Code 1 | BRAN1_D | CHAR | 10 | BRACO | ||||
BRAN2 | Industry code 2 | BRAN2 | CHAR | 10 | BRACO | ||||
BRAN3 | Industry code 3 | BRAN3 | CHAR | 10 | BRACO | ||||
BRAN4 | Industry code 4 | BRAN4 | CHAR | 10 | BRACO | ||||
BRAN5 | Industry code 5 | BRAN5 | CHAR | 10 | BRACO | ||||
EKONT | Initial contact | EKONT | CHAR | 10 | ALPHA | VBELN | |||
UMSAT | Annual sales | UMSAT | CURR | 8(2) | UMSAT | ||||
UMJAH | Year For Which Sales are Given | UMJAH | NUMC | 4 | JAHR | ||||
UWAER | Currency of sales figure | UWAER | CUKY | 5 | WAERS | ||||
JMZAH | Yearly number of employees | JMZAH | NUMC | 6 | JMZAH | ||||
JMJAH | Year for which the number of employees is given | JMJAH | NUMC | 4 | JAHR | ||||
KATR1 | Attribute 1 | KATR1 | CHAR | 2 | ATTR1 | ||||
KATR2 | Attribute - 2 | KATR2 | CHAR | 2 | ATTR2 | ||||
KATR3 | Attribute 3 | KATR3 | CHAR | 2 | ATTR3 | ||||
KATR4 | Attribute 4 | KATR4 | CHAR | 2 | ATTR4 | ||||
KATR5 | Attribute 5 | KATR5 | CHAR | 2 | ATTR5 | ||||
KATR6 | Attribute 6 | KATR6 | CHAR | 3 | ATTR6 | ||||
KATR7 | Attribute 7 | KATR7 | CHAR | 3 | ATTR7 | ||||
KATR8 | Attribute 8 | KATR8 | CHAR | 3 | ATTR8 | ||||
KATR9 | Attribute 9 | KATR9 | CHAR | 3 | ATTR9 | ||||
KATR10 | Attribute 10 | KATR10 | CHAR | 3 | ATTR10 | ||||
STKZN | Natural Person | STKZN | CHAR | 1 | STKZN | ||||
UMSA1 | Annual sales | UMSA1 | CURR | 15(2) | UMSA1 | ||||
TXJCD | Tax Jurisdiction | TXJCD | CHAR | 15 | TXJCD | TXJ | |||
PERIV | Fiscal Year Variant | PERIV | CHAR | 2 | PERIV | ||||
ABRVW | Usage Indicator | ABRVW | CHAR | 3 | ABRVW | ||||
INSPBYDEBI | Inspection Carried Out By Customer (No Inspection Lot) | QINSPBYDEB | CHAR | 1 | QKZ | ||||
INSPATDEBI | Inspection for a Delivery Note After Outbound Delivery | QINSPATDEB | CHAR | 1 | QKZ | ||||
KTOCD | Reference Account Group for One-Time Account (Customer) | KTOCD | CHAR | 4 | KTOKD | ||||
PFORT | PO Box city | PFORT_GP | CHAR | 35 | TEXT35 | ||||
WERKS | Plant | WERKS_D | CHAR | 4 | WERKS | WRK | H_T001W_C | ||
DTAMS | Indicator for Data Medium Exchange | DTAMS | CHAR | 1 | DTAMS | ||||
DTAWS | Instruction key for data medium exchange | DTAWS | CHAR | 2 | DTAWS | ||||
DUEFL | Status of Data Transfer into Subsequent Release | DUEFL_BKPF | CHAR | 1 | DUEFL_BKPF | ||||
HZUOR | Assignment to Hierarchy | HZUOR | NUMC | 2 | HZUOR | ||||
SPERZ | Payment Block | SPERZ | CHAR | 1 | XFELD | ||||
ETIKG | IS-R Labeling: customer/plant group | ETIKG | CHAR | 10 | ETIKG | ||||
CIVVE | ID for mainly non-military use | CIVVE | CHAR | 1 | XFELD | ||||
MILVE | ID for mainly military use | MILVE | CHAR | 1 | XFELD | ||||
KDKG1 | Customer condition group 1 | KDKG1 | CHAR | 2 | KDKGR | ||||
KDKG2 | Customer condition group 2 | KDKG2 | CHAR | 2 | KDKGR | ||||
KDKG3 | Customer condition group 3 | KDKG3 | CHAR | 2 | KDKGR | ||||
KDKG4 | Customer condition group 4 | KDKG4 | CHAR | 2 | KDKGR | ||||
KDKG5 | Customer condition group 5 | KDKG5 | CHAR | 2 | KDKGR | ||||
XKNZA | Indicator: Alternative payer using account number | XKNZA | CHAR | 1 | XFELD | ||||
FITYP | Tax type | J_1AFITP_D | CHAR | 2 | J_1AFITP | ||||
STCDT | Tax Number Type | J_1ATOID | CHAR | 2 | J_1ATOID | ||||
STCD3 | Tax Number 3 | STCD3 | CHAR | 18 | CHAR18 | ||||
STCD4 | Tax Number 4 | STCD4 | CHAR | 18 | CHAR18 | ||||
STCD5 | Tax Number 5 | STCD5 | CHAR | 60 | CHAR60 | ||||
XICMS | Customer is ICMS-exempt | J_1BTCICMS | CHAR | 1 | XFELD | ||||
XXIPI | Customer is IPI-exempt | J_1BTCIPI | CHAR | 1 | XFELD | ||||
XSUBT | Customer group for Substituiçao Tributária calculation | J_1BTCST | CHAR | 3 | J_1BTCST1 | ||||
CFOPC | Customer's CFOP category | J_1BINDUS1 | CHAR | 2 | ALPHA | J_1BINDUS1 | |||
TXLW1 | Tax law: ICMS | J_1BTAXLW1 | CHAR | 3 | ALPHA | J_1BTAXLW1 | |||
TXLW2 | Tax law: IPI | J_1BTAXLW2 | CHAR | 3 | ALPHA | J_1BTAXLW2 | |||
CCC01 | Indicator for biochemical warfare for legal control | CCC01 | CHAR | 1 | XFELD | ||||
CCC02 | Indicator for nuclear nonproliferation for legal control | CCC02 | CHAR | 1 | XFELD | ||||
CCC03 | Indicator for national security for legal control | CCC03 | CHAR | 1 | XFELD | ||||
CCC04 | Indicator for missile technology for legal control | CCC04 | CHAR | 1 | XFELD | ||||
CASSD | Central sales block for customer | CASSD_X | CHAR | 2 | CASSP | ||||
KNURL | Uniform Resource Locator | URL | CHAR | 132 | TEXT132 | ||||
J_1KFREPRE | Name of Representative | REPRES | CHAR | 10 | REPRES | ||||
J_1KFTBUS | Type of Business | GESTYP | CHAR | 30 | GESTYP | ||||
J_1KFTIND | Type of Industry | INDTYP | CHAR | 30 | INDTYP | ||||
CONFS | Status of Change Authorization (Central) | CONFS_X | CHAR | 1 | CHAR1 | ||||
UPDAT | Date on Which the Changes Were Confirmed | UPDAT_RF | DATS | 8 | DATUM | ||||
UPTIM | Time of Last Change Confirmation | UPTIM_RF | TIMS | 6 | AS4TIME | ||||
NODEL | Central deletion block for master record | NODEL_X | CHAR | 1 | XFELD | ||||
DEAR6 | Indicator: Consumer | DEAR6 | CHAR | 1 | XFELD | ||||
SUFRAMA | Suframa Code | J_1BSUFRAMA | CHAR | 9 | J_1BSUFRAMA | ||||
RG | RG Number | J_1BRG | CHAR | 11 | J_1BRG | ||||
EXP | Issued by | J_1BEXP | CHAR | 3 | J_1BEXP | ||||
UF | State | J_1BUF | CHAR | 2 | J_1BUF | ||||
RGDATE | RG Issue Date | J_1BRGDATE | DATS | 8 | DATUM | ||||
RIC | RIC Number | J_1BRIC | NUMC | 11 | J_1BRIC | ||||
RNE | Foreign National Registration | J_1BRNE | CHAR | 10 | J_1BRNE | ||||
RNEDATE | RNE Issue Date | J_1BRNEDATE | DATS | 8 | DATUM | ||||
CNAE | CNAE | J_1BCNAE | CHAR | 7 | J_1BCNAE | ||||
LEGALNAT | Legal Nature | J_1BLEGALNAT | NUMC | 4 | J_1BLEGALNAT | ||||
CRTN | CRT Number | J_1BCRTN | CHAR | 1 | J_1BCRTN | ||||
ICMSTAXPAY | ICMS Taxpayer | J_1BICMSTAXPAY | CHAR | 2 | J_1BICMSTAXPAY | ||||
INDTYP | Industry Main Type | J_1BINDTYP | CHAR | 2 | J_1BINDTYP | ||||
TDT | Tax Declaration Type | J_1BTDT | CHAR | 2 | J_1BTDT | ||||
COMSIZE | Company Size | J_1BCOMSIZE | CHAR | 2 | J_1BCOMSIZE | ||||
DECREGPC | Declaration Regimen for PIS/COFINS | J_1BDECREGPC | CHAR | 2 | J_1BDECREGPC | ||||
.INCLU--AP | 0 | ||||||||
/VSO/R_PALHGT | Maximum Stacking Height of the Packaging Material (VSO) | /VSO/R_PAL_BIN_HGT | QUAN | 13(3) | MENG13 | ||||
/VSO/R_PAL_UL | Unit of Length for Packaging Material (VSO) | /VSO/R_PAL_UNIT_L | UNIT | 3 | CUNIT | MEINS | |||
/VSO/R_PK_MAT | Customer-Related Packing for Each Packaging Material (VSO) | /VSO/M_PACK_BY_MAT | CHAR | 1 | /VSO/M_XFIELD | ||||
/VSO/R_MATPAL | Packaging Material of the Customer in VSO | /VSO/M_MATNR_PAL | CHAR | 18 | MATN1 | MATNR | |||
/VSO/R_I_NO_LYR | Number Layers Under an Inter-Pallet (VSO) | /VSO/M_IPAL_NO_LYR | NUMC | 2 | /VSO/M_IPAL_NO_LYR | ||||
/VSO/R_ONE_MAT | Packing Material-Specific for Each Packaging Material | /VSO/M_ONE_MAT | CHAR | 1 | /VSO/M_XFIELD | ||||
/VSO/R_ONE_SORT | Pack Only One Package Type for Each PKM (VSO) | /VSO/M_ONE_SORT | CHAR | 1 | /VSO/M_XFIELD | ||||
/VSO/R_ULD_SIDE | Side Preference of Loading/Unloading (VSO) | /VSO/M_UNLOAD_SIDE_PREF | NUMC | 1 | /VSO/M_SIDE_PREF | ||||
/VSO/R_LOAD_PREF | Front/Back Preference of Loading/Unloading (VSO) | /VSO/M_LOAD_PREF | NUMC | 1 | /VSO/M_LOAD_PREF | ||||
/VSO/R_DPOINT | Collective Unloading Point for VSO | /VSO/R_DELIVERYPOINT | CHAR | 10 | /VSO/R_DELIVERYPOINT | /VSO/R_SH_DPOINT | |||
.INCLU--AP | 0 | ||||||||
/XLSO/CUSTOMER | Data element to differentiate customer | /XLSO/E_CUSTOMER | CHAR | 1 | /XLSO/D_CUSTOMER | ||||
/XLSO/SYSID | Name of SAP System | SYSYSID | CHAR | 8 | SYCHAR08 | ||||
/XLSO/CLIENT | Client | MANDT | CLNT | 3 | MANDT | ||||
/XLSO/PARTNER | Business Partner Number | BU_PARTNER | CHAR | 10 | ALPHA | BU_PARTNER | BPA | BUPA | |
/XLSO/PREF_PAY | Version Number Component | CHAR2 | CHAR | 2 | CHAR2 | ||||
.INCLU--AP | 0 | ||||||||
ALC | Agency Location Code | FMFG_ALC | CHAR | 8 | FMFG_ALC | FMFG_ALC | |||
PMT_OFFICE | Payment Office | FMFG_PMT_OFF | CHAR | 5 | FMFG_PMT_OFF | FMFG_PMT_OFFICE | |||
FEE_SCHEDULE | Fee schedule | FM_FEE_SCHED | CHAR | 4 | FM_FEE_SCHED | FM_FEE_SCHEDULE | |||
DUNS | DUNS Number | FMCCRDUNS | CHAR | 9 | |||||
DUNS4 | DUNS+4 | FMCCRDUNS4 | CHAR | 4 | |||||
.INCLU--AP | 0 | ||||||||
PSOFG | Processor group | PSOFG | CHAR | 10 | PSOFG | ||||
PSOIS | Subledger acct preprocessing procedure | PSOIS | CHAR | 20 | CHAR20 | ||||
PSON1 | Name 1 | NAME1_GP | CHAR | 35 | NAME | ||||
PSON2 | Name 2 | NAME2_GP | CHAR | 35 | NAME | ||||
PSON3 | Name 3 | NAME3_GP | CHAR | 35 | NAME | ||||
PSOVN | First Name | PSOVN | CHAR | 35 | NAME | ||||
PSOTL | Title | PSOTL | CHAR | 20 | FMPSOTL | ||||
PSOHS | House number: is no longer used from Release 4.6B | PSOHS | CHAR | 6 | CHAR06 | ||||
PSOST | Street: No longer used from Release 4.6B | PSOST | CHAR | 28 | PSOST | ||||
PSOO1 | Description | PSOO1 | CHAR | 50 | TEXT50 | ||||
PSOO2 | Description | PSOO1 | CHAR | 50 | TEXT50 | ||||
PSOO3 | Description | PSOO1 | CHAR | 50 | TEXT50 | ||||
PSOO4 | Description | PSOO1 | CHAR | 50 | TEXT50 | ||||
PSOO5 | Description | PSOO1 | CHAR | 50 | TEXT50 | ||||
.INCLU--AP | 0 | ||||||||
J_3GETYP | Recipient Type | J_3GETYP | CHAR | 2 | J_3GETYP | ||||
J_3GREFTYP | Reference Type for Recipient | J_3GREFTYP | CHAR | 2 | J_3GREFTYP | ||||
PSPNR | WBS Element | PS_POSNR | NUMC | 8 | ABPSP | PS_POSNR | |||
COAUFNR | Order Number | AUFNR | CHAR | 12 | ALPHA | AUFNR | ANR | ||
J_3GAGEXT | External Sold-to Party | J_3GAGEXT | CHAR | 10 | ALPHA | KUNNR | |||
J_3GAGINT | Customer Internal Settlement | J_3GAGINT | CHAR | 10 | ALPHA | KUNNR | |||
J_3GAGDUMI | Dummy Recipient | J_3GDEMPST | CHAR | 10 | ALPHA | KUNNR | |||
J_3GAGSTDI | Standard Recipient | J_3GAGSTDI | CHAR | 10 | ALPHA | KUNNR | |||
LGORT | Storage Location | LGORT_D | CHAR | 4 | LGORT | LAG | |||
KOKRS | Controlling Area | KOKRS | CHAR | 4 | CACCD | CAC | |||
KOSTL | Cost Center | KOSTL | CHAR | 10 | ALPHA | KOSTL | KOS | ||
J_3GABGLG | Retirement Date Counts for Performance-Based Equipment | J_3GABGLG | CHAR | 1 | X | ||||
J_3GABGVG | Retirement Date Counts for Time-Based Equipment | J_3GABGVG | CHAR | 1 | X | ||||
J_3GABRART | Settlement Type | J_3GABRART | CHAR | 1 | J_3GABRART | ||||
J_3GSTDMON | Hours per Month | J_3GSTDMON | DEC | 5(2) | DEC03_2 | ||||
J_3GSTDTAG | Hours per Day | J_3GSTDTAG | DEC | 5(2) | DEC03_2 | ||||
J_3GTAGMON | Number of Days/Month | J_3GTAGMON | DEC | 5(2) | DEC3_2 | ||||
J_3GZUGTAG | Function for Settlement on Acquisition Date/PBE | J_3GZUGTAG | CHAR | 1 | X | ||||
J_3GMASCHB | 'Fill PBE Documents' Indicator | J_3GMASCHB | CHAR | 1 | J_3GMASCHB | ||||
J_3GMEINSA | Indicator: Take Multiple Usage Periods into Account | J_3GMEINSA | CHAR | 1 | X | ||||
J_3GKEINSA | Indicator - Relevant to Short Operation Periods | J_3GKEINSA | CHAR | 1 | X | ||||
J_3GBLSPER | Blocking Indicator for Document Entry | J_3GBLSPER | CHAR | 1 | X | ||||
J_3GKLEIVO | Indicator: Calculate PBE as TBE | J_3GKLEIVO | CHAR | 1 | X | ||||
J_3GCALID | Calendar ID | J_3GCALID | CHAR | 2 | WFCID | ||||
J_3GVMONAT | Indicator for Complete Month | J_3GVMONAT | NUMC | 1 | J_3GVMONAT | ||||
J_3GABRKEN | Settlement Indicator | J_3GABRKEN | CHAR | 1 | J_3GABRKEN | ||||
J_3GLABRECH | Date of Last Settlement | J_3GLABRECH | DATS | 8 | DATUM | ||||
J_3GAABRECH | Date of Current Settlement | J_3GAABRECH | DATS | 8 | DATUM | ||||
J_3GZUTVHLG | Ind.: Acquisition Date Counts (as Daily Settlement for PBE) | J_3GZUTVHLG | CHAR | 1 | X | ||||
J_3GNEGMEN | Negative Quantities Allowed Even for Chronolog. Inv. Mgmt | J_3GNEGMEN | CHAR | 1 | X | ||||
J_3GFRISTLO | Indicator: Deadline Logic | J_3GFRISTLO | CHAR | 1 | X | ||||
J_3GEMINBE | Minimum Usage Period for Restricted Usage (Days) | J_3GEMINBE | NUMC | 5 | NUMC | ||||
J_3GFMGUE | Release Notification Allowance for Unrestricted Usage (Days) | J_3GFMGUE | NUMC | 5 | NUMC | ||||
J_3GZUSCHUE | Surcharge for Unrestricted Usage (Days) | J_3GZUSCHUE | NUMC | 5 | NUMC | ||||
J_3GSCHPRS | Indicator: Shift Price | J_3GSCHPRS | CHAR | 1 | X | ||||
J_3GINVSTA | Status of Construction Site Inventory | J_3GINVSTA | CHAR | 1 | J_3GINVSTA | ||||
/SAPCEM/DBER | Planning Area | /SAPCEM/DBER | CHAR | 8 | /SAPCEM/DBER | ||||
/SAPCEM/KVMEQ | Indicator: Settlement Qty Relevant to Equipment | /SAPCEM/KVMEQ | CHAR | 1 | /SAPCEM/KVMEQ | ||||
.INCLU--AP | 0 | ||||||||
OIDRC | Differential Reference Code (DRC) | OIC_DRC | CHAR | 5 | NUMCV | OIC_DRC | |||
.INCLU--AP | 0 | ||||||||
OID_POREQD | Purchase order required: X = Yes, Blank = No | OID_POREQD | CHAR | 1 | OI0_XFELD | ||||
.INCLU--AP | 0 | ||||||||
OIPBL | Business location identifier (IS-Oil MRN) | OIF_PBLNR | CHAR | 10 | ALPHA | OIF_PBLNR | OI0 | OIFB | |
.INCLU--AP | 0 | ||||||||
ADDRESS_SHORT_FORM | One-line short form of formatted address | AD_LINE_S | CHAR | 80 | CHAR80 |
Key field | Non-key field |
How do I retrieve data from SAP structure FVD_TYP_BORROWER using ABAP code?
As FVD_TYP_BORROWER is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on FVD_TYP_BORROWER as there is no data to select.How to access SAP table FVD_TYP_BORROWER
Within an ECC or HANA version of SAP you can also view further information about FVD_TYP_BORROWER and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects