SAP StackSAP FICOSAP HRSAP MMSAP SDSAP PMSAP PSSAP ABAPSAP NetWeaverSAP TablesSAP Tcodes ☰MENU

SAP J_1BNFCPD (Nota Fiscal one-time accounts) Table & Fields

J_1BNFCPD is a SAP table coming under CRM module and BBPCRM component.View details, Fields & related tables of J_1BNFCPD in SAP.

  • Table description : Nota Fiscal one-time accounts
  • Module : CRM-LOC-BR
  • Parent Module : CRM
  • Package : J1BA
  • Software Component : BBPCRM

Here is some free PDF files that you can download free for your reference.
Download Now

Definitions

What is SAP ?

SAP is the short form of Systems, Applications & Products in Data Processing. It is one of the largest business process related software. This software focused on business processes on ERP & CRM.

What is table in SAP ?

Like most other software, SAP also using database tables to store the data. In SAP thousands of tables are there to store different data. A table contains several fields and some of the fields will be key fields.

SAP J_1BNFCPD Table Fields structure

FieldNoteData ElementDomain
MANDTClientMANDTMANDT
DOCNUMDocument NumberJ_1BDOCNUMJ_1BDOCNUM
PARVWNota Fiscal Partner FunctionJ_1BPARVWJ_1BPARVW
NAME1Name 1NAME1_GPNAME
NAME2Name 2NAME2_GPNAME
NAME3Name 3NAME3_GPNAME
NAME4Name 4NAME4_GPNAME
PSTLZPostal CodePSTLZPSTLZ
ORT01CityORT01_GPTEXT35
LAND1Country KeyLAND1_GPLAND1
STRASHouse number and streetSTRAS_GPTEXT35
PFACHPO BoxPFACHPFACH
PSTL2P.O. Box Postal CodePSTL2PSTLZ
PSKTOAccount Number of Bank Account At Post OfficePSKTOPSKTO
BANKNBank account numberBANKNBANKN
BANKLBank KeysBANKKBANKK
BANKSBank country keyBANKSLAND1
STCD1Tax Number 1STCD1STCD1
STCD2Tax Number 2STCD2STCD2
STKZULiable for VATSTKZUXFELD
STKZAIndicator: Business Partner Subject to Equalization Tax?STKZASTKZA
REGIORegion (State, Province, County)REGIOREGIO
BKONTBank Control KeyBKONTBKONT
DTAWSInstruction key for data medium exchangeDTAWSDTAWS
DTAMSReport key for data medium exchangeDTAMSDTAMS
XCPDKIndicator: Is the account a one-time account?XCPDKXFELD
EMPFGPayee codeEMPFGEMPFG
SPRASLanguage KeySPRASSPRAS
.INCLUDEBrazilian fields in BSEC (one-time accounts)    
STKZNNatural PersonSTKZNSTKZN
J_1BSTAINSState Tax NumberJ_1BSTAINSJ_1BSTAINS
J_1BMUNINSMunicipal Tax NumberJ_1BMUNINSJ_1BMUNINS
.INCLUDEInclude structure with ADRC attributes without name fields    
NAME_COc/o nameAD_NAME_COTEXT40
CITY1CityAD_CITY1TEXT40
CITY2DistrictAD_CITY2TEXT40
CITY_CODECity code for city/street fileAD_CITYNUMCITY_CODE
CITYP_CODEDistrict code for City and Street fileAD_CITYPNMCITYP_CODE
HOME_CITYCity (different from postal city)AD_CITY3TEXT40
CITYH_CODEDifferent city for city/street fileAD_CITYHNMCITY_CODE
CHCKSTATUSCity file test statusAD_CHECKSTAD_CHECKST
REGIOGROUPRegional structure groupingREGIOGROUPREGIOGROUP
POST_CODE1City postal codeAD_PSTCD1CHAR10
POST_CODE2PO Box postal codeAD_PSTCD2CHAR10
POST_CODE3Company postal code (for large customers)AD_PSTCD3CHAR10
PCODE1_EXT(Not Supported)City Postal Code Extension, e.g. ZIP+4+2 CodeAD_PST1XTCHAR10
PCODE2_EXT(Not Supported) PO Box Postal Code ExtensionAD_PST2XTCHAR10
PCODE3_EXT(Not Supported) Major Customer Postal Code ExtensionAD_PST3XTCHAR10
PO_BOXPO BoxAD_POBXCHAR10
DONT_USE_PPO Box Address Undeliverable FlagAD_NO_USEPAD_NO_USE
PO_BOX_NUMFlag: PO Box without numberAD_POBXNUMXFELD
PO_BOX_LOCPO Box cityAD_POBXLOCTEXT40
CITY_CODE2City PO box code (City file)AD_CIT2NUMCITY_CODE
PO_BOX_REGRegion for PO Box (Country, State, Province, ...)AD_POBXREGREGIO
PO_BOX_CTYPO box countryAD_POBXCTYLAND1
POSTALAREA(Not Supported) Post Delivery DistrictAD_PSTLARTEXT15
TRANSPZONETransportation zone to or from which the goods are deliveredLZONEZONE
STREETStreetAD_STREETTEXT60
DONT_USE_SStreet Address Undeliverable FlagAD_NO_USESAD_NO_USE
STREETCODEStreet Number for City/Street FileAD_STRNUMSTRT_CODE
STREETABBR(Not Supported) Abbreviation of Street NameAD_STRABBRSTRTYPEAB
HOUSE_NUM1House NumberAD_HSNM1TEXT10
HOUSE_NUM2House number supplementAD_HSNM2TEXT10
HOUSE_NUM3(Not supported) House Number RangeAD_HSNM3TEXT10
STR_SUPPL1Street 2AD_STRSPP1TEXT40
STR_SUPPL2Street 3AD_STRSPP2TEXT40
STR_SUPPL3Street 4AD_STRSPP3TEXT40
LOCATIONStreet 5AD_LCTNTEXT40
BUILDINGBuilding (Number or Code)AD_BLDNGTEXT20
FLOORFloor in buildingAD_FLOORTEXT10
ROOMNUMBERRoom or Appartment NumberAD_ROOMNUMTEXT10
COUNTRYCountry KeyLAND1LAND1
LANGULanguage KeySPRASSPRAS
REGIONRegion (State, Province, County)REGIOREGIO
SORT1Search Term 1AD_SORT1ULTEXT20
SORT2Search Term 2AD_SORT2ULTEXT20
SORT_PHN(Not Supported) Phonetic Search Sort FieldAD_SRTPHNCHAR20
ADDRORIGIN(Not Supported) Address Data Source (Key)AD_ORIGINAAD_ORIGIN
EXTENSION1Extension (only for data conversion) (e.g. data line)AD_EXTENS1TEXT40
EXTENSION2Extension (only for data conversion) (e.g. telebox)AD_EXTENS2TEXT40
TIME_ZONEAddress time zoneAD_TZONETZNZONE
TAXJURCODETax JurisdictionAD_TXJCDAD_TXJCD
ADDRESS_ID(Not supported) Physical address IDAD_ADDR_IDAD_ADDR_ID
REMARKAddress notesAD_REMARK1TEXT50
LANGU_CREAAddress record creation original languageAD_LANGUCRSPRAS
PO_BOX_LOBBYPO Box LobbyAD_PO_BOX_LBYTEXT40
DELI_SERV_TYPEType of Delivery ServiceAD_DELIVERY_SERVICE_TYPEAD_DELIVERY_SERVICE_TYPE
DELI_SERV_NUMBERNumber of Delivery ServiceAD_DELIVERY_SERVICE_NUMBERCHAR10
COUNTY_CODECounty code for countyAD_CNTYNUMCNTY_CODE
COUNTYCountyAD_COUNTYTEXT40
TOWNSHIP_CODETownship code for TownshipAD_TWSHPNUMTWSHP_CODE
TOWNSHIPTownshipAD_TOWNSHIPTEXT40
TEL_NUMBERFirst telephone no.: dialling code+numberAD_TLNMBR1CHAR30
TEL_EXTENSFirst Telephone No.: ExtensionAD_TLXTNS1CHAR10
FAX_NUMBERFirst fax no.: dialling code+numberAD_FXNMBR1CHAR30
FAX_EXTENSFirst fax no.: extensionAD_FXXTNS1CHAR10

J_1BNFCPD related tables

TableNote
A291Land/SteuKennz.
A292BR: ISS from SD: Ship-to-City
A293Land/StKla2-Kd
A341Land/StKla3-Kd
A342Land/StKla2-Mat
A343BR: Substituiçao Tributária from SD
A344BR: ICMS base reduction carrier: Land/St. Basis/Belegart
A346Land/Dyn.Schlüssel1/Dyn.Schlüssel2/Dyn.Schlüssel3/St.-Grp.
A347Land/SF/ST/Schlüssel1/Schlüssel2/Schlüssel3/St.-Grp.
A348Land/SF/ST/XSUBT/Schlüssel1/Schlüssel2/Schlüssel3/St.-Grp.
A349Land/ST/MATNR
A374Country/Sales org./Region/PlntRegion/TaxCl3Cust/TaxCl.3Mat
A382Land/Belegart/SF/ST/Schlüssel1/Schlüssel2/Schlüssel3/St.-Grp
A392Land
A393Land/Lieferant
A394Land/Empfänger
FIAPBRD_ISPBBrazil: Febraban Bank Identification at SPB (ISPB code)
IDSDTXNUMVISSD Document Screen Control for CPD Partner Tax Numbers
J1B_ERROR_DDAMaster Table for DDA_Brazil (Segment G)
J_1BAANota Fiscal type

SAP ALECRMSCMSRMSAP SolutionsSAP ReferencesSAP BasicsPP ModuleWMSAP Partners
HomeContact & Privacy PolicyTwitter
All of the product names here are trademarks of their respective companies. The site sapstack.com is not affiliated with SAP AG.
©2021 sapstack.com