_PRELIMBILLINGDOCUMENT
_PRELIMBILLINGDOCUMENT is an SAP database table in S/4HANA. It contains 88 fields.
Fields (88)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| _BillingDocumentCategory | _BillingDocumentCategory | 1 | |
| _BillingDocumentType | _BillingDocumentType | 1 | |
| _BillingIssueType | _BillingIssueType | 1 | |
| _CityCode | _CityCode | 1 | |
| _CompanyCode | _CompanyCode | 1 | |
| _Country | _Country | 1 | |
| _CreditControlArea | _CreditControlArea | 1 | |
| _CustomerAccountAssgmtGroup | _CustomerAccountAssgmtGroup | 1 | |
| _CustomerGroup | _CustomerGroup | 1 | |
| _CustomerPaymentTerms | _CustomerPaymentTerms | 1 | |
| _CustomerPriceGroup | _CustomerPriceGroup | 1 | |
| _DistributionChannel | _DistributionChannel | 1 | |
| _DunningArea | _DunningArea | 1 | |
| _DunningBlockingReason | _DunningBlockingReason | 1 | |
| _DunningKey | _DunningKey | 1 | |
| _ExchangeRateType | _ExchangeRateType | 1 | |
| _IncotermsClassification | _IncotermsClassification | 1 | |
| _IncotermsVersion | _IncotermsVersion | 1 | |
| _OverallPricingIncompletionSts | _OverallPricingIncompletionSts | 1 | |
| _OverallSDProcessStatus | _OverallSDProcessStatus | 1 | |
| _OvrlItmGeneralIncompletionSts | _OvrlItmGeneralIncompletionSts | 1 | |
| _PayerParty | _PayerParty | 1 | |
| _PaymentMethod | _PaymentMethod | 1 | |
| _PriceListType | _PriceListType | 1 | |
| _Region | _Region | 1 | |
| _SalesDistrict | _SalesDistrict | 1 | |
| _SalesOrganization | _SalesOrganization | 1 | |
| _SDDocumentCategory | _SDDocumentCategory | 1 | |
| _ShippingCondition | _ShippingCondition | 1 | |
| _SoldToParty | _SoldToParty | 1 | |
| _TaxDepartureCountry | _TaxDepartureCountry | 1 | |
| _VATRegistrationCountry | _VATRegistrationCountry | 1 | |
| _VATRegistrationOrigin | _VATRegistrationOrigin | 1 | |
| AdditionalValueDays | AdditionalValueDays | 1 | |
| BillingDocCombinationCriteria | BillingDocCombinationCriteria | 1 | |
| BillingDocumentCategory | BillingDocumentCategory | 1 | |
| BillingDocumentDate | BillingDocumentDate | 1 | |
| BillingDocumentType | BillingDocumentType | 3 | |
| CityCode | CityCode | 1 | |
| CompanyCode | CompanyCode | 1 | |
| ContractAccount | ContractAccount | 1 | |
| Country | Country | 1 | |
| County | County | 1 | |
| CreditControlArea | CreditControlArea | 1 | |
| CustomerAccountAssignmentGroup | CustomerAccountAssignmentGroup | 1 | |
| CustomerGroup | CustomerGroup | 1 | |
| CustomerPaymentTerms | CustomerPaymentTerms | 1 | |
| CustomerPriceGroup | CustomerPriceGroup | 1 | |
| CustomerTaxClassification1 | CustomerTaxClassification1 | 1 | |
| CustomerTaxClassification2 | CustomerTaxClassification2 | 1 | |
| CustomerTaxClassification3 | CustomerTaxClassification3 | 1 | |
| CustomerTaxClassification4 | CustomerTaxClassification4 | 1 | |
| CustomerTaxClassification5 | CustomerTaxClassification5 | 1 | |
| CustomerTaxClassification6 | CustomerTaxClassification6 | 1 | |
| CustomerTaxClassification7 | CustomerTaxClassification7 | 1 | |
| CustomerTaxClassification8 | CustomerTaxClassification8 | 1 | |
| CustomerTaxClassification9 | CustomerTaxClassification9 | 1 | |
| DistributionChannel | DistributionChannel | 1 | |
| DunningArea | DunningArea | 1 | |
| DunningBlockingReason | DunningBlockingReason | 1 | |
| DunningKey | DunningKey | 1 | |
| ExchangeRateType | ExchangeRateType | 1 | |
| FixedValueDate | FixedValueDate | 1 | |
| IncotermsClassification | IncotermsClassification | 1 | |
| IncotermsLocation1 | IncotermsLocation1 | 1 | |
| IncotermsLocation2 | IncotermsLocation2 | 1 | |
| IncotermsTransferLocation | IncotermsTransferLocation | 1 | |
| IncotermsVersion | IncotermsVersion | 1 | |
| IsRelevantForAccrual | IsRelevantForAccrual | 3 | |
| LastChangeDate | LastChangeDate | 1 | |
| PartnerCompany | PartnerCompany | 1 | |
| PayerParty | PayerParty | 1 | |
| PaymentMethod | PaymentMethod | 1 | |
| PaymentReference | PaymentReference | 1 | |
| PBDIsInMyResponsibility | PBDIsInMyResponsibility | 5 | |
| PriceListType | PriceListType | 1 | |
| PurchaseOrderByCustomer | PurchaseOrderByCustomer | 1 | |
| Region | Region | 1 | |
| SalesDistrict | SalesDistrict | 1 | |
| SalesOrganization | SalesOrganization | 3 | |
| SDDocumentCategory | SDDocumentCategory | 1 | |
| SDPricingProcedure | SDPricingProcedure | 1 | |
| ShippingCondition | ShippingCondition | 1 | |
| SoldToParty | SoldToParty | 1 | |
| TaxDepartureCountry | TaxDepartureCountry | 1 | |
| VATRegistration | VATRegistration | 1 | |
| VATRegistrationCountry | VATRegistrationCountry | 1 | |
| VATRegistrationOrigin | VATRegistrationOrigin | 1 |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE _PRELIMBILLINGDOCUMENT (
_BILLINGDOCUMENTCATEGORY,
_BILLINGDOCUMENTTYPE,
_BILLINGISSUETYPE,
_CITYCODE,
_COMPANYCODE,
_COUNTRY,
_CREDITCONTROLAREA,
_CUSTOMERACCOUNTASSGMTGROUP,
_CUSTOMERGROUP,
_CUSTOMERPAYMENTTERMS,
_CUSTOMERPRICEGROUP,
_DISTRIBUTIONCHANNEL,
_DUNNINGAREA,
_DUNNINGBLOCKINGREASON,
_DUNNINGKEY,
_EXCHANGERATETYPE,
_INCOTERMSCLASSIFICATION,
_INCOTERMSVERSION,
_OVERALLPRICINGINCOMPLETIONSTS,
_OVERALLSDPROCESSSTATUS,
_OVRLITMGENERALINCOMPLETIONSTS,
_PAYERPARTY,
_PAYMENTMETHOD,
_PRICELISTTYPE,
_REGION,
_SALESDISTRICT,
_SALESORGANIZATION,
_SDDOCUMENTCATEGORY,
_SHIPPINGCONDITION,
_SOLDTOPARTY,
_TAXDEPARTURECOUNTRY,
_VATREGISTRATIONCOUNTRY,
_VATREGISTRATIONORIGIN,
ADDITIONALVALUEDAYS,
BILLINGDOCCOMBINATIONCRITERIA,
BILLINGDOCUMENTCATEGORY,
BILLINGDOCUMENTDATE,
BILLINGDOCUMENTTYPE,
CITYCODE,
COMPANYCODE,
CONTRACTACCOUNT,
COUNTRY,
COUNTY,
CREDITCONTROLAREA,
CUSTOMERACCOUNTASSIGNMENTGROUP,
CUSTOMERGROUP,
CUSTOMERPAYMENTTERMS,
CUSTOMERPRICEGROUP,
CUSTOMERTAXCLASSIFICATION1,
CUSTOMERTAXCLASSIFICATION2,
CUSTOMERTAXCLASSIFICATION3,
CUSTOMERTAXCLASSIFICATION4,
CUSTOMERTAXCLASSIFICATION5,
CUSTOMERTAXCLASSIFICATION6,
CUSTOMERTAXCLASSIFICATION7,
CUSTOMERTAXCLASSIFICATION8,
CUSTOMERTAXCLASSIFICATION9,
DISTRIBUTIONCHANNEL,
DUNNINGAREA,
DUNNINGBLOCKINGREASON,
DUNNINGKEY,
EXCHANGERATETYPE,
FIXEDVALUEDATE,
INCOTERMSCLASSIFICATION,
INCOTERMSLOCATION1,
INCOTERMSLOCATION2,
INCOTERMSTRANSFERLOCATION,
INCOTERMSVERSION,
ISRELEVANTFORACCRUAL,
LASTCHANGEDATE,
PARTNERCOMPANY,
PAYERPARTY,
PAYMENTMETHOD,
PAYMENTREFERENCE,
PBDISINMYRESPONSIBILITY,
PRICELISTTYPE,
PURCHASEORDERBYCUSTOMER,
REGION,
SALESDISTRICT,
SALESORGANIZATION,
SDDOCUMENTCATEGORY,
SDPRICINGPROCEDURE,
SHIPPINGCONDITION,
SOLDTOPARTY,
TAXDEPARTURECOUNTRY,
VATREGISTRATION,
VATREGISTRATIONCOUNTRY,
VATREGISTRATIONORIGIN
);
Learn More
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA