SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

Schema:
 Module:  Table: 
Column: 
Searchbeta 

icon of database logic symbol SAP  TABLESv1Made in Britain

Home | ERP 6.0  | CIAP_D_RECORD
JDETables.com - the webs number one JD Edwards Table Definition reference

ERP 6.0: Top 10 requests

TableColumnsDescription
1TJKWE15IS-M/SD: WBZ, Order Data for Inbound Processing
2RSADMINC96Customizing Table General BW
3BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
4/OTX/RM_TELIB24Enterprise Library Server Settings
5UMV_TR1259Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction
1ERP EHP76.0CIAP_D_RECORD606CIAP Record
SQL:  selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT MANDT, ID, COMPANY_CODE, BRANCH, MATERIAL_NUMBER, CREATION_DATE, STATUS, QUOTAS_QUANTITY, LAST_DETERMINATION, WBS, INTERNAL_ORDER, FINAL_ASSET, ASSET_ID, ASSET_SUBNUMBER, GOODS_VALUE, CREDIT_FACTOR, ICMS_BASE, ICMS_VALUE, ICMS_SUB_TRIB, ICMS_DIFAL, ICMS_FREIGHT_VALUE, ICMS_FREIGHT_SUB_TRIB, ICMS_FREIGHT_DIFAL, ICMS_TOTAL, ICMS_TO_CREDIT, ICMS_NOT_CREDITED, ICMS_CREDITED, CURRENCY, CREATED_BY, LAST_CHANGED_BY, LAST_CHANGE_DATE, RETIREMENT_DATE, MANUAL, LEGACY_QUOTAS_QUANTITY, QUANTITY, UNIT_MEASURE, IN_TRANSIT, GLACCOUNT, POLICE_REPORT, RETIREMENT_OPERATION, EXTEMPORANEOUS_TYPE, JVA, MATERIAL_USAGE, INVESTMENT_STOCK, MAT_DOCUMENT, MAT_DOCUMENT_YEAR, MAT_DOCUMENT_ITEM, USEFUL_LIFE, CREATION_TYPE, MANUAL_SUSP, CREDITING_PERIOD_LIMIT, DIFAL_POSTPONED, BAPI, ACCOUNT_ASSIG_CATEGORY, IMMEDIATE_CREDIT, COMPONENT_AS_ASSET, MAIN_WBS, STOCK_AS_ASSET, NETWORK_NUMBER, ACTIVITY_NUMBER FROM CIAP_D_RECORD
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2IDCIAP Record Unique IDvarbinary160RAWNoCIAP_RECORD_ID
3COMPANY_CODECompany Codenvarchar40CHAR(N' ')YesT001BUKRS Allow NULL? 
4BRANCHBusiness Placenvarchar40CHAR(N' ')YesJ_1BBRANCHJ_1BBRANC_ Allow NULL? 
5MATERIAL_NUMBERMaterial Numbernvarchar180CHAR(N' ')YesMARAMATNR Allow NULL? 
6CREATION_DATECIAP Record Creation Datenvarchar80DATS(N'00000000')YesCIAP_CREATION_DATE Allow NULL? 
7STATUSCIAP Record Statusnvarchar20CHAR(N' ')YesCIAP_RECORD_STATUS Allow NULL? 
8QUOTAS_QUANTITYQuota Numbernvarchar40NUMC(N'0000')YesCIAP_QUOTA_NUMBER Allow NULL? 
9LAST_DETERMINATIONPeriod (Month/Year)nvarchar60NUMC(N'000000')YesCIAP_PERIOD Allow NULL? 
10WBSWork Breakdown Structure Element (WBS Element)nvarchar80NUMC(N'00000000')YesPRPSPS_PSP_PNR Allow NULL? 
11INTERNAL_ORDEROrder Numbernvarchar120CHAR(N' ')YesAUFKAUFNR Allow NULL? 
12FINAL_ASSETFinalized Assetchar10CHAR(N' ')YesCIAP_FINAL_ASSET Allow NULL? 
13ASSET_IDMain Asset Numbernvarchar120CHAR(N' ')YesANLHANLN1 Allow NULL? 
14ASSET_SUBNUMBERAsset Subnumbernvarchar40CHAR(N' ')YesANLAANLN2 Allow NULL? 
15GOODS_VALUEGoods Valuedecimal2210DEC((0))YesCIAP_GOODS_VALUE
16CREDIT_FACTORCredit Factordecimal54DEC((0))YesCIAP_CREDIT_FACTOR
17ICMS_BASEICMS Basedecimal2210DEC((0))YesCIAP_ICMS_BASE
18ICMS_VALUEICMS Valuedecimal2210DEC((0))YesCIAP_ICMS_VALUE
19ICMS_SUB_TRIBSubstituição Tributária Valuedecimal2210DEC((0))YesCIAP_SUB_TRIB_VALUE
20ICMS_DIFALDIFAL Valuedecimal2210DEC((0))YesCIAP_DIFAL_VALUE
21ICMS_FREIGHT_VALUEFreight ICMS Valuedecimal2210DEC((0))YesCIAP_FREIGHT_ICMS_VALUE
22ICMS_FREIGHT_SUB_TRIBSubstituição Tributária Valuedecimal2210DEC((0))YesCIAP_SUB_TRIB_VALUE
23ICMS_FREIGHT_DIFALDIFAL Valuedecimal2210DEC((0))YesCIAP_DIFAL_VALUE
24ICMS_TOTALICMS Total Valuedecimal2210DEC((0))YesCIAP_ICMS_TOTAL_VALUE
25ICMS_TO_CREDITICMS to Credit Valuedecimal2210DEC((0))YesCIAP_ICMS_TO_CREDIT
26ICMS_NOT_CREDITEDICMS not Crediteddecimal2210DEC((0))YesCIAP_ICMS_NOT_CREDITED
27ICMS_CREDITEDICMS Credited Valuedecimal2210DEC((0))YesCIAP_ICMS_CREDITED
28CURRENCYCurrencynvarchar50CUKY(N' ')YesTCURCCIAP_CURRENCY Allow NULL? 
29CREATED_BYCreated Bynvarchar120CHAR(N' ')YesCIAP_CREATED_BY_USERNAME Allow NULL? 
30LAST_CHANGED_BYLast Changed Bynvarchar120CHAR(N' ')YesCIAP_CHANGED_BY_USERNAME Allow NULL? 
31LAST_CHANGE_DATELast Change Datenvarchar80DATS(N'00000000')YesCIAP_CHANGING_DATE Allow NULL? 
32RETIREMENT_DATERetirement Datenvarchar80DATS(N'00000000')YesCIAP_RETIREMENT_DATE Allow NULL? 
33MANUALCIAP Manual Recordchar10CHAR(N' ')YesCIAP_RECORD_MANUAL Allow NULL? 
34LEGACY_QUOTAS_QUANTITYCredited Legacy Quotasnvarchar40NUMC(N'0000')YesCIAP_QUOTA_LEGACY_NUMBER Allow NULL? 
35QUANTITYQuantitydecimal133QUAN((0))YesJ_1BNETQTY
36UNIT_MEASUREBase unit of measurenvarchar30UNIT(N' ')Yes*J_1BNETUNT Allow NULL? 
37IN_TRANSITRecord in Transitchar10CHAR(N' ')YesCIAP_IN_TRANSIT Allow NULL? 
38GLACCOUNTG/L Account Numbernvarchar100CHAR(N' ')YesSKA1SAKNR Allow NULL? 
39POLICE_REPORTPolice Reportnvarchar2550CHAR(N' ')YesCIAP_POLICE_REPORT Allow NULL? 
40RETIREMENT_OPERATIONRetirement Operationnvarchar20CHAR(N' ')YesCIAP_RETIREMENT_OPERATION Allow NULL? 
41EXTEMPORANEOUS_TYPELate Submissionchar10CHAR(N' ')YesCIAP_EXTEMPORANEOUS Allow NULL? 
42JVACIAP JVA Recordchar10CHAR(N' ')YesCIAP_RECORD_JVA Allow NULL? 
43MATERIAL_USAGEUsage of the materialchar10CHAR(N' ')YesJ_1BMATUSE Allow NULL? 
44INVESTMENT_STOCKInvestment Stockchar10CHAR(N' ')YesCIAP_INVESTMENT_STOCK Allow NULL? 
45MAT_DOCUMENTNumber of Material Documentnvarchar100CHAR(N' ')YesMKPFMBLNR Allow NULL? 
46MAT_DOCUMENT_YEARMaterial Document Yearnvarchar40NUMC(N'0000')YesMJAHR Allow NULL? 
47MAT_DOCUMENT_ITEMItem in Material Documentnvarchar40NUMC(N'0000')YesMBLPO Allow NULL? 
48USEFUL_LIFEUseful Life in Monthsnvarchar30NUMC(N'000')YesCIAP_USEFUL_LIFE Allow NULL? 
49CREATION_TYPECIAP Record Creation Typechar10CHAR(N' ')YesCIAP_CREATION_TYPE Allow NULL? 
50MANUAL_SUSPManual Suspensionchar10CHAR(N' ')YesCIAP_MANUAL_SUSP Allow NULL? 
51CREDITING_PERIOD_LIMITCrediting Period Limitchar10CHAR(N' ')YesCIAP_CREDITING_PERIOD_LIMIT Allow NULL? 
52DIFAL_POSTPONEDDIFAL Postponedchar10CHAR(N' ')YesCIAP_DIFAL_POSTPONED Allow NULL? 
53BAPICreated via BAPIchar10CHAR(N' ')YesCIAP_BAPI Allow NULL? 
54ACCOUNT_ASSIG_CATEGORYAccount Assignment Categorychar10CHAR(N' ')YesT163KKNTTP Allow NULL? 
55IMMEDIATE_CREDITImmediate Credit Indicatorchar10CHAR(N' ')YesCIAP_IMMEDIATE_CREDIT Allow NULL? 
56COMPONENT_AS_ASSETComponent treated as an assetchar10CHAR(N' ')YesCIAP_COMPONENT_AS_ASSET Allow NULL? 
57MAIN_WBSMain WBSnvarchar80NUMC(N'00000000')YesPRPSCIAP_MAIN_WBS Allow NULL? 
58STOCK_AS_ASSETStock as assetchar10CHAR(N' ')YesCIAP_STOCK_AS_ASSET Allow NULL? 
59NETWORK_NUMBERNetwork Number for Account Assignmentnvarchar120CHAR(N' ')Yes*NPLNR Allow NULL? 
60ACTIVITY_NUMBEROperation/Activity Numbernvarchar40CHAR(N' ')YesVORNR Allow NULL? 
NamePrimaryUniqueTypeColumns
CIAP_D_RECORD~0YesYesCLUSTEREDID, MANDT
CIAP_D_RECORD~1NoNoNONCLUSTEREDSTATUS, WBS, MANDT
CIAP_D_RECORD~2NoNoNONCLUSTEREDLAST_DETERMINATION, STATUS, BRANCH, COMPANY_CODE, MANDT
CIAP_D_RECORD~3NoNoNONCLUSTEREDSTATUS, INTERNAL_ORDER, MANDT
CIAP_D_RECORD~4NoNoNONCLUSTEREDSTATUS, ASSET_SUBNUMBER, ASSET_ID, MANDT
CIAP_D_RECORD~5NoNoNONCLUSTEREDLAST_DETERMINATION, STATUS, COMPANY_CODE, MANDT

All references to SAP and SAP logo are trademarks of SAP AG in Germany, EU, USA and other territories.
No warranty is provided to data provided by this site. This website is not affiliated with, maintained, authorized, endorsed or sponsored by the SAP AG Company or any of its affiliates.
About :: Terms :: Privacy